Want to Convert #REF! to Zeros

[Kenji]

I want to have some of a row, but the value of one of the cell links to
another sheet. The linked sheet sometimes disappears.. so the result
becomes #REF!.

Is there a way to set it so if the value of the cell becomes #REF!, it
equals a 0? Thanks

KENJI4861

 

[Dave R.]

Try

=IF(ISERROR(your formula),0,your formula)

Hiding it like this is generally not considered the best option since it now
hides errors for any number of reasons, but it will work.