PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup Dive by Zero Error

Reply

Dive by Zero Error
 
Thread Tools Rate Thread
Old 13-06-2006, 04:01 PM   #1
dheinz@kitsapbank.com
Guest
 
Posts: n/a
Default Dive by Zero Error


I have a spreadsheet that divides 12 cells by another. The problem is
the cells do not always contain data. Is there any way to remove the
#DIV/0! message that comes up? It does not look too professional.
Thanks,
  Reply With Quote
Old 13-06-2006, 04:23 PM   #2
Bondi
Guest
 
Posts: n/a
Default Re: Dive by Zero Error

dheinz@kitsapbank.com wrote:
> I have a spreadsheet that divides 12 cells by another. The problem is
> the cells do not always contain data. Is there any way to remove the
> #DIV/0! message that comes up? It does not look too professional.
> Thanks,

Hi,

You can use something like:

=IF(ISERROR(Result),"",Result)

Regards,
Bondi
  Reply With Quote
Old 13-06-2006, 04:23 PM   #3
Bondi
Guest
 
Posts: n/a
Default Re: Dive by Zero Error

dheinz@kitsapbank.com wrote:
> I have a spreadsheet that divides 12 cells by another. The problem is
> the cells do not always contain data. Is there any way to remove the
> #DIV/0! message that comes up? It does not look too professional.
> Thanks,

Hi,

You can use something like:

=IF(ISERROR(Result),"",Result)

Regards,
Bondi
  Reply With Quote
Old 13-06-2006, 04:42 PM   #4
dheinz@kitsapbank.com
Guest
 
Posts: n/a
Default Re: Dive by Zero Error
But how could I incorporate the following into that function?

=AVERAGE(E6,J6,O6,E33,J33,O33,E60,J60,O60,E87,J87,O87)


Bondi wrote:
> dheinz@kitsapbank.com wrote:
> > I have a spreadsheet that divides 12 cells by another. The problem is
> > the cells do not always contain data. Is there any way to remove the
> > #DIV/0! message that comes up? It does not look too professional.
> > Thanks,
>
> Hi,
>
> You can use something like:
>
> =IF(ISERROR(Result),"",Result)
>
> Regards,
> Bondi
  Reply With Quote
Old 13-06-2006, 05:24 PM   #5
Pete_UK
Guest
 
Posts: n/a
Default Re: Dive by Zero Error
Try this:

=IF(SUM(E6,J6,O6,E33,J33,O33,E60,J60,O60,E87,J87,O87)=0,0,AVERAGE(E6,J6,O6,E33,J33,O33,E60,J60,O60,E87,J87,O87))

Hope this helps.

Pete

dheinz@kitsapbank.com wrote:
> But how could I incorporate the following into that function?
>
> =AVERAGE(E6,J6,O6,E33,J33,O33,E60,J60,O60,E87,J87,O87)
>
>
> Bondi wrote:
> > dheinz@kitsapbank.com wrote:
> > > I have a spreadsheet that divides 12 cells by another. The problem is
> > > the cells do not always contain data. Is there any way to remove the
> > > #DIV/0! message that comes up? It does not look too professional.
> > > Thanks,
> >
> > Hi,
> >
> > You can use something like:
> >
> > =IF(ISERROR(Result),"",Result)
> >
> > Regards,
> > Bondi
  Reply With Quote
Old 13-06-2006, 06:33 PM   #6
Dave Peterson
Guest
 
Posts: n/a
Default Re: Dive by Zero Error
I would think that you'd want to check the count of numbers--not the sum of
them.

=if(count(...)=0,0,average(...))

(maybe be important if there are negative and positive values in those cells.)



Pete_UK wrote:
>
> Try this:
>
> =IF(SUM(E6,J6,O6,E33,J33,O33,E60,J60,O60,E87,J87,O87)=0,0,AVERAGE(E6,J6,O6,E33,J33,O33,E60,J60,O60,E87,J87,O87))
>
> Hope this helps.
>
> Pete
>
> dheinz@kitsapbank.com wrote:
> > But how could I incorporate the following into that function?
> >
> > =AVERAGE(E6,J6,O6,E33,J33,O33,E60,J60,O60,E87,J87,O87)
> >
> >
> > Bondi wrote:
> > > dheinz@kitsapbank.com wrote:
> > > > I have a spreadsheet that divides 12 cells by another. The problem is
> > > > the cells do not always contain data. Is there any way to remove the
> > > > #DIV/0! message that comes up? It does not look too professional.
> > > > Thanks,
> > >
> > > Hi,
> > >
> > > You can use something like:
> > >
> > > =IF(ISERROR(Result),"",Result)
> > >
> > > Regards,
> > > Bondi

--

Dave Peterson
  Reply With Quote
Old 14-06-2006, 01:18 AM   #7
Pete_UK
Guest
 
Posts: n/a
Default Re: Dive by Zero Error
Yeah, good point Dave. Thanks.

Pete

Dave Peterson wrote:
> I would think that you'd want to check the count of numbers--not the sum of
> them.
>
> =if(count(...)=0,0,average(...))
>
> (maybe be important if there are negative and positive values in those cells.)
>
>
>
> Pete_UK wrote:
> >
> > Try this:
> >
> > =IF(SUM(E6,J6,O6,E33,J33,O33,E60,J60,O60,E87,J87,O87)=0,0,AVERAGE(E6,J6,O6,E33,J33,O33,E60,J60,O60,E87,J87,O87))
> >
> > Hope this helps.
> >
> > Pete
> >
> > dheinz@kitsapbank.com wrote:
> > > But how could I incorporate the following into that function?
> > >
> > > =AVERAGE(E6,J6,O6,E33,J33,O33,E60,J60,O60,E87,J87,O87)
> > >
> > >
> > > Bondi wrote:
> > > > dheinz@kitsapbank.com wrote:
> > > > > I have a spreadsheet that divides 12 cells by another. The problem is
> > > > > the cells do not always contain data. Is there any way to remove the
> > > > > #DIV/0! message that comes up? It does not look too professional.
> > > > > Thanks,
> > > >
> > > > Hi,
> > > >
> > > > You can use something like:
> > > >
> > > > =IF(ISERROR(Result),"",Result)
> > > >
> > > > Regards,
> > > > Bondi
>
> --
>
> Dave Peterson
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off