Nested If Statement not working [Solved]

Ask a question Mimi - Latest answer on Aug 10, 2016 12:42PM
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..."
See more 
moins plus
Thank you - It was still missing the commas before the "0" in each solution set, but it works now.
Add comment
moins plus
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
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!