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
Bookmarks