Report

Formula Help [Solved]

Ask a question marg2810 2Posts Monday February 1, 2016Registration date February 2, 2016 Last seen - Last answered on Feb 3, 2016 01:42AM
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
See more 
Helpful
+3
moins plus
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.
marg2810 2Posts Monday February 1, 2016Registration date February 2, 2016 Last seen - Feb 2, 2016 07:20PM
Thank you so much - you have made my day! Worked perfectly. :) :)
Reply
vcoolio 832Posts Thursday July 24, 2014Registration date ModeratorStatus December 8, 2016 Last seen - Feb 3, 2016 01:42AM
Excellent Marg! Glad that I was able to help out.

Cheerio,
vcoolio.
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!