Multiplying from a dropdown

Occasional Visitor

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 Replies

@nwalker17225 

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

=cell_with_dropdown*cell_with_value
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.