Divide without point

[Dexir]

Hi,
I hv some amount like 25000. and I want to divide it on 9 employee. It show result in point like 2777.78
I want result without points. Like if I give 2778 to 7 person and 2777 to other 2 person. with this I can easily divide amount on all 9 employee.
if there is any formula which I can divide amount without points so please help me.

 

[FormR]

Hi, here is one option - the formula in B2 is copied down to B10.

Excel 2013/2016
	A	B
1		Apportioned Amount
2	25000	2778
3		2778
4		2778
5		2778
6		2778
7		2778
8		2778
9		2777
10		2777
Sheet1

Cell Formulas
Range	Formula
B2	=ROUNDUP(($A$2-SUM(B$1:B1))/(10-ROWS(B$2:B2)),0)

 

[Dexir]

Thank you so much, it's working now, but if I need to divide on multiple employee than what should I do ?
means if I need to divide any amount on 30+ employee ?

 

[FormR]

means if I need to divide any amount on 30+ employee ?

Hi, something like this? The number of employees can be entered in B2 and the formula in C2 can be copied down as far as may be required.

Excel 2013/2016
	A	B	C
1	Amount to Divide	Employees to divide by	Divided Amount
2	25000	11	2273
3			2273
4			2273
5			2273
6			2273
7			2273
8			2273
9			2273
10			2272
11			2272
12			2272
13
14
15
Sheet1

Cell Formulas
Range	Formula
C2	=IF(ROWS(C$2:C2)>$B$2,"",ROUNDUP(($A$2-SUM(C$1:C1))/(($B$2+1)-ROWS(C$2:C2)),0))

 

[Dexir]

Thank you, it is working,, if this is possible that I get result as >Give 2278 to 9 employee and 2277 to other 3 employee<
so kindly guide me, your help will be really appreciated.

 

[FormR]

if this is possible that I get result as >Give 2278 to 9 employee and 2277 to other 3 employee<

Hi, like this?

Excel 2013/2016
	A	B	C
1	Amount	Employees	Result
2	25000	11	Give 2273 to 8 employees and 2272 to other 3 employees
3	25000	10	Give 2500 to 10 employees
4	10	4	Give 3 to 2 employees and 2 to other 2 employees
5	100	12	Give 9 to 4 employees and 8 to other 8 employees
6	5	11	Give 1 to 5 employees and 0 to other 6 employees
Sheet1

Cell Formulas
Range	Formula
C2	="Give "&ROUNDUP(A2/B2,0)&" to "&IF(MOD(A2,B2)>0,MOD(A2,B2)&" employees"&" and "&INT(A2/B2)&" to other "&B2-MOD(A2,B2)&" employees",B2&" employees")

 

[Dexir]

it is working perfect.
thank you so much.