Need formula to change cells from negative numbers to a zero.
 

I am creating a work sheet with several different formulas in it (all
accounting formulas) and after entering numbers into other cells it changes
some of the other cells to have a negative balance. OK, so I need to know if
there is a formula that I can enter into certain cells that will change any
negative balance no matter what it may be from showing the negative balance
to showing a zero (0) instead? Does anyone know how to do this or have any
suggestions on how I could find out?

Need formula to change cells from negative numbers to a zero.
 

Use the MAX function coupled with your formula...

=MAX(0,<YourFormula)

--
Rick (MVP - Excel)


"CPS Nevada" <CPS wrote in message ...
I am creating a work sheet with several different formulas in it (all
accounting formulas) and after entering numbers into other cells it changes
some of the other cells to have a negative balance. OK, so I need to know if
there is a formula that I can enter into certain cells that will change any
negative balance no matter what it may be from showing the negative balance
to showing a zero (0) instead? Does anyone know how to do this or have any
suggestions on how I could find out?

Need formula to change cells from negative numbers to a zero.
 

Try this:

=MAX(0,your_formula)

If your_formula produces a negative value then this will return zero,
but if your_formula is positive then that is larger than 0 and so gets
returned.

Hope this helps.

Pete

On Feb 10, 11:59*pm, CPS Nevada <CPS
wrote:
I am creating a work sheet with several different formulas in it (all
accounting formulas) and after entering numbers into other cells it changes
some of the other cells to have a negative balance. OK, so I need to know if
there is a formula that I can enter into certain cells that will change any
negative balance no matter what it may be from showing the negative balance
to showing a zero (0) instead? Does anyone know how to do this or have any
suggestions on how I could find out?