Fail pass formula follow up

QuestionEdit

This in continuation to a question and your answer here: http://en.allexperts.com/q/Excel-1059/2010/3/Fail-Pass-formula.htm Your answer was: =if((countif(G1:G5,"<1")+countif(G1:G5,">100"))>0,"Wrong Markings",if(countif(G1:G5,"<33")>1,"Fail","Pass"))

How to make the above formula to include this: If two cells contain"Absent" or one cell less than 33 and one cell "Absent" = Fail.

AnswerEdit

S. Nair,

=IF((COUNTIF(G1:G5,"<1")+COUNTIF(G1:G5,">100"))>0,"Wrong Markings",IF((COUNTIF(G1:G5,"<33")+COUNTIF(G1:G5,"Absent"))>=2,"Fail","Pass"))

so if any combination of two or more cells contain Absent or are <33 or a combination then fail