Hello to everybody,
is there an Excel formula to find the max objects can I fit on a certain area?

For example:
Obj Dim 1 = 22 cm
Obj Dim 2 = 30 cm

Area Dim 1 = 80 cm
Area Dim 2 = 120 cm

With
=Max(Int(80/22)*int(120/30);Int(80/30)*int(120/22)) the result is 12 pieces

However I can fit 13 pieces like:

(30+30+30+30) * 22 - first row (120cm - 4 pieces)
(30+30+30+30) * 22 - second row (120cm - 4 pieces)

then I rotate the object of 90°

(22+22+22+22+22) * 30 - third row (110 cm - 5 pieces)

I hope I have been able to explain my question and hope You guys can help me.
Regards
Gimmy