Excel Formula to show Zero
Solved/Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Feb 15, 2010 at 07:28 AM
Gouws - Feb 15, 2010 at 11:28 PM
Gouws - Feb 15, 2010 at 11:28 PM
Related:
- Excel Formula to show Zero
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel formula - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to ignore false in excel formula ✓ - Office Software Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 15, 2010 at 07:44 AM
Feb 15, 2010 at 07:44 AM
What you mean by "A2-AF2 and A3-AF3" not having value. Is this a range or equation?
Presuming its an equation then you can have
=IF(OR(A2-AF2=0, A3-AF3=0),0, A2/(A2+A3))
If it was a range and what you meant want you dont want division to occur if a2 and a3 are 0, in that case
=if(AND(A2=0, a3=0),0, A2/(A2+A3))
but perhaps you would be better off if you use this
=if(A2+ a3=0,0, A2/(A2+A3))
Hope it helps
Presuming its an equation then you can have
=IF(OR(A2-AF2=0, A3-AF3=0),0, A2/(A2+A3))
If it was a range and what you meant want you dont want division to occur if a2 and a3 are 0, in that case
=if(AND(A2=0, a3=0),0, A2/(A2+A3))
but perhaps you would be better off if you use this
=if(A2+ a3=0,0, A2/(A2+A3))
Hope it helps
Feb 15, 2010 at 11:28 PM
Yes the formula helped (A-AF is a range)