divide number to cells by percentage

[mrzuna]

Hello everyone, I need a help about something which seems to be easy :D

For example

I have # people and I need to assign them by percentage in 6 groups

I would like to put # in one cell for example 25 which is cell $H$13

so I have put the formula (=+17%*$H$13)... and so on across 6 cells where I get the results

1gr 17%=4
2gr 17%=4
3gr 7%=2
4gr 13%=3
5gr 10%=3
6gr 36%=9

so in case of 25 people i got ok results, but when I pu 22 people I got this results

1gr 17%=4
2gr 17%=4
3gr 7%=2
4gr 13%=3
5gr 10%=2
6gr 36%=8

which is actually 23 not 22

any help would be good, I tried a lot od things and can't get with result

TY

 

[pedro-egoli]

Hello everyone, I need a help about something which seems to be easy :D

For example

I have # people and I need to assign them by percentage in 6 groups

I would like to put # in one cell for example 25 which is cell $H$13

so I have put the formula (=+17%*$H$13)... and so on across 6 cells where I get the results

1gr 17%=4
2gr 17%=4
3gr 7%=2
4gr 13%=3
5gr 10%=3
6gr 36%=9

so in case of 25 people i got ok results, but when I pu 22 people I got this results

1gr 17%=4
2gr 17%=4
3gr 7%=2
4gr 13%=3
5gr 10%=2
6gr 36%=8

which is actually 23 not 22

any help would be good, I tried a lot od things and can't get with result

TY

If you format cell to number/2 decimal places you will get your 22.
The total of the 2 decimal points come to 4 which added to the total of the whole part of numbers of 18 gives you the 22.

Pedro