Forum Discussion
Solved
Create a Formula (blank statement, referencing other cells) - MS Excel 2016
If H6 equals "Semester" then H20 is changed to 1 and I20 is changed to 1, if 2 and up is chosen in H20 when H6 equals "Semester" than I20 will equal 0 In addition to that if "Cohort" or "A La C...
Hi
Here you are:
=IF(OR(AND(H4="Semester", H20=1), AND(H4="Cohort", H20>=1),AND(H4="A La Carte", H20>=1)), 1, 0)
Also attached the resolved excel
Hi
Here you are:
=IF(OR(AND(H4="Semester", H20=1), AND(H4="Cohort", H20>=1),AND(H4="A La Carte", H20>=1)), 1, 0)
Also attached the resolved excel