Multiplying from a dropdown

[nwalker17225]

hi,

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?

cheers

[#2]

@nwalker17225 

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

=cell_with_dropdown*cell_with_value

[#3]

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.