Nested If Statement not workingSolved/Closed

Question

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

Mazzaropi · Answer

mimi, Good morning. The logic's formula are OK. There is only a little error on it. a) If PLANNED is a TEXT you must use quotes: "PLANNED" b) The EQUAL sign at beginning of yours clauses is not necessary. Try use it: =IF(O4="Planned", IF(AND(I6>=C7,I6<=E7)0,1), IF(AND(I6>=F7,I6<=H7)0,1)) Is this what you want? I hope it helps. -- Belo Horizonte, Brasil. Marcílio Lobão

Mimi · Answer

Thank you - It was still missing the commas before the "0" in each solution set, but it works now.

Nested If Statement not working

2 responses

Similar discussions

Subscribe To Our Newsletter!