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

Hi, how about:

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

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=494490

Use a Custom Format, such as

General;\0

--

HTH

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


"Tony" wrote in message
...
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

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" wrote in message ...
Use a Custom Format, such as

General;\0

--

HTH

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


"Tony" wrote in message
...
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

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