Making negative numbers show as zero.
 

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


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=528761

Making negative numbers show as zero.
 

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

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


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=528761

Making negative numbers show as zero.
 

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

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


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=528761

Making negative numbers show as zero.
 

Use a custom format (Cells(FormatCustom) of

General;"0";General

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"GregP1962" wrote
in message ...

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


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile:
http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=528761

Making negative numbers show as zero.
 

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


"GregP1962" wrote:


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


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=528761

Making negative numbers show as zero.
 

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

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


...or

=MAX(0,formula)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528761

Making negative numbers show as zero.
 

I used the first one. Thanks!

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


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=528761

Making negative numbers show as zero.
 

On Fri, 31 Mar 2006 15:12:32 -0800, Elkar
wrote:

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.

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.




"GregP1962" wrote:


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


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=528761