View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Nested if function

Something like:

=if(K1="TRUE",min(b1:b13),"what you want displayed when K is FALSE")

Regards,
Fred.

"Steve M" wrote in message
...
I want to return the minimum value of about 13 cells in a column (column
B). I only want to include values where the text in column K is TRUE (based
on a different IF formula from another cell).
TIA