Drop down list which changes criteria

**finbow1990** · 05-21-2012, 07:04 AM

I have been struggling for a while to get to grips with this problem I have been having.

I am trying to create a formula that will deduct certain amounts from a cell depending on what is selected in a drop down box.

For example:

If option A is selected deduct X amount from cell A2 however if option B is selected deduct Y amount, etc....

This will be needed to be done to a long list as well each with the same formula.

I have tried IF formulas but can not get one to work. I have attached a test copy of what I am trying to do and I hope it is clear.

Any help or guidance would be much appreciated.

Thanks

TEST.xlsx

**zbor** · 05-21-2012, 07:07 AM

Forum Rules
Please read and adhere to these simple rules!

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

**Spencer101** · 05-21-2012, 07:07 AM

Hi, I think you need to attach the file again. The one posted above doesn't open.

S.

**finbow1990** · 05-21-2012, 09:57 AM

I have attached the file again. It works when I try downloading off another computer.

**Fotis1991** · 05-21-2012, 10:13 AM

Hi

You mean something like this in C3 and copy down?

=IF($A$1="a";A9-$F$1;IF($A$1="b";A9-$F$2;IF($A$1="c";A9-$F$3;A9-$F$4)))

Change the semi colons in my formula to comma, if you have to do this.

**finbow1990** · 05-22-2012, 08:40 AM

thanks that seems to have worked.

thank you.

**Fotis1991** · 05-22-2012, 08:45 AM

You are welcome.

Pls, mark your thread, as Solved(Look at the top of the page, to see how to do this)

Drop down list which changes criteria

LinkBack

Thread Tools

Rate This Thread

Display

Drop down list which changes criteria

Re: Need a solution

Re: Need a solution

Re: Need a solution

Re: Drop down list which changes criteria

Re: Drop down list which changes criteria

Re: Drop down list which changes criteria

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions