Issues with dividing share

[DJDJDJDJ]

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.

 

[Snakehips]

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
	A	B
1	Name	Share
2	John	0.3333333333333330
3	Tim	0.3333333333333330
4	Steve	0.3333333333333330
Sheet5

Cell Formulas
Range	Formula
B2	=1/COUNTA($A$2:$A$6)

Hope that helps.

 

[DJDJDJDJ]

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.