Goal Seek without using Goal Seek

[aquelious]

I have a query I'm hoping someone can help with.
Essentially I have the following formula in that gives me a final figure in C2: =((A2*1)/(1-B2))*1.12
A2 is a number
B2 is a %

What I want is to be able to have in D2 a goal number for an alternative outcome, and then a formula in E2 that tells me what % I need in B2 so that the output in C2 matches the output in D2.
I know I can use Goal Seek but I have over 10000 of these so goal seeking them individually is taking too much time.

Any help would be much appreciated.

 

[BigBeachBananas]

I have a query I'm hoping someone can help with.
Essentially I have the following formula in that gives me a final figure in C2: =((A2*1)/(1-B2))*1.12
A2 is a number
B2 is a %

What I want is to be able to have in D2 a goal number for an alternative outcome, and then a formula in E2 that tells me what % I need in B2 so that the output in C2 matches the output in D2.
I know I can use Goal Seek but I have over 10000 of these so goal seeking them individually is taking too much time.

Any help would be much appreciated.

Can you provide a numerical example?

 

[aquelious]

Can you provide a numerical example?

 

[BigBeachBananas]

How about this?

=1-1.12*(A2/D2)

 

[aquelious]

How about this?

=1-1.12*(A2/D2)

Absolutely perfect. That has just saved me so much time. Legend