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,

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

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

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

Try this:

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

Hope this helps.

Pete

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

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,O 87)=0,0,AVERAGE(E6,J6,O6,E33,J33,O33,E60,J60,O60,E 87,J87,O87))

Hope this helps.

Pete

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

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,O 87)=0,0,AVERAGE(E6,J6,O6,E33,J33,O33,E60,J60,O60,E 87,J87,O87))

Hope this helps.

Pete

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