Nested If Statement not working
Solved/Closed
Related:
- An if statement nested within another if statement will produce how many possible results?
- How many if statements can you nest in excel - Guide
- Fenix internet on bank statement - Guide
- Excel if statement with dates - Guide
- Sbi statement download - Guide
- Which two sentences correctly describe the use of formulas in performing calculations in spreadsheets? all formulas written for a spreadsheet must follow certain rules, which we call syntax. when creating a formula in a spreadsheet, always start with an if statement. basic statements include numeric values and operators. if there are multiple operators, then the order of precedence starts with exponents. parentheses are used to isolate certain parts of the expression from the other parts. operations in parentheses are completed after the rest of the formula is evaluated. - Excel Forum
2 responses
Mazzaropi
Posts
1983
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
