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
|