display negative number as zero
 

I am doing a inward/outward stocktake and sometimes it returns a negative
number. I want to be able to display this negative number as zero but display
any positive numbers as they are.

display negative number as zero
 

Try this:

=MAX(your formula,0)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"sue" wrote in message
...
I am doing a inward/outward stocktake and sometimes it returns a negative
number. I want to be able to display this negative number as zero but
display
any positive numbers as they are.

display negative number as zero
 

This should do it for you
=IF(A1<0,0,"formula")
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Ragdyer" wrote:

Try this:

=MAX(your formula,0)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"sue" wrote in message
...
I am doing a inward/outward stocktake and sometimes it returns a negative
number. I want to be able to display this negative number as zero but
display
any positive numbers as they are.

display negative number as zero
 

If you want to display 0, but retain the negative value in the cell, you
could try a custom number format:

#;"0";0


"sue" wrote:

I am doing a inward/outward stocktake and sometimes it returns a negative
number. I want to be able to display this negative number as zero but display
any positive numbers as they are.