Let me explain in words what I am trying to do since I am not communicating
well with functions. I have several employees that run production routes.
Their production totals are in column B. I only want to compare the
production for employees certain types of equipment. They use different
equipment on different days. I haven't discussed it, but I use an OR formula
to give me a true or false (based on whether they are using the equipment
whose production I want included in the MIN or MAX comparisons). The OR
formulas returning TRUE or FALSE are in column K. I just want to find the
MIN for the employees that are using certain equipment (in other words that
the OR formula returns TRUE for in column K).
Thank you for your patience.
"Fred Smith" wrote in message
...
What do you want to happen when a cell is TRUE, and what when it's FALSE?
Do you, for example, want to find the Max of only the TRUEs? Or something
else?

Fred

"Steve M" wrote in message
...
I need the formula to look for "TRUE" in EACH row to determine whether or
not to use the figure in column B. This formula did not
work--=IF(K7:K18="TRUE",MAX(B7,B8,B9,B10,B11,B14,B15,B16 ,B17,B18,B19,B20)).
The cell returns #VALUE! when I try this formula. Note that some of the
cells K7 to K18 will contain the formula result "TRUE" and some "FALSE."
"Fred Smith" wrote in message
...
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