| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding decreasing numbers | Excel Discussion (Misc queries) | |||
| Solver Decreasing | Excel Discussion (Misc queries) | |||
| increasing and decreasing a value in a cell | Excel Worksheet Functions | |||
| Function for decreasing salary by 2.5% | Excel Worksheet Functions | |||
| formula for decreasing $420.00 by 4 percent | Excel Worksheet Functions | |||
Linear Mode
