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 Carte" is chosen in H6 (instead of "Semester") and a number 1 or above is chosen in H20 then I20 will equal 1
if H20 is left blank then I20 will equal 0
How would you refine this and put this into a formula?
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
1 Reply
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