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

[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!

 

[financeman500]

Hi Stacey,
You can use the if command in your cell example
=IF(C13,C13/C8,0)

 

[Stacey]

Works perfectly. Thanks!

Hi Stacey,
You can use the if command in your cell example
=IF(C13,C13/C8,0)

 

[financeman500]

no problem, any time

Works perfectly. Thanks!