Hi,

=if(iserror(H3+M3+R3+W3+AB3+AG3+AL3+AQ3+AV3+BA3+BF 3+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

"Donna" wrote in message
...
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