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.
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.