Acheive a a declining subtraction to 0 rather than a negative number

[sipa]

Hi all,

I'm not sure how to explain my problem, so I've attached a sample spreadsheet. I think that might be clearer than my explanation.

What I'm trying to achieve is a declining subtraction to 0 rather than a negative number, as I've shown in row 25.
Also in row 22 I would like the values to show 0 from the left until the last positive figure in row 25.
In cell B21 I would like to show the figure carried over as shown in cell K22.


Many thanks

[pjwhitfield]

theres probably a more elegant solution (involving MIN) but just wrap your calc in an IF statement

=IF(A1 - B1 < 0,0,A1 - B1)

[sipa]

Thanks for the reply to the problem in row 25.
It almost works , but it leaves the result 24 short, ie it subtracts 225 from the predicted production, it needs to do one more subtraction to reach 249. then the next cell onwards should show zero.

Thanks

[pjwhitfield]

my post though was just an example, you'd use whatever calculation you have currently in the cell (in place of the A1 - B1) but you're simply saying, if the answer is < 0 then make it zero otherwise give the answer to the calculation.