picking correct number with < additional question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

One way:

=IF(COUNT(A1:A100),MAX(A1:A100),"<0.05")

scott said:
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
Click to expand...

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
 
=IF(COUNT(A1:A100) > 0,MAX(A1:A100),"")


scott said:
One way:

=IF(COUNT(A1:A100),MAX(A1:A100),"<0.05")



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
Click to expand...
 
Back
Top