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


--
craigwojo
------------------------------------------------------------------------
craigwojo's Profile: http://www.excelforum.com/member.php...o&userid=13767
View this thread: http://www.excelforum.com/showthread...hreadid=346016