Formula

N

nbaker

a formula for how many of a smaller box fits into a bigger box.

Example:

5" wide x 6" deep x 7" high box, how many fit by equation into a box 45" x
48" x 48"?
 
S

Sheeloo

Enter 5 in A1, 6 in B1, 7 in C1, 45 in D1, 48 in E1, and 48 in F1
and this formula in G1
=INT(D1/A1)*INT(E1/B1)*INT(E1/C1)

this will give you the answer... ofcourse this assumes that you won't fit
any boxes (keep them right side up) in the remaining 5" X 6" X 6" space
 
F

FSt1

hi
=(45*48*48)/(5*6*7)
this equals 493.7146 times
or the volumn of the larger box devided by the volumn of the smaller box.
not sure what answer you were looking for.
this formula is based on your numbers. you may choose to put the numbers in
cells??? in that case if large box is A1,A2,A3 and small box is b1,b2,b3 then
=(A1*A2*A3)/(B1*B2*B3)

close??
regards
FSt1
 
D

David Biddulph

If you insist that the boxes stay with the same orientation in the order as
described, then it's =INT(45/5)*INT(48/6)*INT(48/7)
Beyond that you could fit another 9*6 and then another 6, giving a total of
492.
The theoretical maximum if they could be packed perfectly would be
=45/5*48/6*48/7, so you can think about whether you could rearrange to fit
the exta one in to give 493.
 
Top