# Calculate EXACT number to achieve an EXACT percentage

#### glotgering

##### New Member
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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

#### Eric W

##### MrExcel MVP
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.

#### glotgering

##### New Member
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

</tbody>
Sheet3

Worksheet Formulas
CellFormula
E4=I2*G2-D4

</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 Series Thousand Series Current 21,034,088 Current 4,250 Spent 360,575,295 Spent 175,252 Remaining 207,288,100 Remaining 92,503 % Current 67.201% % Current 67.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 Series Thousand Series Current 21,034,088 Current 4,681 Spent 360,575,295 Spent 175,252 Remaining 207,288,100 Remaining 92,503 % Current 67.201% % Current 67.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

#### Eric W

##### MrExcel MVP
What is the formula you use to calculate the percentages?

#### glotgering

##### New Member
What is the formula you use to calculate the percentages?

I just use sum like this =SUM(G2+G4)/SUM(G4,M4) and =SUM(I2+I4)/SUM(I4,O4)

Thank you

#### Eric W

##### MrExcel MVP
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.

#### glotgering

##### New Member
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%

</tbody>
Sheet1

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

</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?

#### Eric W

##### MrExcel MVP
I'm glad I could help out!

And I'm more than old enough to drink!

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!

#### glotgering

##### New Member
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.