software

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)lt;0,0,SUM(A1:A10))

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=494490Use a Custom Format, such as

General;\0

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Tonyquot; gt; wrote in message
...
gt; I would like some advise to show a zero value in a cell when ever the sum
gt; 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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Bob Phillipsquot; gt; wrote in message ...
gt; Use a Custom Format, such as
gt;
gt; General;\0
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt; (remove nothere from the email address if mailing direct)
gt;
gt;
gt; quot;Tonyquot; gt; wrote in message
gt; ...
gt; gt; I would like some advise to show a zero value in a cell when ever the sum
gt; gt; value of this cell is a negative value
gt;
gt;
Another way: =MAX(0,SUM(A1:A10))
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--