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