Sum formula needs to be zero if not positive
Closed
LJ
-
25 Jul 2010 à 09:20
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 25 Jul 2010 à 15:41
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 25 Jul 2010 à 15:41
Related:
- Sum formula needs to be zero if not positive
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Formula to calculate vat in excel - Guide
- Spreadsheet formula - Guide
- Number to words in excel formula - Guide
- Grade formula in excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
25 Jul 2010 à 15:41
25 Jul 2010 à 15:41
use if statement
=if(sum(b:b) <0,"", sum(b:b))
=if(sum(b:b) <0,"", sum(b:b))
