creating multiple answers

[kinsey]

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

 

[Farhad]

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,

 

[Jim Thomlinson]

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

 

[kinsey]

MANY THANKS
--
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,

 

[kinsey]

MANY THANKS
--
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