Four boxes fit 48 kits. The shipment has 53, so those remaining five need a fifth box.

Keep the order size separate from box capacity

Enter 53 in B2 and 12 in C2. In D2 use =ROUNDUP(B2/C2,0). For positive capacity and nonnegative quantities, the final zero asks for whole boxes. Flag zero or missing capacity separately.

53 kits at 12 per box require five boxes.

Illustrated packing plan for identical kits and boxes.

Check a full shipment and a partial box

Use =D2*C2-B2 for the unused spaces. Expect 7 for 53 kits. In a scratch copy try 48 kits and expect four boxes with 0 spaces, then 0 kits and expect zero boxes. If weight or mixed sizes limit packing, account for those constraints separately.

The last box holds five kits with seven spaces left.

Illustrated capacity check.

Related Microsoft Excel reference