Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
picking correct number with < additional question
One way:
=IF(COUNT(A1:A100),MAX(A1:A100),"<0.05") In article , scott wrote: dIn my ss I need to pick out the largest number. The problem is some of our entrees need to have < before them. Example. Test results for sample A is <.05. On the same day test was ran again and test result was .05. I need to record the largest number or .05 on my report form. But if only one test is run for the day and <.05 is the result then I need <.05 to be recorde on my report form exactly as <.05. Is there a formual or way to do this? Thanks Scott My original question is posted above with the solution that does work. I forgot to mention that when no sample result is recorded I need my ss to be blank. With the above formula it will show <0.05. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Picking correct number with < | Excel Discussion (Misc queries) | |||
Newbie question - excell format not correct | Excel Discussion (Misc queries) | |||
sum product not returning correct number | Excel Worksheet Functions | |||
Assign number to correct range | Excel Discussion (Misc queries) | |||
Help picking a random number from a given distribution | Excel Worksheet Functions |