IF conditional for 3 conditions?

  • Thread starter Thread starter James Brannan
  • Start date Start date
J

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
 
Back
Top