help predict pass or fail

[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.

[FDibbins]

Hi, welcome to the forum

Please use titles that describe what you are trying to achieve (think google terms)...I have changed your title for you - this time.

It's always easier if you provide a sample WB, but see if this will get you heading in the right direction (looks like you were almost there)...
C24=IF(AND(C22>=2,C9<2,C8=0,E29="Fail"),"May Graduate","May Not Graduate")

and btw, this could be shortened, too...
E29=IF(COUNTIF(M12:M18,"Fail")>0,"Fail","Pass")

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

[bebo021999]

May be do not need E29

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

[excelnerd95]

Hi guys,

Thanks for your help. I was almost there and just needed that push! :D