Hi everyone please, please help!
I have created a formula to calculate a final price after all variables have been selected from drop down menus.
I am trying to set a coefficient to change the formula by selecting a choice from another drop down manu. For example if the formula is C2+C2*C4 I want this formula to be multiplied or altered depending on a list of colours. So lets say green is 1.07
red is 1.05
blue 1.03 and
black 1.02.
When one of these colours is selected from the drop down menu I want all of the final calculation formula to be multiplied by the set coffiecint for the corresponding colour. How can I do that? and also is it possible to do so in a multiple times?

I am in deperate help.

Thanks