Hello all, I have 2000 items and want to represent them as full cartons -
inner cartons and single items. Full cartons have 36 pieces inner cartons
have 6 pieces and singles are self explanatory.

I tried using the INT formula but I can't seem to get it to work. Is there
something else I can use?

So want it to look like this

stock 2000 -
master cartons 55 ( 55x36=1980)
inner cartons 3 ( 3 x 6=18)
singles 2 ( 2 x 1)

regards
--
kinsey