Calculate EXACT number to achieve an EXACT percentage

glotgering

New Member
Joined
Oct 15, 2019
Messages
6
I know the exact % I need to achieve. In this example column G2 is the target % of 67.201%.

G2 = 67.201% (This is the target %)
D4 = 4,250 (This is the number I need to increase to meet the percentage. The amount I need it to be is 4,681 for a difference of 431)

As the percentage of G2 Changes I need to calculate the EXACT number to increase D4 to meet the percentage. I have looked at several examples but all are more complicated than I need and I cannot figure it out.

Any help is greatly appreciated.

Thank you all very much.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Welcome to the forum.

When you calculate a percentage, you are essentially comparing 2 numbers. You only provided one number, 4,250. However, 4,681 is 67.201% of 6,965.67. So apparently, 6,965.67 is your target number, and you are looking for a formula to raise 4250 up to 67.201% of 6,965.67. That formula is quite easy, see below.


Book1
DEFGHI
267.201%6965.67
3
44250431
Sheet3
Cell Formulas
RangeFormula
E4=I2*G2-D4
 
Upvote 0
Welcome to the forum.

When you calculate a percentage, you are essentially comparing 2 numbers. You only provided one number, 4,250. However, 4,681 is 67.201% of 6,965.67. So apparently, 6,965.67 is your target number, and you are looking for a formula to raise 4250 up to 67.201% of 6,965.67. That formula is quite easy, see below.

DEFGHI
267.201%6965.67
3
44250431

<colgroup><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet3

Worksheet Formulas
CellFormula
E4=I2*G2-D4

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>

OK, Thank you Eric...I was hoping this was simple but apparently it is more complicated than I thought. You are correct that I am comparing two sets of numbers but the problem is they have very different weights.

The first series is in millions while the second series is in thousands. I will try to give you the right information. I will PayPal you a 12 pack if you can figure this out - lol

OK

The million series consists of 3 cells each and I am trying to compare the difference with the thousand series

Million SeriesThousand Series
Current21,034,088Current4,250
Spent360,575,295Spent175,252
Remaining207,288,100Remaining92,503
% Current67.201%% Current67.040%
<colgroup><col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;"> <col width="64" style="width: 48pt;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;"> <tbody> </tbody>


If I manually change the value of 4,250 in the thousand series the percentages match exactly.

Million SeriesThousand Series
Current21,034,088Current4,681
Spent360,575,295Spent175,252
Remaining207,288,100Remaining92,503
% Current67.201%% Current67.201%
<colgroup><col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;"> <col width="64" style="width: 48pt;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;"> <tbody> </tbody>

I would like know the amount needed for current in the Thousand series. In this case it is 431

I hope this helps...again a twelve pack on me
 
Upvote 0
I wish you'd mentioned the M4 and O4 values earlier. It is impossible to figure out the percentage without knowing them. I tried to recreate your spreadsheet as best I could from your example and formulas. I then used Goal Seek to figure out the values for M4 and O4. Once I got that, then the formula to figure out the difference you need in I2 is easy. You can see it in J2. It's doesn't exactly match your 431 value, but that could be due to rounding errors and slight differences in the M4 and O4 values I derived.


Book1
FGHIJKLMNO
2Current21,034,088Current4,250429.3885
3
4Spent360,575,295Spent175,25213247320092500
5
6Remaining207,288,100Remaining92,503
7
8% Current67.201%% Current67.04%
Sheet1
Cell Formulas
RangeFormula
I8=(I2+I4)/(I4+O4)
J2=G8*(I4+O4)-I4-I2
 
Upvote 0
I wish you'd mentioned the M4 and O4 values earlier. It is impossible to figure out the percentage without knowing them. I tried to recreate your spreadsheet as best I could from your example and formulas. I then used Goal Seek to figure out the values for M4 and O4. Once I got that, then the formula to figure out the difference you need in I2 is easy. You can see it in J2. It's doesn't exactly match your 431 value, but that could be due to rounding errors and slight differences in the M4 and O4 values I derived.

FGHIJKLMNO
2Current21,034,088Current4,250429.3885
3
4Spent360,575,295Spent175,25213247320092500
5
6Remaining207,288,100Remaining92,503
7
8% Current67.201%% Current67.04%

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1

Worksheet Formulas
CellFormula
I8=(I2+I4)/(I4+O4)
J2=G8*(I4+O4)-I4-I2

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>

WOW!!! You did IT!!! 12 pack on me...(if you are old enough). Thank you so much! Can I please send you a donation on Paypal?
 
Upvote 0
I'm glad I could help out! :cool:

And I'm more than old enough to drink! (y)

And while I appreciate the offer of a donation, I'd prefer you just pay it forward. Help out a stranger, or give an equivalent donation to the Cancer Society. Have a great weekend!
 
Upvote 0
I am actually quite good with excel but just had a rough time with this formula. May I ask you how did you figure it out? I really do appreciate it.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top