Split the numbers in excel in whole numbers, if the number given in percentage 50% 30% and 20% and avoid decimal values by rounding it to the nearest

[Gyanendra]

Split the numbers in excel in whole numbers, if the number given in percentage 50% 30% and 20% and avoid decimal values by rounding it to the nearest
the total count of all should be equal to the requested number

 

[Macropod]

Assuming the numeric data are in column B and the percentages are on row 1, put:
=ROUND(C$1*$B2,0)
in C2 and copy across & down to E6.

 

[Peter_SSs]

the total count of all should be equal to the requested number

If that is important, then you cannot have the one formula copied to all the cells. Using the formula from post 2 you can see that the total in row 3 is 16 not 15 and in row 6 it is 30 not 29.

25 01 24.xlsm
	B	C	D	E
1		50%	30%	20%
2	10	5	3	2
3	15	8	5	3
4	28	14	8	6
5	42	21	13	8
6	29	15	9	6
Split Numbers

Cell Formulas
Range	Formula
C2:E6	C2	=ROUND(C$1*$B2,0)

Instead, try something like this where the formula in D2 is copied across and down but there is a different formula in C2 copied down only.

25 01 24.xlsm
	B	C	D	E
1		50%	30%	20%
2	10	5	3	2
3	15	7	5	3
4	28	14	8	6
5	42	21	13	8
6	29	14	9	6
Split Numbers (2)

Cell Formulas
Range	Formula
C2:C6	C2	=B2-SUM(D2:E2)
D2:E6	D2	=ROUND(D$1*$B2,0)