Add cells, div by cells with value (Excel2007
Solved/Closed
Gouws
Posts
45
Registration date
Sunday 7 February 2010
Status
Member
Last seen
15 April 2012
-
16 Feb 2010 à 00:25
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Feb 2010 à 03:33
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Feb 2010 à 03:33
Related:
- Add cells, div by cells with value (Excel2007
- How to delete cells in word - Guide
- Excel arrow keys not moving cells - Guide
- Transparent div - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- Arrow keys scrolling in Excel ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
16 Feb 2010 à 03:33
16 Feb 2010 à 03:33
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)))
