Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > div/0!
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 76
Default div/0!
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
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 1,766
Default div/0!
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

Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 15,768
Default div/0!
No elegant way to reduce this...

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

--
Biff
Microsoft Excel MVP


"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


Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 8,651
Default div/0!
Of course the COUNT could be non-zero, but the SUM zero, in which case you'd
still get a divide by zero error.
--
David Biddulph


T. Valko wrote:
No elegant way to reduce this...

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


"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


Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 15,768
Default div/0!
Yeah, I realized that right after I hit send!

--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Of course the COUNT could be non-zero, but the SUM zero, in which case
you'd still get a divide by zero error.
--
David Biddulph


T. Valko wrote:
No elegant way to reduce this...

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


"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




Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 8,651
Default div/0!
Yes, that send button is always very good at refreshing the memory, isn't
it? :-)
--
David Biddulph

T. Valko wrote:
Yeah, I realized that right after I hit send!


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Of course the COUNT could be non-zero, but the SUM zero, in which
case you'd still get a divide by zero error.
--
David Biddulph


T. Valko wrote:
No elegant way to reduce this...

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


"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


Reply With QuoteReply With Quote
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 690
Default div/0!
On 1/15/2010 7:47 PM, Donna wrote:
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
Reply With QuoteReply With Quote
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 8,651
Default div/0!
=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))
--
David Biddulph


Donna wrote:
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


Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement