how do I display negative numbers a "0"?

  • Thread starter Thread starter Ken
  • Start date Start date
K

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.
 
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
 
Ken said:
if a formula creates a value of "-14",
I want it to show up as "0" in the cell.
Click to expand...

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 -----
 
Back
Top