# Not sure what formula I need to use

#### chris28uk

##### New Member
[h=2]
Can anyone help Thanks[/h]
Hi can anyone help me im a bit of an amateur when it comes to excel but basically ive been designing a quoting system for work and I need to know how many boxes i can get on a pallet to calculate the vehicle required. The height is irrelevant. I get the size from previous worksheets. I then need to find out how many times it will fit on a euro pallet 800 X 1200 and 1000 X 1200MM. I can have a little overhang.

Without complicating things I need to
1) divide the box size by the maximum size which is 1350 X 1350mm & 1000 X 1350mm to find the maximum boxes I can get per layer (Which I have Done)
2) Then if they are both say 6, then find the smallest which is what im having trouble with.

I need to find the largest BPP(D) so 6 on the first and 4 on the second then if they are equal like the first one then I need to find the lowest area. Which is in the far right column (E). So in B column I have =IF(P8=P10,MIN(Q8,Q10),MAX(P8,P10)) to find this but i need the the size not the area of the best layout. Additionally on the second it returned the BPP.

How can I find the highest BPP? And if they're the same the lowest area (E) then get it to return the size of the best (B) (C)
it's a little difficult to explain but I can try and explain anything you don't understand

Any help would be extremely appreciated I've actually been trying to find an answer for days on google now?? thanks again

................A .......B ......C .........D .....E

 W L Folded Box Size: 515 408 BPP Pallet W Pallet Length 1000 X 1200 Combinations 2 3 6 1260.72 1030 1224 3 2 6 1260.72 1224 1030 6 Best 1260.72 Euro Combinations 1 3 3 630.36 515 1224 2 2 4 840.48 816 1030 4 Best 4

<tbody>
</tbody>

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Replies
14
Views
175
Replies
1
Views
110
Replies
3
Views
286
Replies
1
Views
272
Replies
3
Views
261

1,127,294
Messages
5,623,824
Members
415,991
Latest member
RicardoSS

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back