Sum formula needs to be zero if not positive
Closed
LJ
-
Jul 25, 2010 at 09:20 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 25, 2010 at 03:41 PM
rizvisa1 Posts 4478 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
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
Related:
- Sum formula needs to be zero if not positive
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 25, 2010 at 03:41 PM
Jul 25, 2010 at 03:41 PM
use if statement
=if(sum(b:b) <0,"", sum(b:b))
=if(sum(b:b) <0,"", sum(b:b))
