iserror function

  • Thread starter Thread starter Carl Johnson
  • Start date Start date
C

Carl Johnson

I created as average function that left a #DIV/0 error message, so I created
an iserror formula that removed the error message, however when I clear the
worksheet or move to another worksheet and return I keep having to redefine
the ranges that are located within the formula.
=If(iserror(Average(weekly)),"",Average(weekly))
Would someone please let me know what I need to add or do to correct this.
Thank you in advance.
 
I created as average function that left a #DIV/0 error message, so I created
an iserror formula that removed the error message, however when I clear the
worksheet or move to another worksheet and return I keep having to redefine
the ranges that are located within the formula.
=If(iserror(Average(weekly)),"",Average(weekly))
Would someone please let me know what I need to add or do to correct this.
Click to expand...

How *exactly* is weekly defined?

Also, if there are any numbers in the range named weekly, then AVERAGE(weekly)
will be a number rather than a #DIV/0! error. That means you could use

=IF(COUNT(weekly),AVERAGE(weekly),"")

instead.
 
Back
Top