Exam Marksheet - Grading

Z

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula - Exam Marksheet 9
Formula - pass and fail 3
Grade - One and Four Others 2
Formula - Pas or Fail 1
One Pass And Plus Five More 2
Marksheet 4
Formula in Marksheet 6
Formula - Marks in Group 1

Top