Is it possible to make " #REF!" show up as blank?

[BigD]

I have a dashboard linked to multiple tabs. In my instructions, I have the user delete any uncessary tabs to clean the dashboard up. However, when they do this, I have a bunch of "#REF!" in the cells.

I tried using a if statement: IF(Cell="#REF!","",'Tab1!'C4) but was unsucuessful.

Are they other other statements that may work?

 

[Luke M]

It will mask all errors, so can be bad if overused, but could do:
=IFERROR('Tab1!'C4,"")

 

[PeterB]

Hi Big D,

If you want something a bit more sophisticated (ie it will only trap / ignore #Ref! errors and will flag other errors) then you could try:

=IFERROR(IF(ERROR.TYPE(A1)=4,"",A1),"Error type: "&ERROR.TYPE(A1))

Regards,

Peter

 

[BigD]

Thank you both. It works like a charm!