Hi, I want to embed a value into a drop-down value. 

I am trying to calculate the total cost of purchasing a product based on the price and the frequency. I have a column with the price and a column with the frequency of times purchased per year. Finally, I have a column with the total cost per year. For example, the price $20, purchased 2 times per year $40 for the annual cost. However, I want to select the frequency based on a drop-down box and have that be tied to a value that is inputted into the total annual cost formula. For example, the drop-down box would say quarterly, and it would be tied to the value 4 (meaning- purchasing four times per year). Selecting quarterly from the drop down frequency options would input the four into the formula. 

Thanks.

​Hi, I want to embed a value into a drop-down value.  I am trying to calculate the total cost of purchasing a product based on the price and the frequency. I have a column with the price and a column with the frequency of times purchased per year. Finally, I have a column with the total cost per year. For example, the price $20, purchased 2 times per year $40 for the annual cost. However, I want to select the frequency based on a drop-down box and have that be tied to a value that is inputted into the total annual cost formula. For example, the drop-down box would say quarterly, and it would be tied to the value 4 (meaning- purchasing four times per year). Selecting quarterly from the drop down frequency options would input the four into the formula.  Thanks.  Read More

​