R
ridash
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
can some please help me out
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
can some please help me out