Hi

I have many totals that I need to divide between 44 variables, each variable has its own % needed of the total. So the total is being divided by % rather than a number. However I need excell to give me the results as whole number with no decimal places as they are units (for example you can't get 1.5 people it has to be 1 or 2) For example see below:

1.37 3.05 6.09 13.04 10.46 19.34 7.71 14.15 2.67 4.91 0.46 0.75 5.70 3.99 0.06 0.18 1.03 2.58 0.04 0.34 0.89 1.59 0.46 0.95 0.69 1.99 0.36 0.60 0.09 0.29 0.04 0.04 0.02 0.04 0.00 0.06 0.92 0.96 0.21 0.05 0.72 1.08 0.00 0.00

I can remove the decimal places which produces this:

1 3 6 13 10 19 8 14 3 5 0 1 6 4 0 0 1 3 0 0 1 2 0 1 1 2 0 1 0 0 0 0 0 0 0 0 1 1 0 0 1 1 0 0

However the total was 110 so when divided there needs to be 110 units however there is 109 due to the next biggest unit falling below 0.5.

Is there a way I can tell excell to round to a whole number so that all of the units are distributed as whole numbers?

Let me know if this doesn't make sense.