T
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
value of this cell is a negative value
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
pinmaster
Hi, how about:
=IF(SUM(A1:A10)<0,0,SUM(A1:A10))
HTH
JG
=IF(SUM(A1:A10)<0,0,SUM(A1:A10))
HTH
JG
B
Bob Phillips
Use a Custom Format, such as
General;\0
--
HTH
RP
(remove nothere from the email address if mailing direct)
General;\0
--
HTH
RP
(remove nothere from the email address if mailing direct)
D
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.
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.
M
Max
Another way: =MAX(0,SUM(A1:A10))
C
Caplin Girl
Great this one worked perfectly for me! I tried 2 other suggestions but they
didn't work at all.
didn't work at all.