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
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
- Feb 3, 2016 at 01:42 AM
Can someone please help me with this formula

=IF(G2="1",VSC410, IF(G2="2",VSC450, IF(G2="3",VSC470)))

What i am trying to do is : if G2 has the number "1" then insert VSC410 in (column E) etc etc. With the above formula all i get is "false" or other variations i get "#value".

I would appreciate any help with this

Thank you
Marg

1 reply

vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
249
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.
3
marg2810
Posts
2
Registration date
Monday February 1, 2016
Status
Member
Last seen
February 2, 2016

Feb 2, 2016 at 07:20 PM
Thank you so much - you have made my day! Worked perfectly. :) :)
0
vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
249 > marg2810
Posts
2
Registration date
Monday February 1, 2016
Status
Member
Last seen
February 2, 2016

Feb 3, 2016 at 01:42 AM
Excellent Marg! Glad that I was able to help out.

Cheerio,
vcoolio.
0