Gord Dibben wrote:
A1 contains the cubic size of one little box.

A2 contains the cubic size of large box.

A3 contains the formula =A2/A1

So that means a 3x3x3 container should be able to hold at least two
2x2x2 boxes. Care to enlighten us how that's possible? After doing
that, continue to enighten us with how one packs 3 2x2x2 boxes into a
24x1x1 container.

Worst case, with container width, height and length denoted Cw, Ch and
Cl, respectively, and box width, height and length denoted Bw, Bh and
Bl, the container can hold only

INT(Cw/Bw)*INT(Ch/Bh)*INT(Cl/Bl)

boxes. Nonuniform orientation of noncube boxes within the container may
allow more than this number of boxes to fit in the container, but I
doubt anyone could pack the necessary logic into a single cell formula
to calculate that.