Reverse Formula

[Salomon Santillan]

Hello All,
New to this site, I was wondering if there is a way to reverse this calculation with a single formula;
100%=$P1 15%=$P2
50 = A
(A*$P1) = B
((A+B)*$P2) = C
(A+B+C)= D

Is there a way to perform the reverse calculation? Using number $D and The Percentages $P1 and $P2 is there a way to find out what A would be?

Please advise.
Thank you in advance.

[TMS]

If you rationalise all those formula into one, you end up with:

D1: =A1*(1+$P1+$P2+$P1*$P2)

So, A1: =D1/(1+$P1+$P2+$P1*$P2)


Regards

[Apelcius]

Agreed.

Or: A*P1+A+(A+B)Y=D
=>A=(D-B*P2)/(P1+P2+1)

tons of ways to do it

[TMS]

I was trying to eliminate all variables other than A and D so that D could be expressed in terms of A, not cells dependent on A.

Regards

[TMS]

b = (a*$p1) = a*$p1
c = ((a+b)*$p2) = (a+b)*$p2
d = (a+b+c) = a+b+c

d1: =a1+b1+c1

d1: =a1+a1*$p1+(a1+a1*$p1)*$p2

d1: =a1*(1+$p1+$p2+$p1*$p2)

d = a*(1+$p1+$p2+$p1*$p2)

a = d/(1+$p1+$p2+$p1*$p2)

[shg]

=d/(1+p1)/(1+p2)