Raz,

Do it this way

=IF(ISERROR(Table!U6),"",IF(Table!U6<"",Table!U6, ""))

Mike

"Raz" wrote:

=IF(OR(TABLE!U6="",ISERROR(TABLE!U6)),"",TABLE!U6)

this is placed in a different sheet.
I want this Eqn to check if the value in Cell U6 of sheet "TABLE" is blank
or and error, and return blank if true. otherwise copy value.