Pallets & Cartons Calculator

[AndyEthy]

Hi!

I need to put together a pallet & carton calculator for specific export packaging.

For some reason I cannot attach a file to this post which makes this more difficult to explain...

I have two tables to work with, A, B, C = Product information (SKU, Amount of packs that fit in pallet, Amount of packs that fit in carton)

What I need to work out is how many pallets & cartons are required based on the around of packs in say column F. Column G would have Pallet answer & H Carton answer

For example if a pallet holds 560 packs & a carton holds 72 packs then 704 packs would equate to 1 pallet & 1 carton, 1,120 packs would be two pallets & 0 cartons.

Hopefully this will be something that can be done

Thanks

[BlindAlley]

To post an example, go to Advanced, Manage Attachments, Browse for file, Upload, then close the window. The file cannot be larger than 1meg though.

[AndyEthy]

Thanks for that , file now attached

[AliGW]

In G2:

=INT(F2/B2)

In H2:

=ROUNDUP((F2-(B2*G2))/C2,0)

[AndyEthy]

Thanks, that works perfectly

[AliGW]

No worries.