View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Russell Dawson Russell Dawson is offline
external usenet poster
 
Posts: 52
Default Formula HELP!!! :)

=IF(AND(b3192,b31<95),"Successful","")
--
Russell Dawson
Excel Student


"rubenwm" wrote:

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