Multiplying from a dropdown

Occasional Visitor



I have a dropdown that has 3 options x1,x2,x5. in another cell I have value of 10 which corresponds to the price of x1. how when I change the value to x2 and x5 in the drop down can I get the value of 10 be multiplied by two and five automatically?



2 Replies


Why so complicated? Reduce the options to 1,2 and 5 and then it's simply:

Use numeric values in your dropdown (1, 2, 5), then it's a simple multiplication formula. Then, if you want the dropdown to display x1, x2, and x5, format the dropdown cell with a custom number format of x#,##0.