Replace #Ref! with a blank

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
Back
Top