Divide an number of jobs without ending up with decimals

**valius** · 04-02-2009, 04:25 PM

Hi all,

First post but wont be my last great site!

I'd appreciate some help with a little project I have been working on.

My knowledge of VB is nil (at the moment)

I'm trying to create a formula which will allow me to do the following

1. Enter the number of jobs received
2. Divide it by the staff available without ending up with decimals.

As an example. Say I have 60 jobs to be allocated and there are 13 peeps to distribute them to I'm currently getting 4.62. What I need to do is make sure that the jobs are only issued as whole numbers. E.g 5 peeps gets 4 and 8 get 5. I also need to factor in jobs on hand etc but I have already cracked this.

Hope that makes sense?

Any help would be appreciated. Thanks.

**daddylonglegs** · 04-02-2009, 04:40 PM

If you have the number of jobs in A2 and the number of staff in B2 then you can use this formula in D2 to get the low number [of jobs]

=INT(A2/B2)

Then in D3 to get the high number [if there is one]

=IF(MOD(A2,B2),D2+1,"")

Then in E2 to get the number of people working the number of jobs in D2

=B2-MOD(A2,B2)

and in E3

=IF(D3="","",B2-E2)