Nested If Statement not working [Solved/Closed]
Hello,
I am trying to use nested excel IF(And) formula.
here's my logic table
If O4=Planned,TRUE, FALSE
TRUE =IF(AND(I6>=C7,I6<=E7)0,1)
FALSE =IF(AND(I6>=F7,I6<=H7)0,1)
The True Statement works, the False statement works, (this is True right now)
The complete formula I have is:
=IF(O4=Planned, =IF(AND(I6>=C7,I6<=E7)0,1), =IF(AND(I6>=F7,I6<=H7)0,1))
But I get an error message. Any help would be appreciated. The Error message is the generic "If you meant to write a formula..."