Menu
Ask a question Report Reply to this topic

Nested If Statement not working [Solved/Closed]

Mimi - Aug 9, 2016 at 05:39 PM - Latest reply:  Mimi
- Aug 10, 2016 at 12:42 PM
Excel Ask a question Report Reply to this topic
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 

2 replies

Report Respond to Mimi
Mimi - Aug 10, 2016 at 12:42 PM
+1
Helpful
Thank you - It was still missing the commas before the "0" in each solution set, but it works now.
Was this answer helpful?  
Report Respond to Mazzaropi
Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Aug 10, 2016 at 10:13 AM
0
Helpful
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
Ask a question