Try this

=IF(And(Detail!$U$9<"",Detail!$U$9 "X",Detail!F9,"")

"Juan" wrote:

Hello,
Have simple formula
=IF(Detail!$U$9 "X",Detail!F9,"") works fine, but
some cells puts a ZERO if cell has no data. How can
I modify formula to just leave blank if no data in the cell? Ex.
Customer Country Project Project
TEST US 0 would like to have leave blank
Would appreciate any help.
Thanks,
Juan