format a cell to read zero for any negative value
 

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

format a cell to read zero for any 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

format a cell to read zero for any negative value
 

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

format a cell to read zero for any 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

format a cell to read zero for any negative value
 

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