decreasing # to stop decreasing when <=0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

increasing or decreasing a cell 16
Calculating a percent decrease 2
Excel - Sliding decreasing scale (payroll tax calc) 2
percentage in brackets 2
how do I get a function formula cell to format as a number? 5
DECREASE CELL VALUES BY 50% 2
SUMPRODUCT sum until condition changes 1
Counts/Percents Multiple Criteria 2

Back
Top