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

C

CPS Nevada

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?
 
P

Pete_UK

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
 

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

Cumulative formula for word table 0
Rounding Negative Numbers to Zero 4
How to count the maximum number of consecutives? 9
formula to a minimum value of zero if a negative number 2
Excluding Negative Numbers 9
Divide two cells and if the number is negative display is as zero 2
Separting negative numbers from letters in cells 1
How to change numbers from positive to negative. 2

Top