Changing values in one cell depending on drop down
Solved
NOVA007
vcoolio
- Posts
- 2
- Registration date
- Wednesday January 19, 2022
- Status
- Member
- Last seen
- January 21, 2022
vcoolio
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Related:
- Changing values in one cell depending on drop down
- Changing values in one cell depending on drop down list values in another cell ✓ - Forum - Excel
- Highlight the linked cell depends on drop-down list choice ✓ - Forum - Excel
- Excel click on cell to change value of another cell - Forum - Excel
- Excel - Macro to highlight Rows with Duplicate values in a cell ✓ - Forum - Excel
- How to auto-populate values from certain cells into a new sheet ✓ - Forum - Excel
2 replies
vcoolio
Updated on Jan 21, 2022 at 01:25 AM
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Updated on Jan 21, 2022 at 01:25 AM
Hello Nova,
It's a bit long winded but try this IF/OR formula in B1:-
or this option:-
I hope that this helps.
Cheerio,
vcoolio.
It's a bit long winded but try this IF/OR formula in B1:-
=IF(A1="","",IF(OR(A1=10,A1=20),1,IF(OR(A1=30,A1=40),2,IF(OR(A1=50,A1=60),3,IF(OR(A1=70,A1=80),4,IF(OR(A1=90,A1=100),5))))))
or this option:-
=IF(OR(A1=10,A1=20),1,IF(OR(A1=30,A1=40),2,IF(OR(A1=50,A1=60),3,IF(OR(A1=70,A1=80),4,IF(OR(A1=90,A1=100),5,"")))))
I hope that this helps.
Cheerio,
vcoolio.
vcoolio
Jan 21, 2022 at 05:20 AM
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Jan 21, 2022 at 05:20 AM
You're welcome Nova.
I'm glad to have been able to help.
Cheerio,
vcoolio.
I'm glad to have been able to help.
Cheerio,
vcoolio.
Jan 21, 2022 at 03:48 AM
It worked perfectly.