New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Redistribute a remaining percentage

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Redistribute a remaining percentage

Postby LadyJ » Thu Oct 27, 2016 4:15 pm

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

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

Re: Redistribute a remaining percentage

Postby ConneXionLost » Fri Oct 28, 2016 3:33 pm

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
Location: Canada
Reputation: 19
Excel Version: 2003, 2010

Redistribute a remaining percentage

Postby Embobebof » Sat Dec 10, 2016 2:25 am

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


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 42 guests

cron