how do I display negative numbers a "0"?

[Ken]

If a formula gives me a negative number, I want to disply it as zero. Can
you show me how to make that work? In other words, if a formula creates a
value of
"-14", I want it to show up as "0" in the cell.

 

[FloMM2]

Ken,
If your formula is as follows:
"=A1-B1"

You would need to edit as follows:
"=IF((A1-B1)>0,(A1-B1),0)"

What this tells excel is, if A1-B1 is greater than 0 (True), then give me
that result. If A1-B1 is greater than 0 (False), then give me a 0.
hth

 

[T. Valko]

One way...

=MAX(0,your_formula)

=MAX(0,B1-A1)

 

[Joe User]

if a formula creates a value of "-14",
I want it to show up as "0" in the cell.

If you want to change the value to zero, then:

=MAX(0, A1-A2)

where A1-A2 represents your formula.

If you want the value to remain -14, and you only want to change the way it
is displayed(!), then use a Custom format. The right Custom format to use
depends on what your original format is. If it is General, then:

General;\0;General

PS: I am assuming that you meant the formula creates the number -14, not
the string "-14". Right?


----- original message -----