Hi Codans!
I’m working on a formula that calculates a projection of what our inventory will be after 1 year. We can only purchase inventory once per year due to the nature of our business. If I start with 10 units and have an annual sales projection of 15 units, then my formula is: 10 - 15 = -5. We won’t actually have -5 units, we will have 0 units. Does anyone know how I can set a minimum calculation result number of 0 within my formula so I don’t have any negative numbers?
Thanks so much!
Reiley at Snake River Seed Cooperative