Help Please

[excelnerd95]

Hey guys,

I am trying to create a formula that can predict if a student will pass/fail the semester. It has multiple conditions. I have figured out all but one and it's making me crazy. Can anyone please have a look and help me?

So basically, I need to embed the formula used in cell E29 to cell C24. Cell E29 contains another condition that excel needs to look at before deciding on the student's result.

C24=IF(AND(C22>=2,C9<2,C8=0,E29),"May Graduate","May Not Graduate")


E29=IF(COUNTIF(M12:M18,"Fail")>0,"Fail","Pass")


I have mentioned where I need to add E29 in C24 formula.

 

[Dave Patton]

possibly
IF(COUNTIF(M12:M18,"Fail")>0,"Fail", IF(AND(C22>=2,C9<2,C8=0),"May Graduate","May Not Graduate"))