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

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!!

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

As always, post YOUR efforts for comments.

--
Don Guillett
SalesAid Software

"Milly" wrote in message
...
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!!

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

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?

"Milly" wrote:

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!!

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

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.

"dlw" wrote:

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?

"Milly" wrote:

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!!

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

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))

--
Don Guillett
SalesAid Software

"Milly" wrote in message
...
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!!