can you help me expand on this further by adding a pallet count to this i.e. 30 full boxes = 1 pallet
Thanks.
=INT(A2/B2)&" full box of "&B2&" and "&MOD(A2,B2)&" inner's"
Edit Mod
This post is related to
https://www.msofficeforums.com/excel...pack-qtys.html