Working out pallet quantaies from values and a look up table

[pmw19800]

hello

Please see attached

In E50 - I want this to work out how many pallets my orders will be from the quantities’ ordered…
So, it needs to look at the quantities ordered and somehow look at the rules to the right..


thanks for looking

Paul

[Sunny18pc]

Hi Paul,

Sorry but fail to understand you, as I think its your technical things that you said.
If you could simplify your words to make us understand better.

Or just explain what sum you want and with desired result in current sheet, any conditions if any.

[pmw19800]

Blue text - there is maximum of 25 boxes per pallet, anything above 25 boxes = 2 pallets above 50 boxes = 3 pallets
Orange text Separate Calculation- there is maximum of 25 boxes per pallet, anything above 25 boxes = 2 pallets above 50 boxes = 3 pallets

[avk]

What answer required in "E50"
You mean that 1 to 25 boxes = 1 pallet
26 to 50 boxes = 2 pallet
Above 51 boxes = 3 pallet

[pmw19800]

yes,

e50 needs to give a total pallet count

[FlameRetired]

Edited Correct oversight in formula.

Please try in E50

Please Login or Register  to view this content.

Although in the event of 0 that would count 1 ... so this instead.

Please Login or Register  to view this content.