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
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
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.
*If you wish you click on *,a way to say ThankYou
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
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
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
yes,
e50 needs to give a total pallet count
Edited Correct oversight in formula.
Please try in E50Although in the event of 0 that would count 1 ... so this instead.Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Last edited by FlameRetired; 01-28-2020 at 01:14 PM. Reason: correct oversight in formula
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks