Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding another formula to and Exsiting Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bug in Excel 2007. Impossible to add new data to exsiting chart ?? | Charts and Charting in Excel | |||
adding a formula including the value another formula gets | Excel Discussion (Misc queries) | |||
Adding a formula within a formula | Excel Worksheet Functions | |||
VBA code to Add data to exsiting worksheet | Excel Discussion (Misc queries) | |||
How can I get data from one worksheet into another exsiting worksh | Excel Discussion (Misc queries) |