Formula to distribute units based on weight, rounded to whole number, but sum to proper total

[amyvdk]

Hi there,
I'm having trouble figuring out a formula that will distribute my total number of units by weight. I need to round the result to the nearest whole number but I also need the total units once distributed to sum to the proper total.

Row 1	6.2%	6.4%	8.6%	9.4%	10.4%	9.6%	8.1%	7.7%	7.8%	9.1%	9.0%	7.7%	100.0%
Row 2
Row 3	JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPTEMBER	OCTOBER	NOVEMBER	DECEMBER	TOTAL	Actual total
Row 4	1	1	1	1	2	1	1	1	1	1	1	1	15	13
	1	1	1	1	1	1	1	1	1	1	1	1	9	12
	formula in row 4:
	IF(ISERROR($M$4*A1)," ",($M$4*A1))

<tbody>
</tbody>

 

[Aryatect]

Based on what I understood, are you looking for something like below:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	6.20%	6.40%	8.60%	9.40%	10.40%	9.60%	8.10%	7.70%	7.80%	9.10%	9.00%	7.70%	100.00%
2
3	JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPTEMBER	OCTOBER	NOVEMBER	DECEMBER	TOTAL	Actual total
4	1	1	1	1	2	1	1	1	1	1	1	1	15	13
5	1	1	1	1	1	1	1	1	1	1	1	1	9	12
Sheet1

Cell Formulas
Range	Formula
A4	=IF($M4="","",ROUND($M4*A$1,0))
N4	=SUM(A4:L4)

 

[amyvdk]

Based on what I understood, are you looking for something like below:

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	6.20%	6.40%	8.60%	9.40%	10.40%	9.60%	8.10%	7.70%	7.80%	9.10%	9.00%	7.70%	100.00%
2
3	JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPTEMBER	OCTOBER	NOVEMBER	DECEMBER	TOTAL	Actual total
4	1	1	1	1	2	1	1	1	1	1	1	1	15	13
5	1	1	1	1	1	1	1	1	1	1	1	1	9	12

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula A4 =IF($M4="","",ROUND($M4*A$1,0)) N4 =SUM(A4:L4) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

That's certainly an option, it's the inverse way of thinking about it. The original goal was to distribute the 15 units across each month by seasonal weight.