Forum Discussion
Nested IF function with a checkbox
Hello Excel Gurus, I have a nested IF function that is based on comparing dates and whether a checkbox is selected. It's an 18 month outlook and if the checkbox is selected it should display "O/H" o...
Here is what it looks like. I cut it down from 18 months to fit in a smaller picture but still show the problem.
Why didn't it change the two 1s to O/H.
The formula is:
=IF($H36="","",IF($M36="",IF($AF36,"O/H",1),IF(N$6>=EDATE($M36,0),"",1)))But if $M36 is NOT "" then it will not do the IF($AF36...) because that is part of the TRUE and it will do the IF(N$6...) statement instead. I'm not sure what to reccommend because I'm not clear on what conditionals you are checking and corresponding outputs you are expecting in each case.
You might want to consider IFS(...) or other alternatives instead of the nested IF structure.
I just don't know why it works just fine if there are 1s across all 18 months, but not when there are less.