div/0!

D

Donna

I have a column with long formulas such as below. Is there a way to avoid
the div/o error when dividing by zero?
=((H3+M3+R3+W3+AB3+AG3+AL3+AQ3+AV3+BA3+BF3+BK3
)/(F3+K3+P3+U3+Z3+AE3+AJ3+AO3+AT3+AY3+BD3+BI3))
Thanks
Donna
 
A

Ashish Mathur

Hi,

=if(iserror(H3+M3+R3+W3+AB3+AG3+AL3+AQ3+AV3+BA3+BF3+BK3)/(F3+K3+P3+U3+Z3+AE3+AJ3+AO3+AT3+AY3+BD3+BI3)),"",(H3+M3+R3+W3+AB3+AG3+AL3+AQ3+AV3+BA3+BF3+BK3)/(F3+K3+P3+U3+Z3+AE3+AJ3+AO3+AT3+AY3+BD3+BI3)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
T

T. Valko

No elegant way to reduce this...

=IF(COUNT(F3,K3,P3,U3,Z3,AE3,AJ3,AO3,AT3,AY3,BD3,BI3),(H3+M3+R3+W3+AB3+AG3+AL3+AQ3+AV3+BA3+BF3+BK3)/(F3+K3+P3+U3+Z3+AE3+AJ3+AO3+AT3+AY3+BD3+BI3),"")
 
D

Dana DeLouis

I have a column with long formulas such as below. Is there a way to avoid
the div/o error when dividing by zero?
=((H3+M3+R3+W3+AB3+AG3+AL3+AQ3+AV3+BA3+BF3+BK3
)/(F3+K3+P3+U3+Z3+AE3+AJ3+AO3+AT3+AY3+BD3+BI3))
Thanks
Donna


Hi. The newer function IfError() might be the shortest...

=IFERROR((H3+M3+R3+W3+AB3+AG3+AL3+AQ3+AV3+BA3+BF3+BK3)
/ (F3+K3+P3+U3+Z3+AE3+AJ3+AO3+AT3+AY3+BD3+BI3),"x")

= = = = = = =
HTH :>)
Dana DeLouis
 
D

David Biddulph

=IF(F3+K3+P3+U3+Z3+AE3+AJ3+AO3+AT3+AY3+BD3+BI3=0,"",(H3+M3+R3+W3+AB3+AG3+AL3+AQ3+AV3+BA3+BF3+BK3
)/(F3+K3+P3+U3+Z3+AE3+AJ3+AO3+AT3+AY3+BD3+BI3))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top