Pallets, part pallets and cartons calculator

[Martin team]

What I need to work out is how many pallets & part pallets and cartons required based on amount of items.

For example if a pallet holds 90 items & a carton holds 10 items then 90 items(9 cartons) would equate to 1 pallet, 210 items would be 2 full pallets , 1 part pallet with 30 items on it... with is 3 cartons on the part pallet.

 

[JamesCanale]

Nicely done! The formula in D8 should be "=INT(A8/C8)", considering the different quantities in column C. That's the only addition I can think of!

right you are on that formula change

 

[Martin team]

Nicely done! The formula in D8 should be "=INT(A8/C8)", considering the different quantities in column C. That's the only addition I can think of!

This is exactly what I needed. You are a legend man. Thank You very much...

 

[HenkDePoema]

This is exactly what I needed. You are a legend man. Thank You very much...

That's kind of you, but @JamesCanale is the man to thank here!

 

[Martin team]

That's kind of you, but @JamesCanale is the man to thank here!

My bad... Thank You very much @JamesCanale