Excel 2007 : Production batch-help needed with formula

[Marzena]

Hi to everyone,
How can I write formula which will divide production batch for smaller lots Let's say total order for today is 93kg, but in one mix I can produce only 20kg, that means i will produce four batches of 20kg and the last one 13kg. I belive it is easy but I cannot get my head aroud it Any help with this would be great

[daddylonglegs]

If you have total order size (93) in A2 and max batch size (20) in B2 then try this in C2 for the number of full batches @ 20 kg

=INT(A2/B2)

and then in D2 this formula for the last batch size

=IF(MOD(A2,B2),MOD(A2,B2),"")