Multi-step calculations

Hi @EvoKneevo Happy Thursday! Thanks for stopping by the community. I’m the absolute worst at math, so I’m going to see if @john.desborough happens to know the answer to this! I believe you can do everything up until the very last piece subtracting the variable minus the question, but hoping to see if Des happens to know!

Thank you, @john.desborough !

That’s amazing @john.desborough - your thought on making a range has me spinning off in other variable directions. So overnight we’ve had to change the calculation (sigh) BUT the fact you can calculate two things to equal a variable, makes me breathe a sigh of relief - as that is still very much needed. Here’s the nitty gritty of what we are trying to do, with example data:

Q1: How much does that thing cost? A: $1250

Q2: How many of those things do you want? A: 825

Q3: How much of that thing, at that price, are you currently paying for? A: 52%

Q4: (Variable determined by choices = between 0.1 to 0.6) A: 0.6

Result: New % of that thing that you would now pay if you signed up with X: 83% 

Back end math:
Q2 x Q1 = $E
(100- Q3) / 100 = 0.F
E * F = $G
(1-Q4)*G = $H
(E - H) / E = RESULT %

If I could give you a 9th coffee, I would!! 

Thanks @john.desborough! I’ve just noticed in testing that calculations seem to fire from the first question, rather than in an order. This means I can’t copy a subtotal into different variables and then work with those variables individually e.g. I “add” var1 (which is a person’s answer) to var2 and var3, so they are all equal, but then in using var1 in another calculation, var2 and var3 switch to match the new amount in var1 because of the earlier comand to add var1. Make sense?

Does this mean that you can only do “pass-the-parcel” calculations? So you plan the math out backwards and put it all in at the end? 

And if I wanted to copy a variable at one point to use at a later point inh the calculations is that possible?

Thanks! Sorry for the questions, I’m the pointy end of the stick in making this happen!

@john.desborough I am pleased to report that I conquered the logic!! I did the entire thing from the second-to-last question BACKWARDS, with fewer variables - just tracking one variable through mutiple equations, copying it once. The key gamechanger came in creating IF statements that truly did depend on the outcome of the last calculation. This meant my order of math changed and variables dropped. It’s 22 steps and uses 9 variables (some of which are pre-populated numbers). I think this is my work achievement of the year! Thankyou so much for your help 

I’m late to the party, but yay!! Glad to hear you got this working, @EvoKneevo and thanks for the help, @john.desborough !