Can someone help me? I made a work distribution spreadsheet and I can not get
it to divide evenly. What I am trying to do is divide the total number of
claims by the number of employees and distribute the result to each employee.
There are conditions also. For example one employee gets the max number of 50;
Here is my formula;

=IF(E18=0,0,IF(I19>250,50,(I19/(E8+E9+E10+E16)*E18)))
column E =# of hours working for each employee,
I19 = total number of claims.

If the total number of claims is 1500 and there are 5 people working it
returns 50 to the E18 employee and 363 to the rest, but this adds up to 1502
instead of 1500.
I want it to distribute 50, 362, 362, 363 and 363. Any advice?