Nested IF function with a checkbox

Question

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" otherwise a "1." It functions perfectly if there is a 1 in all 18 blocks, but if it only has a 1 in some of the blocks, the "O/H" doesn't work properly. I'm trying to put a picture in to better clarify and show how the formula is setup.&nbsp;&nbsp;Thanks for any assistance everyone provides.&nbsp;

gregpen · Answer

Here is what it looks like. I cut it down from 18 months to fit in a smaller picture but still show the problem.&nbsp;Why didn't it change the two 1s to O/H.&nbsp;

Forum Discussion

Nested IF function with a checkbox

1 Reply