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

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!

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

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

Works perfectly. Thanks!
"financeman500" <[email protected]> wrote in message
news:[email protected]...
> Hi Stacey,
> You can use the if command in your cell example
> =IF(C13,C13/C8,0)
> "Stacey" wrote:
>
>> 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!
>>
>>
>>

no problem, any time


"Stacey" wrote:

> Works perfectly. Thanks!
> "financeman500" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Stacey,
> > You can use the if command in your cell example
> > =IF(C13,C13/C8,0)
> > "Stacey" wrote:
> >
> >> 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!
> >>
> >>
> >>
>
>
>