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

excel

m_tarler

Silver Contributor

Aug 20, 2026

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.

GregPen

Occasional Reader

Aug 20, 2026

I just don't know why it works just fine if there are 1s across all 18 months, but not when there are less.

Forum Discussion

Nested IF function with a checkbox