![]() |
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!! |
All times are GMT +1. The time now is 12:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com