# Premium Excel Course Now Available!

## Redistribute a remaining percentage

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

### Redistribute a remaining percentage

I've got the above formula/answer in place but when I redistribute, it's still only adding up to 99% and we are off \$4.36 between my remaining 4 owners.

Ownership 100%-13.33% New % Redistributed contribution amount
50% 86.67% 57.69008884% \$21,811.94406
13.33% 86.67% 15.38017769% \$5,815.06429
13.33% 86.67% 15.38017769% \$5,815.06429
10% 86.67% 11.53801777% \$4,362.38881
\$37,804.46 But the original amount is \$37,808.82
So off \$4.36

Any help/suggestions on how to get that final \$4.36/.01% distributed correctly into the totals?

Edit mod: post related to viewtopic.php?f=2&t=7112&p=22392&hilit=redistribute#p22392
• 0

Rookie

Posts: 1
Joined: Oct 27, 2016
Reputation: 0
Excel Version: 2007

### Re: Redistribute a remaining percentage

You've given yourself rounding errors by only using two decimal places in the percent values.

In place of 13.33%, use =2/15, and in place of 86.67%, use =13/15.

Cheers,
• 0

ConneXionLost
Regular

Posts: 68
Joined: May 9, 2013
Reputation: 19
Excel Version: 2003, 2010

### Redistribute a remaining percentage

About a year has passed by and I am still wondering if this is possible. I now have the new XnViewMP. Any help, anyone?
• 0

Embobebof
Rookie

Posts: 3
Joined: Nov 3, 2016
Reputation: 0
Excel Version: 2007