Q:

Excel distribute value

I would like to divide a number X into possibly N equal values. I explain it in the following scenario. Let's say I have 8000 copies of newspaper and they are wrapped by N (lets say 20, and this can vary). So now I have 400 packets each containing 20 paper. Assume I have X pallets. I want to distribute the 400 packets equally between the pallets where possible. Because sometimes there are more/less paletts I cannot do it with a simple divison function, in excel. Can anyone help?

A:

Hope this helps .... formulas are below each cell 

A:

To get the number of pallets needed Use this formula, put in B3 and copy down:
=ROUNDUP(A3/($B$1*$D$1),0)

Then to get the disbursement table, in C3:
=IF(COLUMN(A:A)<$B3,$D$1,IF(COLUMN(A:A)=$B3,($A3/$B$1)-(COLUMN(A:A)-1)*$D$1,""))

Then copy drag over and down

