Making negative numbers show as zero.

G

GregP1962

how do I make a cell show zero if the number is negative? Excel hel
doesn't have this info in a redily available place
 
R

renegan

If your cell gives negative values due to a formula try this:

=if(FORMULA IN CELL<0,0,FORMULA IN CELL
 
R

renegan

If your cell gives negative values due to a formula try this:

=if(FORMULA IN CELL<0,0,FORMULA IN CELL
 
B

Bob Phillips

Use a custom format (Cells(Format>Custom) of

General;"0";General

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
E

Elkar

Are these numbers the result of a formula? If so, then you can use the MAX()
function.

=MAX(0,yourformula)

This displays the larger of the two numbers, so if your formula results in a
negative number, the 0 will be larger and thus be displayed.

HTH,
Elkar
 
J

Jay Somerset

Are these numbers the result of a formula? If so, then you can use the MAX()
function.

=MAX(0,yourformula)

This displays the larger of the two numbers, so if your formula results in a
negative number, the 0 will be larger and thus be displayed.
Click to expand...

It will also change the results of any calculations that in turn depend on
this cell. If this is what you want, fine. Alternatively, if you only want
negtive numbers to DISPLAY as zero, use a custom format (as shown in an
earlier response). This won't cause numeric values to change.
 
Top