Changing values in one cell depending on drop down
Solved/Closed
NOVA007
Posts
2
Registration date
Wednesday January 19, 2022
Status
Member
Last seen
January 21, 2022
-
Updated on Jan 19, 2022 at 10:47 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 21, 2022 at 05:20 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 21, 2022 at 05:20 AM
Related:
- Changing values in one cell depending on drop down
- Changing phone number t mobile - Guide
- Excel formula to subtract one cell from another - Excel Forum
- How to change language in kmplayer - Guide
- If cell contains date then return value ✓ - Office Software Forum
- How to change number of best friends on snapchat - Guide
2 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Updated on Jan 21, 2022 at 01:25 AM
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
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Jan 21, 2022 at 05:20 AM
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.