| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thank you both!
"David Biddulph" wrote: "olman" wrote in message ... I want to compare a number in a cell to a min and max number. If it doesn't fall between them it is bad if it does it is good. Example: 2.5 is Min. 5 is Max. Value is <2.5 or 5 is "Bad" 2.5 is "Good", 5 is "Good" Any help is appreciated? =IF(A1<2.5,"Bad",IF(A15,"Bad","Good")) -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Hybrid Mode
