Hi,

Try this:

=INT(B2/72)&" Master carton, "&INT((B2-INT(B2/72)*72)/12)&" Inner carton,
"&B2-INT(B2/72)*72-INT((B2-INT(B2/72)*72)/12)*12&" individual"

assumed you are going to enter the number in B2

Thanks,
--
Farhad Hodjat


"kinsey" wrote:

1 master carton contains 72 pieces
1 master carton has 6 inner cartons each with 12 pieces (6 x 12 = 72)

I want to create a worksheet which when I enter a number of pieces it will
show me
in one box the number of full carton (72 pieces), in one box the number of
part cartons, and in another box the number of individual pieces left.
So for example enter 100 it would return in one 1 (mulitple of 72), in
second box
2 (2 x 12 = 24) and in last box 4 (4 individual pieces)

Any ideas? Regards Kinsey