division please help

[rhon101]

I have been working on a spreadsheet for work since fall of last year. We are using one that does not work correctly. There is one thing that I can not figure out. I will give you an example.
I need to make a work distribution spreadsheet. It is suppose to distribute work to each employee as evenly as possible.
This is what my spreadsheet does: for example
there is 1111 medicare claims that needs to be divided as evenly as possible between 4 employees. For each four employees it indicates they they should do 278 claims a piece. However this is not right because that equals 1112 claims. I want it to give three people 278 claims and give one 277. I don't know what function to use for the formula... any suggestions? thanks

[Ron Coderre]

Here's something that might get you on the right track:

Put any value in Cell A1.

In cells B1 and C1 put:
=ROUND($A1/3,0)

In Cell D1 put:
=$A1-ROUND(A1/3,0)*2

Sometimes person #3 (Column D) will get one extra item more, sometimes one less (depending on the rounding)

See if that helps.

Regards,
Ron