Formula - Pas or Fail

[Salza]

Hi all,

I am preparing an exam marksheet.

In one cell, I add in this formula to check if the students pass the whole
exam.
The condition to pass is that the student must not get any "E" in any
subject.

=IF(OR(E7="E",G7="E",I7="E",K7="E",M7="E",O7="E",Q7="E",S7="E",U7="E",W7="E"
,Y7="E",AA7="E",AC7="E",AE7="E"),"Fail","Pass"))

Now, I want to change the condition of passing.
The students must not get any "C", or "D" or "E" in any subject.

Can someone help me with the formula.
Thanks.

Regards,
Salza

 

[Frank Kabel]

Hi
see the responses to your thread 20 minutes ago
Frank