Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
table/dropdown calculation HELP PLZ
hello everyone i came to a dead end and i need help i have this table cl-air tl air cl sea cl A-sea cl B-sea truck LTC Truck CAT. A 0.43% 0.18% 0.43% 0.28% 0.18% 0.43% 0.18% CAT. B 0.40% 0.18% 0.40% 0.28% 0.18% 0.40% 0.18% CAT. C 0.45% 0.18% 0.45% 0.28% 0.18% 0.40% 0.18% CAT. D 0.35% 0.18% 0.35% 0.28% 0.18% 0.35% 0.18% CAT. E 0.60% 0.25% 0.60% 0.28% 0.18% 0.60% 0.18% CAT. F 0.33% 0.18% 0.33% 0.25% 0.25% 0.33% 0.25% CAT. G 0.90% 0.30% 0.90% 0.28% 0.18% 0.90% 0.18% from drop down 1 person picks CAT. and from drop down 2 person picks cl-sea.....ltc truck and in a cell they put a number what i want is when they pick from the dropdown menus the % should be multiplies by the number inputed for example drop down 1 CAT. C drop down 2 cl sea this means 0.45% inputed number lets say is 13 the equation then should be 0.45% * 13 if you want file is attached can some please help me out +-------------------------------------------------------------------+ |Filename: Book1.zip | |Download: http://www.excelforum.com/attachment.php?postid=4917 | +-------------------------------------------------------------------+ -- ridash ------------------------------------------------------------------------ ridash's Profile: http://www.excelforum.com/member.php...o&userid=35617 View this thread: http://www.excelforum.com/showthread...hreadid=553954 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
table/dropdown calculation HELP PLZ | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |