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
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 25, 2010 at 03:41 PM
Related:
- Sum formula needs to be zero if not positive
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Position formula in excel - Excel Forum
- Formulas for 1st and 2nd position in class - Office Software Forum
- Calculation of positions in excel ✓ - Excel Forum
- Logitech formula vibration feedback wheel driver - Download - Drivers
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
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))
