Exam Marksheet - Grading

[Zainuddin Zakaria]

Please help me with a formula for my marksheet.

The exam grading is A, B, C, D and E. E is a failure

To pass the overall exam, a student must :-

Must NOT FAIL in any 4 subjects from columns E7, G7, I7 and K7
and MUST PASS ONE subject from column M7, O7, or Q7
and MUST PASS ONE subject from column S7, or U7

What is the best formula for this? Can u suggest the formula?

Thank you for your time.

 

[Dave Peterson]

You have responses at your other post.

Please don't multipost.