Quote:
Originally Posted by xor
With outgoing stock in A2 and pack size in B2, try:
=INT(A2/B2)&" full box of "&B2&" and "&MOD(A2,B2)&" inner's"
|
Awesome thank you that works perfectly. Now to make it a bit trickier would it be possible to add a cell that adds the full carton and inner pick to return a single number?