I am trying to calculate a formula based on the selection in a dropdown. In the blend percentages dropdown, the user can select anything from 100% to 25-25-25-25% blend percentage. According to which blend percentage the user selects, it changes how I need to calculate the formula. Each blend percentage has a certain variable that I need to times by either .50, .33, .25 etc.
I am trying to figure out a way to have a hidden input box that takes the blend percentage selected by the user, and input a certain value based on their selection. For example, if the user selects “75%-25%”, the input field will show .75. I will then use that input field to run my calculation off of.
Any suggestions would be greatly appreciated!