I have 3 drop down lists, each has percentages in at 5 percent increments that you can set up manually.

I have another drop down list that i would like for presets which will have a few choices in. Each choice gives those other 3 drop downs a different config.

E.g. "test 1" on the drop down might give us:

75
10
15

At first (to try it out on the first drop down) i just used an IF statement like:

IF(B4="test1", 75,0)

and that worked, but then if i change that percent drop manually down all that code disappears?

Any ideas how i can best use a drop down to manipulate those other drop downs? While still being able to manually affect them?