decreasing # to stop decreasing when <=0
 

I have a formula that causes a number to decrease. I want to make it stop
when it reaches <=0, with remainder added somewhere else

decreasing # to stop decreasing when <=0
 

Seeing your formula would have been a big clue for us to use to offer help.

But I'll stab at it with my butter knife and hope I at least scratch the
surface.

Assume that in A2 you may have something like:
=A1-1

then you could try something like this in A2
=IF(ISERR(A1-1),"",IF(A1-1<=0,"",A1-1))
which would put a zero length string into the cell when value reaches zero.

"Ken" wrote:

I have a formula that causes a number to decrease. I want to make it stop
when it reaches <=0, with remainder added somewhere else