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?