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

Change B2 to the cell your looking at.

"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