Formula Help
Solved/Closed
marg2810
Posts
2
Registration date
Monday February 1, 2016
Status
Member
Last seen
February 2, 2016
-
Feb 1, 2016 at 06:16 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Feb 3, 2016 at 01:42 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Feb 3, 2016 at 01:42 AM
Related:
- Formula Help
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Feb 2, 2016 at 01:27 AM
Feb 2, 2016 at 01:27 AM
Hello Marg,
You were almost there! Try the following slightly amended formula:-
=IF(G2="","",IF(G2=1,"VSC410",IF(G2=2,"VSC450", IF(G2=3,"VSC470"))))
You had the quotaion marks in the wrong place and I've added a little bit at the begining to stop "False" from appearing. Numbers don't need to be wrapped in quotation marks but text or text/numbers do.
Drag the formula down Column E as far as you need.
I hope that this helps.
Cheerio,
vcoolio.
You were almost there! Try the following slightly amended formula:-
=IF(G2="","",IF(G2=1,"VSC410",IF(G2=2,"VSC450", IF(G2=3,"VSC470"))))
You had the quotaion marks in the wrong place and I've added a little bit at the begining to stop "False" from appearing. Numbers don't need to be wrapped in quotation marks but text or text/numbers do.
Drag the formula down Column E as far as you need.
I hope that this helps.
Cheerio,
vcoolio.
Feb 2, 2016 at 07:20 PM
Feb 3, 2016 at 01:42 AM
Cheerio,
vcoolio.