formula to determine students' final restult based on multiple criteria

[alaibubu]

Hello.

How do I make a formula that gives the result (pass/fail) of students' grade based on an exam. They must pass Mathematics, English and Science. If they fail any of these core subjects, they will fail the exam. They must also pass either Geography or History.
E.g
if a student passes all three of the core subjects but fail both Geography and History, he fails.
If a student passes all three core subject but only fails in Geography, he passes.

I hope my question is not confusing. I tried the "if" function but got confused because of the different criteria needed to get the result.

Any help is greatly appreciated.

[daddylonglegs]

Assuming you show "pass" or "fail" in 5 cells, e.g. A2:E2, A2:C2 are the compulsory passes.

=IF(AND(COUNTIF(A2:C2,"pass")=3,COUNTIF(D2:E2,"pass")>0),"pass","fail")

[alaibubu]

I'm sorry for not being clear the first time. My mistake.

From the attached picture: blue cells = must pass; yellow cells = must pass at least one subject; grey cells = result.

Grades A, B, C, D = pass
Grade U = Fail

Picture 4.png

Thank you for the fast response

[daddylonglegs]

If your first grades are in row 4 try this formula in AE4 copied down

=IF(AND(SUM(Z4:AC4)>3,F4<>"U",J4<>"U",L4<>"U"),"P","F")

[TonyS]

Or this on cell AE4
=IF(OR(F4="U",J4="U",L4="U"),"F",IF(AND(P4="U",V4="U"),"F","P"))

[alaibubu]

That worked great, thanks.