Formula alteration

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

If you are using the drop-down from the forms toolbar, then the selection will return you numbers 1 or 2 or 3 or 4 depending on which of the four colors you select.
Your formula should read:
=IF(A1=1,1.07,IF(A1=2,1.05,IF(A1=3,1.07,1.09)))*(C2+C2*C4)
considering that cell A1 is linked to the drop down.

If you have a combo-box from the control toolbox which returns the color name, then simply replace the 1, 2, 3 and 4 with the respective colors like "red", "blue" etc in the above formula

- Mangesh

Mangesh thanks for the reply. I have done so but the result return an error. Should I be using ; instead of the , that you have put in? Also the 1.09 at the end is it to end the sequense?
Stratos

Thats fine mangesh thanks alot I figured it what was wrong thanks so much for the input I really appreciate your help

Stratos

Good to know your problem's solved. Thanks for the feedback.
In some countries ';' is used instead of ','.

Mangesh

Originally Posted by mangesh_yadav

If you are using the drop-down from the forms toolbar, then the selection will return you numbers 1 or 2 or 3 or 4 depending on which of the four colors you select.
Your formula should read:
=IF(A1=1,1.07,IF(A1=2,1.05,IF(A1=3,1.07,1.09)))*(C2+C2*C4)
considering that cell A1 is linked to the drop down.

If you have a combo-box from the control toolbox which returns the color name, then simply replace the 1, 2, 3 and 4 with the respective colors like "red", "blue" etc in the above formula

- Mangesh

Mangesh
Is this a typo?
A1=3,1.07,1.09
SB
A1=3,1.03,1.02

Thx
Dave

Hi Dave,

Yes. it is a typo. Thanks.
I was concentrating on showing the method and didn't double-check as I was getting late for home

- Mangesh