I have a spreadsheet I use to calculate stock replenishment for an online retailer. I have a specific requirement that I need to maintain a certain stock level in both branches.
This dictates that 60 % of in stock items need to be available in both branches - not based on quantity per branch, but rather if the branch has stock or not.
so I need a formula to calculate something like - if a branch has 0 items in stock, the value will remain 0. If it has 1 or more in stock, the value will be 1. I can then use Sum total to calculate per branch the items in stock and maintain the required levels
Any assistance would be appreciated