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?