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
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
 Excel grade formula  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Excel free download  Download  Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 15, 2010 at 07:44 AM
Feb 15, 2010 at 07:44 AM
What you mean by "A2AF2 and A3AF3" not having value. Is this a range or equation?
Presuming its an equation then you can have
=IF(OR(A2AF2=0, A3AF3=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(A2AF2=0, A3AF3=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 (AAF is a range)