Forum Discussion
embedding value into dropdown option
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 col...
ejb2019 Perhaps the example in the attached file helps you on your way. I used the SWITCH function to switch the selection from the dropdown (frequency) with numbers that are then used in the formula.
This works fine when you have a small number of options. In case it becomes more complicated, it's probably better to use a lookup table with all possible frequencies and the numbers that they represent.