IF conditional for 3 conditions?

[James Brannan]

Hi, I'm working on a spreadsheet for school. According to the student's
grades they will be given a result - Pass (=>60) or fail (<60).

=IF(H58>=59.5, "Pass", "Fail")

What I need to be able to add to this is "No show" if the student didn't
attend and got 0.

Any help would be much appreciated,
Thanks,

James

 

[Jacob Skaria]

=IF(H58,IF(H58>=59.5, "Pass", "Fail"),"")

If this post helps click Yes

 

[Mike H]

Hi,

=LOOKUP(H58,{0,1,60},{"No Show","Fail","Pass"})
Mike

 

[Mike H]

slight refinement

=IF(H58<>"",LOOKUP(H58,{0,1,60},{"No Show","Fail","Pass"}),"")

Mike