What's wrong in this Eqn?
 

=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.

What's wrong in this Eqn?
 

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.