View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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!!