If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I display negative numbers a "0"?
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. |
#2
|
|||
|
|||
how do I display negative numbers a "0"?
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" wrote: 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. |
#3
|
|||
|
|||
how do I display negative numbers a "0"?
One way...
=MAX(0,your_formula) =MAX(0,B1-A1) -- Biff Microsoft Excel MVP "Ken" wrote in message ... 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. |
#4
|
|||
|
|||
how do I display negative numbers a "0"?
"Ken" wrote:
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 ----- "Ken" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|