getting excel to take '<' values into account in calculations

M

Milly

How do you include values in a min,max calcualtion with the character <
preceeding some of them. E.g <0.05. Please help, loads of data to get through
and these are slowing me down!!
 
D

dlw

in excel formulas, a value is a number, <0.05 is not a number so it cannot be
used as a value. what are you trying to do?
 
M

Milly

the data I have is lab data and if below detection threshold it will spit out
the < values. I just needed to find the simple max and min of the values
including the < values. Thaks anyway. I'll just report the < values as the
minimum values if there is no other way round it.
 
D

Don Guillett

You did not post your layout or formulas but see if this helps. This is an
ARRAY formula which must be entered using ctrl+shift+enter

=MAX(IF(B2:B22<0.05,B2:B22))
 
Top