Selecting fromula

Hello,

I'd like to do the following.


In excel you can use choose to apply a formula to certain cells.
ie: =choose(c1;A1*pi();2*(A1+B1)) with c1=1 you get the first formula, with c2=2 you get the second.

What i like to do is make a sheet with a list of names and formulas.
column 1 circle, rectangle,...
column two cell reference*pi(),2*(cell reference1+cell reference 2)

then make a named range geometries for the name column.

Then on the main sheet i fill a column with drop down slection using data validation-list and the range geometries.

next to this range ther would be some parameters.

so finally if i select a name from the formulalist i want the corresponding formula apllied to these parameters.

this way the formulas to be applied can be maintained easily.

I know i can do stuff like that with vba, but i'd like to do it with excell functions only.

Is this possible?

thank you,
Kris

Voila,
added Example in attachment to clarify.

Thank you

anyone any idea?
K.

Not possible then?

Yes i know, as i stated on my original question.

But choice is not only for circles and rectangle, but for about 20 'standard' geometry types.
putting all those formulas into 1 statement would make it hard to manage all formula's.

that's why i'm looking for another way.

Any ideas?

Thanks for your reply.