excelnerd95
New Member
- Joined
- Nov 13, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
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.
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.
