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

picking correct number with < additional question
 

=IF(COUNT(A1:A100) 0,MAX(A1:A100),"")


"scott" wrote:

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