PASS or FAIL?

[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

 

[duane]

how about =if(a1="x", "absent", if a1="-", "not taking subject", i
a1>39,"pass","fail"))) assuming the grade is in cell a1

 

[Aladin Akyurek]

In C2 enter:

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

B2 houses the mark of Student A.

 

[Guest]

Hi,

If the cell are blank, how to edit the formula/

TQ

 

[Aladin Akyurek]

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

 

[Guest]

Tq

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