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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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?
 
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.
 
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))
 
Back
Top