Sum formula needs to be zero if not positive

Closed
LJ - Jul 25, 2010 at 09:20 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jul 25, 2010 at 03:41 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jul 25, 2010 at 03:41 PM
use if statement

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