Formula to calculate value based on reverse percentage

How do I create a formula to calculate a reverse value...for example, I can calculate Cell A3 by taking 10 (value in A1) and subtracting 25% (value in A2) to get 7.5. Obviously the formula for this could be something like: =(A2)+(A2)*B2/100. However, how do I create a formula for Cell A3 to reverse calculate this equation to get back to 10?. (8 + 25% = 10)

To try to explain, let me give you a different example. In the scenario below, the value of cell A3 should be 8. I get this value by taking the value of what Cell A3 should be (8) and adding the percent of Cell A2 (25%) which would give me the value of Cell A1 (10). I would like a formula that can calculate what should be in A3 based on the values in A1 and A2.

Please Login or Register  to view this content.

Hi aharvestofhealth,

I get this value by multiplying what should be in Cell A3 (8) by Cell A2 (25%) which would give me the value of Cell A1 (10)

I get 8x25% = 2
how are you getting 10 ?

Regards,
DILIPandey

<click on below 'star' if this helps>

=a2*(1+a2)

If:

A2 is your desried result
B2 is 25
C2 is 7.5

then in A2 use:

Please Login or Register  to view this content.

Ok... I guess its something like mathematical equations where we need to find the value of X - like we studied in our schools..

See :-
7.5=10-(10*(25/100))

Where 7.5 is A3 and 10 is A1

If you have A3 i.e, 7.5 and you would want to reach to A1 i.e, 10, you can use below equation:-

7.5=a-(a*(25/100))
7.5+(a*(25/100))=a
7.5+(a*0.25)=a
7.5=a-0.25a
7.5=0.75a
7.5/0.75=a
10=a




This is equation solving in mathematics..

In excel you can use equation like :- 7.5/(1-25%) which would result in A

where you already had 7.5 and 25% with you.

Regards,
DILIPandey

<click on below 'star' if this helps>

I'm sorry guys. I've done a terrible job of explaining here. 7.5 is not the value I am looking for, it's 8. Let me start over to try this in a more simple fashion. Disregard everything I illustrated in my first post. Cell B2 and C2 are known values. As you can see from image1.JPG, Cell A2 is the value I'm trying to calculate - this number should be 8. Cell A2 (8) plus the percentage of B2 (25%) equals C2 (10). We can easily create a formula for C2 by using =A2+A2*B2/100. What I'm trying to find is the reverse and can be seen below:

X +25% = 10

Or in other words X + B2(%) = C2

X should be the formula for A2.

=10/(1+25%)