I have a problem, I have two drop down boxes both with three values in
(The values are stored on a separate worksheet). I want to multiply an
independant value by a value determined by what is in the drop down
boxes.

E.g. Independant value*Value in drop down 1*Value in Drop down 2

However the values in the drop down boxes are words not numbers but I
need them to be equivalent to different numbers e.g. value one in drop
down 1 is 2.5, how can I get them to be classed as numbers in the
formula whilst appearing as words and what formula would I need?


--
ExcelGuy
------------------------------------------------------------------------
ExcelGuy's Profile: http://www.excelforum.com/member.php...o&userid=24324
View this thread: http://www.excelforum.com/showthread...hreadid=379282