| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Picking correct number with <
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Picking correct number with <
Thank you!! JE
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Selecting the correct number from a range of cells | Excel Worksheet Functions | |||
| How do i format a 5 to 6 digit number into the correct date? | Excel Worksheet Functions | |||
Linear Mode
