PASS or FAIL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am trying to know either the students pass or fail depends on the subject marks. e.g
0 - 39 = fail
40 - 100 = pass
beside the marks there are also symbols entered into the cell e.g
x = absent
- = not taking the subject
----------------------------------------------------
Name marks Pass/Fail
student A 68
Student B 23
Student C x
Student D -

any idea? TQ
 
how about =if(a1="x", "absent", if a1="-", "not taking subject", i
a1>39,"pass","fail"))) assuming the grade is in cell a1
 
In C2 enter:

=LOOKUP(B2,{0,"Fail";40,"Pass";"-","Does Not Apply";"x","Absent"})

B2 houses the mark of Student A.
 
Back
Top