help me in writing a formula

khushee

New member
Joined
Jun 14, 2011
Messages
4
Reaction score
0
Points
0
I use a formula to mark "pass" or "fail", which is =IF(C2>=25, "Pass", "Fail")

now the question is, when I use "A" (absent) in cell the result is "Pass", please tell me how I can write formula to get the "Fail" in result column after writing "A" in Marks column
i have also attached excel file for your kind observation
thanks
 

Attachments

  • 2007-2012 4th prof.xls
    19 KB · Views: 53
Here's two formulas that will do it:
=IF(OR(C2<26,C2="a"),"Fail","Pass")
==IF(C2="a","Fail",IF(C2>=25, "Pass", "Fail"))
 
Back
Top