question about formulas

[Globster]

First of all - Thank you very much for any help.

I have a following question - how it is possible (i know it is) to fill a cell with a formula based on dropdown list in another cell:

Example:
In a1 i have height in b1 width in c1 im sellecting from list circumference and area and in d1 is either =2*(a1+b1) or =a1*b1

This is only basic example - in reality i have a long list containg "extras" to product price and each of those have separate formula.

I can go with =CHOOSE(MATCH(dropdown, list of options, 0), 1st formula, 2nd formula, ...) BUT i have a list which is growing and i have to modify this formula everywhere and everytime when i add or worse modify formulas.

 

[Globster]

aaa important NOTE - i have to avoid VBA because workbook will be distributed to customers.

 

[awoohaw]

Are you saying you want to tell the calculation cell what to do based on a drop down text that says calculate "xyz statistic" but have no calculation information in the cell that displays the result? Without VBA? I don't think that is possible.

 

[Globster]

There must be a way to do something like this:

 

[awoohaw]

If you find a way to do this without VBA please tag me with that solution. I would like that too!