Want to replace cells that read "#DIV/0" with another value

  • Thread starter Thread starter Stacey
  • Start date Start date
S

Stacey

I have a chart where certain field is computed based on the content of other
fields (not unsual). However, it is actually an average field and the
fields it uses to compute the average are autopopulated from data in another
worksheet. Sometimes all the valus are "0" so when it tried to take the
average it gives me a "#DIV/0" error. Is there a way I can get it to
display "0" or "n/a" instead of "#DIV/0" in these specific cells when this
error arises?

Thanks!
 
Back
Top