View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zainuddin Zakaria Zainuddin Zakaria is offline
external usenet poster
 
Posts: 2
Default Exam Marksheet - Grading

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.