Commission Calculation for my Employees.

[Excel_24]

Guys I Own a carwash and I do not know how to calculate commission basis for my Employees. The commission amount should be divided amongst my 4 employees. The problem is that If only 3 people worked on one vehicle, then the commission should be divided to only 3 employees who worked on that vehicle.​

 

[ExceLoki]

if you use this way, you mark the employees who worked on each car, then it figures how much each gets in the next set of columns
------------

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	using this	price	commision		employee1	employee2	employee3	employee4		employee1 commision	employee2 commision	employee3 commision	employee4 commision
2	1	1500	600		x	x				300	300
3	2	15000	6000			x	x	x			2000	2000	2000
4	3	2500	1000		x		x			500		500
5	4	8000	3200			x		x			1600		1600
Sheet1

Cell Formulas
Range	Formula
J1:M1	J1	=CONCATENATE(E1," ",$C$1)
J2:M5	J2	=IF(E2="x",$C2/COUNTA($E2:$H2),"")

 

[Excel_24]

Thank you So much with this Solution. Has helped me a lot and made my life EASIER. THANKS

 

[ExceLoki]

happy to help