Dive by Zero Error

[dheinz]

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,

 

[Bondi]

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

 

[Bondi]

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

 

[dheinz]

But how could I incorporate the following into that function?

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

 

[Pete_UK]

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

 

[Dave Peterson]

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]

Yeah, good point Dave. Thanks.

Pete

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.)