Formula

[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"?

 

[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

 

[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