Is this the best way to get as close as I can get, easily, to what I want?

[CaraM]

I'm trying out division of assets scenarios. Balance is balance by account (negatives are debt, positives are assets). A is the % of the asset/liability to go to one person, B is for the other person. The totals from A + B don't equal the sum above Balance - is this because of rounding? Is SUMPRODUCT the easiest/most accurate way to sum up the resulting division of assets?

Split.xlsx
	G	H	I
2		61.6%	38.1%
3	1,547,603	953,083	589,916
4	BALANCE	A	B
5	5,979	50%	50%
6	33	100%
7	5		100%
8	263	100%
9
10	22,938		100%
11	16,380		100%
12	65,221	36%	64%
13
14	154,156	75%	25%
15	1,104	50%	50%
16	-10,558	50%	50%
17	-594	50%	50%
18	-2	50%	50%
19	-37		100%
20	61,073		100%
21	187,209	100%
22	8,886		100%
23	30,501		100%
24	49,084		100%
25	169,298	100%
26	460,461	33%	66%
27	12,267	100%
28	20,000	100%
29	20,000		100%
30	275,000	100%
31	-1,063		100%
Sheet1

Cell Formulas
Range	Formula
H2:I2	H2	=H3/$G$3
G3	G3	=SUM(G5:G101)
H3:I3	H3	=SUMPRODUCT($G$5:$G$101,H5:H101)
G14	G14	=37450.59+38864.93+38908.97+38931.13

 

[offthelip]

Your problem is because 33% and 66% doesn't add up to 100% it is 1% short which happens tobe exactly the value you get from 1% from 460,461
I suggest you need to add a few extra 0.33333 to H 26 and then do a 1 - H26 in I 26

 

[awoohaw]

Your problem is because 33% and 66% doesn't add up to 100% it is 1% short which happens tobe exactly the value you get from 1% from 460,461
I suggest you need to add a few extra 0.33333 to H 26 and then do a 1 - H26 in I 26

@offthelip , maybe not even use a decimal, but a fraction, just us (1/3) and (2/3).