Nested if then
Solved/Closed
chiflado
vcoolio
- Posts
- 5
- Registration date
- Sunday November 9, 2014
- Status
- Member
- Last seen
- November 12, 2014
vcoolio
- Posts
- 1356
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- August 11, 2022
Related:
- In cell m2 enter a formula using a nested if function
- How many if statements can you nest in excel - Guide
- Which of the following nested if functions are correct ✓ - Forum - Office Software
- Nest's Security Cam Recognizes Intruders - News
- Nest Hub Max Takes On Amazon Echo Show - CCM - News
- Nested if's ✓ - Forum - Excel
5 replies
vcoolio
Nov 9, 2014 at 09:24 PM
- Posts
- 1356
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- August 11, 2022
Nov 9, 2014 at 09:24 PM
Hello Chiflado,
Is the following formula possibly what you need? Place it in M2:-
=IF(T2=1,B1,IF(T2=2,B2,IF(T2=3,C1,IF(T2=4,C2,IF(T2=5,D1,IF(T2=6,D2))))))
I'm assuming that you require the first two values in the first two rows of Columns "B", "C" and "D" placed in M2 once your values in T2 are entered.
Cheers,
vcoolio.
Is the following formula possibly what you need? Place it in M2:-
=IF(T2=1,B1,IF(T2=2,B2,IF(T2=3,C1,IF(T2=4,C2,IF(T2=5,D1,IF(T2=6,D2))))))
I'm assuming that you require the first two values in the first two rows of Columns "B", "C" and "D" placed in M2 once your values in T2 are entered.
Cheers,
vcoolio.
chiflado
Nov 10, 2014 at 01:52 PM
- Posts
- 5
- Registration date
- Sunday November 9, 2014
- Status
- Member
- Last seen
- November 12, 2014
Nov 10, 2014 at 01:52 PM
Super! This is exactly what I'm looking for. I couldn't get the syntax right so I'm very thankful that you know what your doing! Thank you, thank you, thank you.
chiflado
Nov 10, 2014 at 01:55 PM
- Posts
- 5
- Registration date
- Sunday November 9, 2014
- Status
- Member
- Last seen
- November 12, 2014
Nov 10, 2014 at 01:55 PM
Is there a way to do more than 7 nested if then statements?
chiflado
Nov 10, 2014 at 01:59 PM
- Posts
- 5
- Registration date
- Sunday November 9, 2014
- Status
- Member
- Last seen
- November 12, 2014
Nov 10, 2014 at 01:59 PM
And... Is there a way to have M2 blank if T2 is blank? Right now it reads "FALSE" if nothing is in there.
Didn't find the answer you are looking for?
Ask a question
vcoolio
Nov 10, 2014 at 07:54 PM
- Posts
- 1356
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- August 11, 2022
Nov 10, 2014 at 07:54 PM
Hello Chiflado,
I believe that up to 64 IF functions can be nested in an If formula. You can probably pick up on the pattern in the formula above, so give it a try and see how it works.
To remove "False" from the cell, try this slightly amended formula:-
=IF(T2=1,B1,IF(T2=2,B2,IF(T2=3,C1,IF(T2=4,C2,IF(T2=5,D1,IF(T2=6,D2,""))))))
Regards,
vcoolio.
I believe that up to 64 IF functions can be nested in an If formula. You can probably pick up on the pattern in the formula above, so give it a try and see how it works.
To remove "False" from the cell, try this slightly amended formula:-
=IF(T2=1,B1,IF(T2=2,B2,IF(T2=3,C1,IF(T2=4,C2,IF(T2=5,D1,IF(T2=6,D2,""))))))
Regards,
vcoolio.
chiflado
Nov 12, 2014 at 12:16 PM
- Posts
- 5
- Registration date
- Sunday November 9, 2014
- Status
- Member
- Last seen
- November 12, 2014
Nov 12, 2014 at 12:16 PM
Outstanding! Thank you very much. You've saved me a TON of work.
vcoolio
Nov 12, 2014 at 05:10 PM
- Posts
- 1356
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- August 11, 2022
Nov 12, 2014 at 05:10 PM
You're welcome Chiflado. Glad I could help.
Cheers,
vcoolio.
Cheers,
vcoolio.