Math with Variables?
Let's assume that I am performing some type of preference quiz. Based on user selections, 2 variables (let’s call them E and I) store adjusted values. So far, easy enough. Now let’s say I want to show as a percentage the strength of one over the other. In excel (or any other program supporting simple math functionality) I would use something like: 100 * (Variable X / (Variable X + Variable Y)).
My question is, can I set a new variable's value using a simple equation like this?
“Set EvIP = 100 * (Variable X / (Variable X + Variable Y)) when the user clicks…”