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