ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   getting excel to take '<' values into account in calculations (https://www.excelbanter.com/excel-discussion-misc-queries/145205-getting-excel-take-values-into-account-calculations.html)

milly

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

Don Guillett

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



dlw

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


milly

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


Don Guillett

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




All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com