Need help to write a formula in cell K9 to add the highest value without causing errors.
We have a current QTY of 30 cases on the floor. We have replenishment orders that will add additional inventory, but have also reserved product for future orders. We can still add an order, but for how much? I figured this is 20, but need a formula to determine easily.
Can someone help me please?
Thanks
Adam
Bookmarks