Hi so I am using Excel on PC and I have to distribute a certain number of inventory (cell T2) into orders at different locations (cell A2:R2). However, I have to make sure that the inventory is greater or equal to target inventory (cells A13:R13).
However, the final distribution can not exceed the order number (which is the maximum limit) even if the target inventory is higher than order.
Can anyone help me crack this w any formula?
Hi,
In order to give the most precise answer possible, can you provide us with a file with the elements in your possession and the desired result?
BR,
Lionel
Attached below
If i understand correctly we are going to need to know who gets the prioity if you have insufficent Inventory.
Do you not give anything to the lowest (iignore 1's) as there is little point delivering 1 item, or do you reduce each delivery by the percentage difference and round but make sure everyone gets something (which seems to be what you are trying) or is there other criteria - nearest or more important customer gets special treatment?
So the point that I am trying to achieve is that if there is insufficient inventory, even then all the customers get some of it. There is no priority, just want to distribute a number to each higher than the target and lower than what they have ordered
(if target is higher than order, then automatically the order becomes the top limit)
order number-top limit
target number-bottom limit
