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 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 21, 2022 at 05:20 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 21, 2022 at 05:20 AM
Related:
- Changing values in one cell depending on drop down
- How to change language in kmplayer - Guide
- How to change dinosaur in chrome - Guide
- How to change number of best friends on snapchat - Guide
- How to change time in whatsapp - Guide
- If a cell has text then return value ✓ - Excel Forum
2 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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.