Not just True/False

[DWD]

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

 

[BobT]

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

 

[Elkar]

Try this:

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

HTH,
Elkar

 

[Newbeetle]

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

Change B2 to the cell your looking at.

 

[DWD]

Got it... Thanks much to all... D

 

[DWD]

Got it, Bob... Thanks...D
--
Dan Davenport

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

 

[DWD]

Got it.... Thanks...D
--
Dan Davenport

Try this:

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

HTH,
Elkar