Change formula based on Dropdown List

[LostInDaJungle]

I'm working on a budgeting package, and I want to be able to change the type of calculation done based on a drop down list.

The idea is that we would take 2012 data and apply certain formulas based on type of cost/income for determining the 2013 budget.

For instance -

Occupancy is a fixed expense. No matter how much we sell, our rent doesn't go up.
COGS is a variable expense that is in direct proportion to our sales. The more we sell, the more we have to purchase for manufacturing.
Sales Expenses increase with sales, but not 1:1. We anticipate that sales expense will increase at 10% of the increase in sales.

So, I would like to make a drop down with "Fixed", "V100" (Variable at 100% of sales), and "V10" to cover these three scenarios. Calculation in the 2013 budget column would be based on what type was made in the drop down.

Fixed - No change
V10 - (2012 actual * .9) + ((2012 actual * .1) * (2012 Actual/2013 target))
V100 - 2012 actual * (2012 Actual/2013 target)

I was thinking I could just have the DDL change the ".9" and ".1" in the v10 formulas, but I'm going to get div/0 errors.

Any thoughts?

 

[LostInDaJungle]

Found my own solution:
=IF( B11=1,A13,
IF(
B11=2,(A13*C3)+((A13*B3)*(C13/B13)),
IF(
B11=3,(A13*C4)+((A13*B4)*(C13/B13)),
IF(
B11=4,(A13*C5)+((A13*B5)*(C13/B13)),
IF(
B11 = 5, (A13*C6)+((A13*B6)*(C13/B13)),
IF(
B11 = 6, (A13*C7)+((A13*B7)*(C13/B13)), "NA"
)
)
)
)
)
)

Nested If's.

 

[AhoyNC]

You might find this link of interest using the choose function.

http://www.youtube.com/watch?v=5McUCPuOO9A&feature=plcp