In cell (H16) is a price index cell that calculates what the final cost will be the for the product. The formula is:
=IF(K2 = "Yes", IF(A16<4.5,0.27093,IF(A16<100,0.25,IF(A16<200,0.2,0.225)))*(1+IF(L2=1,0.25,IF(L2=2,1.26,IF(L2=3,1.89,IF(L2=4,2.52,IF(L2=5,3.15,0)))))), IF(A16<4.5,0.27093,IF(A16<100,0.25,IF(A16<200,0.2,0.225))))

Now I added another column for the material (I forgot to add it earlier). Now these cells will be from a dropdown menu generated from Validation:List. The list consistes of:
Standard 1/16"
Thin .025"
Thick 1/8"

Now the price for "Standard 1/16 & Thin .025" are the same and in the formula above. I need to add a diiferent price if "Thick 1/8" is selected from the dropdown menu.
If "Thick 1/8" is picked from the dropdown menu the the price will be increased by 50%.

Can anyone show me how this can be done?

Thank you,
Craig