Formula HELP!!! :)

[rubenwm]

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

 

[T. Valko]

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","")

 

[rubenwm]

Hi Rusell,
First, thanks for helping me with the formula.
Second, I agree with you. Sorry. Didn't mean anything by using caps.
Thanks again.

Ruben

 

[rubenwm]

Thanks Biff.

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]

Solved.
Thanks Rusell and Biff for your help.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks Biff.