Formula - Pas or Fail

S

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
 
Top