Not just True/False

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm would like to have a cell display Pass, Conditional, or Fail depending on
a score in another cell. For example, if the score is below 60, display
Fail, between 60 and 70 display Provisional, >70, display Pass. I can get
pass/fail, but not the three responses.

Help???

Thanks
 
Try this:

=IF(A1<60,"Fail",IF(A1<=70,"Provisional","Pass"))

HTH,
Elkar
 
=IF(B2<60,"Fail",IF(AND(B2>60,B2<71),"Provisional","pass"))

Change B2 to the cell your looking at.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AND function, OR function with own value 6
Excel 2007 - formula to display text over a range of values 1
formula to display cell address 2
Combining IF and VLOOKUP 2
Pass or Fail (green or red) criteria for cell? 6
Formula for If "" AND "" are true... 3
nested function limitation 1
SENDING EMAIL WITH PASS/FAIL RESULT 0

Back
Top