format a cell to read zero for any negative value

[Tony]

I would like some advise to show a zero value in a cell when ever the sum
value of this cell is a negative value

[pinmaster]

Hi, how about:

=IF(SUM(A1:A10)<0,0,SUM(A1:A10))

HTH
JG

[Bob Phillips]

Use a Custom Format, such as

General;\0

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tony" <[email protected]> wrote in message
news:[email protected]...
> I would like some advise to show a zero value in a cell when ever the sum
> value of this cell is a negative value

[David McRitchie]

Hi Tony,
You have two completely different responses, one will change
the value, the other will not change the value but will change
the display. Both replies are correct interpretations based on
how you asked the question.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Phillips" <[email protected]> wrote in message news:[email protected]...
> Use a Custom Format, such as
>
> General;\0
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Tony" <[email protected]> wrote in message
> news:[email protected]...
> > I would like some advise to show a zero value in a cell when ever the sum
> > value of this cell is a negative value
>
>

[Max]

Another way: =MAX(0,SUM(A1:A10))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--