software

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: www.excelforum.com/member.php...oamp;userid=33063
View this thread: www.excelforum.com/showthread...hreadid=528761
If your cell gives negative values due to a formula try this:

=if(FORMULA IN CELLlt;0,0,FORMULA IN CELL)--
renegan
------------------------------------------------------------------------
renegan's Profile: www.excelforum.com/member.php...oamp;userid=10450
View this thread: www.excelforum.com/showthread...hreadid=528761
If your cell gives negative values due to a formula try this:

=if(FORMULA IN CELLlt;0,0,FORMULA IN CELL)--
renegan
------------------------------------------------------------------------
renegan's Profile: www.excelforum.com/member.php...oamp;userid=10450
View this thread: www.excelforum.com/showthread...hreadid=528761Use a custom format (Cells(Formatgt;Custom) of

General;quot;0quot;;General

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;GregP1962quot; gt; wrote
in message ...
gt;
gt; how do I make a cell show zero if the number is negative? Excel help
gt; doesn't have this info in a redily available place.
gt;
gt;
gt; --
gt; GregP1962
gt; ------------------------------------------------------------------------
gt; GregP1962's Profile:
www.excelforum.com/member.php...oamp;userid=33063
gt; View this thread: www.excelforum.com/showthread...hreadid=528761
gt;
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,
Elkarquot;GregP1962quot; wrote:

gt;
gt; how do I make a cell show zero if the number is negative? Excel help
gt; doesn't have this info in a redily available place.
gt;
gt;
gt; --
gt; GregP1962
gt; ------------------------------------------------------------------------
gt; GregP1962's Profile: www.excelforum.com/member.php...oamp;userid=33063
gt; View this thread: www.excelforum.com/showthread...hreadid=528761
gt;
gt;


renegan Wrote:
gt; If your cell gives negative values due to a formula try this:
gt;
gt; =if(FORMULA IN CELLlt;0,0,FORMULA IN CELL)...or

=MAX(0,formula)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=528761
I used the first one. Thanks!

=if(FORMULA IN CELLlt;0,0,FORMULA IN CELL)--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: www.excelforum.com/member.php...oamp;userid=33063
View this thread: www.excelforum.com/showthread...hreadid=528761On Fri, 31 Mar 2006 15:12:32 -0800, Elkar gt;
wrote:

gt; Are these numbers the result of a formula? If so, then you can use the MAX()
gt; function.
gt;
gt; =MAX(0,yourformula)
gt;
gt; This displays the larger of the two numbers, so if your formula results in a
gt; 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.gt;
gt;
gt; quot;GregP1962quot; wrote:
gt;
gt; gt;
gt; gt; how do I make a cell show zero if the number is negative? Excel help
gt; gt; doesn't have this info in a redily available place.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; GregP1962
gt; gt; ------------------------------------------------------------------------
gt; gt; GregP1962's Profile: www.excelforum.com/member.php...oamp;userid=33063
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=528761
gt; gt;
gt; gt;