Excel Drop down - effects other cell value

September 2, 2011 at 11:16:46
Specs: Windows 7, 9 gb
Hi. I am trying to have a excel spreadsheet dropdown menu change another cell value to "114" or "94" depending on the selection in the list. I've made the list and created the dropdown menu but can't seem to figure out how to make it work as mentioned above. Really appreciate your help!

Victor


See More: Excel Drop down - effects other cell value

Report •

#1
September 2, 2011 at 15:38:26
=IF("cell with dropdown" = "value to change other cell to 114", 114 , 94)

or said differently...

=IF(A1 = "My114Value", 114, 94)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 2, 2011 at 16:08:54
Thank you for the reply. Unfortunately it didnt work which is my fault. In the drop down menu there are two fields:

Benchmark Conference Plan
Special Conference Plan

Each one has a different price that needs to show in a seperate cell when they are chosen in the dropdown with Benchmark being at 114 and Special at 94.

I hope this makes sense, and thank you so much for your assistance.

Victor


Report •

#3
September 3, 2011 at 08:21:42
I don't see why my suggestion wouldn't work, assuming you substituted your string for mine:

With the drop down in A1, the formula should read:

=IF(A1 = "Benchmark Conference Plan", 114, 94)

When Benchmark Conference Plan is chosen, the IF function will be TRUE and 114 will be returned. When Benchmark Conference Plan is not chosen the IF function will be FALSE and return 94.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
September 3, 2011 at 08:59:01
Thanks for the reply.

Thank you. It looks like it worked, i just needed to start a new sheet and it switches.

I do have one last question. If i were to add a third item in the drop down which would be in the first location called "Select Plan", is there a way that i can have it be "0" so it is a default and still have the formula work? If not, it's no big deal, just having this work is awesome.

Thank you again for your time.

Victor


Report •

#5
September 3, 2011 at 10:37:48
You should read up on Nested IF's in the Excel Help files or via a Google search

What you want to do can be done, but it would be better if you figured out how to do it on your own than if I just gave you the answer.

Try to figure it out, and if you can't get it to work, come on back, tell us what you tried and we'll see if we can offer some assistance.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question