View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Picking correct number with <

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