Passing Grade

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

Hi all,

I am preparing an exam marksheet.

Grades for two subjects, History and Geography, are filled in cell E9 and
F9, respectively.
Grades are from A, B, C, D, and E.

In cell G9, I want a result to show overall result i.e. "PASS" or "FAIL"
when grades are filled in E9 and F9.

Requirement to PASS:-
Students must get at least a C in BOTH subjects. (no grade D or E in cells
E9 or F9).

Can someone help me with the formula?

Thanks.

Regards,
Salza
 
Hi Robin
try the following formula in G9
=IF(OR(E9="D",E9="E",F9="D",F9="E"),"FAIL","PASS")
 
Hi Robin!

Try:
=IF(COUNTA(E9:F9)<2,"",IF(OR(E9="D",E9="E",F9="D",F9="E"),"FAIL","PASS
"))

I've modified it to return "" if either E9 or F9 is empty.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top