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
|