Menu
Ask a question Report

Nested If Statement not working [Solved/Closed]

- - Latest reply:  Mimi - Aug 10, 2016 at 12:42 PM
Excel Ask a question Report
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

Best answer
Report Respond to Mimi
1
Thank you
Thank you - It was still missing the commas before the "0" in each solution set, but it works now.

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM 4337 users have said thank you to us this month

Report Respond to Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 141
0
Thank you
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