Formula Help
Solved/Closed
marg2810
Posts
2
Registration date
Monday 1 February 2016
Status
Member
Last seen
2 February 2016
-
1 Feb 2016 à 18:16
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 3 Feb 2016 à 01:42
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 3 Feb 2016 à 01:42
Related:
- Formula Help
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
- Credit summation formula - Guide
- Formula to calculate vat in excel - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
2 Feb 2016 à 01:27
2 Feb 2016 à 01:27
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.
2 Feb 2016 à 19:20
3 Feb 2016 à 01:42
Cheerio,
vcoolio.