Issues with dividing share

DJDJDJDJ

New Member
Hi,

I have a spreadsheet that calculated a share equally between individuals that are part of a car deal. A deal can have anywhere between 1-5 shares. I am calculating these shares automatically based on how many names I have entered. I simply could the cells with test and divide the shares equally based on that. I have additional calculations based on these shares.

This works fine for even number of members. However, for odd number (such as below), I am left with a remainder. This messes up all the calculations because numbers do not match up. Is there a way around this remainder issue? Perhaps automatically assign one person the remainder?

 Name Share % John .33 Tim .33 Steve .34

<tbody>
</tbody>

Thanks.

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Snakehips

Well-known Member
DJDJDJDJ,

Welcome to MrExcel.

If you use something like the below to compute your basic share then does that divide with sufficient accuracy?

Excel 2007
AB
1NameShare
2John0.3333333333333330
3Tim0.3333333333333330
4Steve0.3333333333333330
Sheet5
Cell Formulas
RangeFormula
B2=1/COUNTA(\$A\$2:\$A\$6)

Hope that helps.

DJDJDJDJ

New Member
Thank you Tony. I will check it out.

As an alternative, we have decided that any time there is an odd number of shareholders, 1% goes to charity.

Replies
3
Views
1K
Replies
1
Views
247
Replies
0
Views
292
Replies
5
Views
3K
Replies
2
Views
329

1,196,021
Messages
6,012,904
Members
441,740
Latest member
Latrs

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.

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

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