decreasing # to stop decreasing when <=0

K

Ken

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
 
J

JLatham

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.
 
Top