Formula HELP!!! :)
If the first paragraph you say the range is 92 - 95%. In the second
paragraph you say the range is 92 - 94%.
Here's my best guess at what you want...
The range is greater than or equal to 92% but less than 95%.
=IF(AND(B31=92%,B31<95%),"Successful","")
--
Biff
Microsoft Excel MVP
"rubenwm" wrote in message
...
I am trying to get the word "Successful" in a cell (B32) if another
cell(B31)
results/number fall between two percentages of less than 95% and more than
92%.
I want B32 to show the word "Successful" if B31 results in a score between
92% and 94%. I guess the 94% must consider 94.9999999
Need ASAP. Thanks!!
|