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

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

Set up your sheet like this

72 12 1
100 1 2 4

With 72 in B1, 12 in C1 and 1 in D1.
100 in B1 and the following Formulas
B2
=INT(A2/B1)
C2
=INT((A2-B2*B1)/C1)
D2
=A2-B2*B1-C2*C1
--
HTH...

Jim Thomlinson


"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

MANY THANKS
--
kinsey


"Farhad" wrote:

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

MANY THANKS
--
kinsey


"Jim Thomlinson" wrote:

Set up your sheet like this

72 12 1
100 1 2 4

With 72 in B1, 12 in C1 and 1 in D1.
100 in B1 and the following Formulas
B2
=INT(A2/B1)
C2
=INT((A2-B2*B1)/C1)
D2
=A2-B2*B1-C2*C1
--
HTH...

Jim Thomlinson


"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