Dec 31 2021 05:01 AM
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
Dec 31 2021 05:13 AM
Why so complicated? Reduce the options to 1,2 and 5 and then it's simply:
=cell_with_dropdown*cell_with_value
Dec 31 2021 05:28 AM