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
|