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

Rounding Negative Numbers to Zero 4
How to count the maximum number of consecutives? 9
Excluding Negative Numbers 9
Zero's show as being negative numbers 2
Divide two cells and if the number is negative display is as zero 2
Negative numbers 4
formula to a minimum value of zero if a negative number 2
( ) instead of - 4

Top