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


"BobT" wrote:

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

"DWD" wrote:

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
--
Dan Davenport