Nested If Statement not working [Solved/Closed]

Question

Nested If Statement not working [Solved/Closed]

Report

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..."

Nested if not working
How many nested if statements is too many - How-To - Excel
Sbi bank statement pdf download - How-To - Internet
Fenix internet on bank statement - How-To - OnlyFans
Excel if statement increment by 1 - How-To - Excel
Combine if statement and data validation - Forum - Excel

2 replies

Answer 2 / 2

Mazzaropi

Posts: 1873
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: January 31, 2021

139
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

Ask a question

Mimi · Accepted Answer · 2016-08-10T12:42:52-0400

Answer 1 / 2

Mimi
Aug 10, 2016 at 12:42 PM

Thank you - It was still missing the commas before the "0" in each solution set, but it works now.

Nested If Statement not working [Solved/Closed]

2 replies

Your reply

Subscribe To Our Newsletter!