Reverse Engineer a formula

[aquelious]

I have the following cell data.
A2 = 108.59
B2 = 20%
C2 = 27.15

C2 has the following formula in it: =A2/(1-B2) - A2
this gives me the 27.15

What I want to do is have in D2 a hard value of 23.00 and then in E2 I want the % value based on the formula in C2.
IE - If C2 was 23.00, what would B2 be.

Can anyone help?

 

[Joe4]

Try:

=1-(A2/(A2+C2))

 

[aquelious]

Try:

=1-(A2/(A2+C2))

As easy as that. Joe4 you are a legend. Thank you so much

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[Norie]

Try this formula.

=1-A2/(D2+A2)