Dive by Zero Error

  • Thread starter Thread starter dheinz
  • Start date Start date
D

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,
 
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,
Click to expand...

Hi,

You can use something like:

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

Regards,
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,
Click to expand...

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)
 
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
 
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.)
 
Yeah, good point Dave. Thanks.

Pete

Dave said:
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.)
Click to expand...
 
Back
Top