# Nested If Statement not working

Solved/Closed
Mimi - Aug 9, 2016 at 05:39 PM
Mimi - Aug 10, 2016 at 12:42 PM
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..."

## 2 responses

Thank you - It was still missing the commas before the "0" in each solution set, but it works now.
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 10, 2016 at 10:13 AM
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