i am assuming this is an order of operations thing. i am trying to back into a number though and can't do it. the formula to get the payout is B2+(B1-B2)*B3
i was trying to back into it by individual steps: so i take $3,884
then $3,326 (which is 7,210-3,884)
$3,884 +$3,326= $7,210
if i take that and * 2.25 i get 16,223 and not the 11,367 i am supposed to
what am i doing wrong?
i was trying to back into it by individual steps: so i take $3,884
then $3,326 (which is 7,210-3,884)
$3,884 +$3,326= $7,210
if i take that and * 2.25 i get 16,223 and not the 11,367 i am supposed to
what am i doing wrong?
Column A | Column B |
Commissioned Revenue | $7,210 |
Commission Goal | $3,884 |
Multiplier | 225% |
Payout | $11,367 |