We have a current QTY of 30 cases on the floor. We have replenishment orders that will add additional inventory, but have also reserved qty for future orders. We can still add an order, but for how many cases? The answer is 20, but I figured this out by entering numbers into cell K9.
I'm trying to write a formula that achieves the number 20 for cell K9. 20 is the highest possible qty for the new order without triggering an error.
I've spent more than a few hours trying to write a formula to determine the qty of available inventory today. The answer is 20, but I need to get there with a simple formula. This needs to be replicated each day and send to team.
Can someone help me please?
Thanks
Bookmarks