Add cells, div by cells with value (Excel2007
Solved/Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Feb 16, 2010 at 12:25 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 16, 2010 at 03:33 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 16, 2010 at 03:33 AM
Related:
- Add cells, div by cells with value (Excel2007
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Copy cells from one sheet to another ✓ - Excel Forum
- Add accent over e - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 16, 2010 at 03:33 AM
Feb 16, 2010 at 03:33 AM
try this
=IF(AND(A3<=0,B3<=0, C3<=0),0,(a3+b3+c3)/IF(AND(A3>0,B3>0,C3>0),3,IF(OR(AND(A3>0,B3>0),AND(A3>0,C3>0),AND(B3>0,C3>0)),2,1)))
=IF(AND(A3<=0,B3<=0, C3<=0),0,(a3+b3+c3)/IF(AND(A3>0,B3>0,C3>0),3,IF(OR(AND(A3>0,B3>0),AND(A3>0,C3>0),AND(B3>0,C3>0)),2,1)))