This content has been marked as final. Show 6 replies
I am looking at a problem where I have a site that produces 10 units a day and has capacity of 50units. I want to put together a delivery schedule where I'm cumulating the number of units on site that resets once the site reaches 50 eg see table below:
The formula needs to be something along the line of
IF( Previous days quantity (Q-1) + Increase (P) > Capacity (C),
Q-1 + P -C,
However I don't know how to reference the previous quantity. When culminating values before I have used rangesum(above( but to be entirely honest don't full understand the function.
Any help would be much appreciated.