I have a cost estimation worksheet that includes a drop down list. When
the user selects from the list, I want to apply a factor based on their
selection and multiply it by a total (on a different worksheet). For
example, if they select "Low" from the list, I want to multiply 10% by
a total cost cell (which is on a different worksheet) and put the
result in a different cell.

How do I do this?


--
JenB
------------------------------------------------------------------------
JenB's Profile: http://www.excelforum.com/member.php...o&userid=37719
View this thread: http://www.excelforum.com/showthread...hreadid=573105