Report

Nested If Statement not working [Solved]

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