# divide number to cells by percentage

#### mrzuna

##### New Member
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

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### pedro-egoli

##### Well-known Member
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

Replies
8
Views
343
Replies
1
Views
169
Replies
1
Views
125
Replies
10
Views
465
Replies
2
Views
104

1,191,719
Messages
5,988,295
Members
440,148
Latest member
sandy123

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back