You're welcome!

--
Biff
Microsoft Excel MVP


"rubenwm" wrote in message
...
Thanks Biff.

"T. Valko" wrote:

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!!


.