Subtraction stop at zero formula

I'm trying to work on a spreadsheet to value inventory at the month it was produced. See the attached spreadsheet for an example. Essentially in C8 I want to deduct the production amount from the inventory amount. After CM I would only have 265 units left. I want to repeat the process going to the left until all units of inventory are accounted for. The part I'm struggling with is I want the formula to stop at 0, so E8 should have 82.. I could do an ABS for this amount but I want the rest of the cells going to the right to all say 0. Help is appreciated!

You could put this formula in C8:

=MAX($B2-SUM($C2:C2),0)

then copy across. Copy that row of formulae down on alternate rows.

Hope this helps.

Pete

It doesn't quite get me there. Following your formula I get a value of 265 in C8. Itt should be 178 since thats the total units of production from the current month which contribute to our ending inventory. D8 should be the full 182 and E8 should be 83 which is the remainder of all units. F8:H8 should all read zero.