Negative Numbers to Zero

[MSG K]

I am looking for a way to have negative numbers show up as 0. Any clue???

[Toppers]

=MAX(A1,0)

Or

=If(A1<0,0,A1)

HTH

"MSG K" wrote:

>
> I am looking for a way to have negative numbers show up as 0. Any
> clue???
>
>
> --
> MSG K
> ------------------------------------------------------------------------
> MSG K's Profile: http://www.excelforum.com/member.php...o&userid=36914
> View this thread: http://www.excelforum.com/showthread...hreadid=566270
>
>