Nested If Statement not working
Solved/Closed
Related:
- An if statement nested within another if statement will produce how many possible results?
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- How many nested if statements in excel - Guide
- Excel if statement with text - Guide
- Vba case statement with string - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 10, 2016 at 10:13 AM
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
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
