Passing Grade

[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

 

[Frank Kabel]

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

 

[Norman Harker]

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.