Replace #Ref! with a blank

[Steved]

Hello from Steved

I have a formula that will put a value in a cell, What I
want also is to leave the cell blank if there is no data
as at the moment it returns #REF! Please how does one go
about this.

Thankyou.

 

[Jim]

=IF(ISERROR(YourReference),"","No Error")

 

[Steved]

Thanks very much Jim for your fast response
Cheers