Sum formula needs to be zero if not positive

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am using an Excel "sum" formula, but I don't want the answer to go below zero. How do I get a sum to show zero, unless the answer is positive?

L.J.
Texas

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
use if statement

=if(sum(b:b) <0,"", sum(b:b))