View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Juan Juan is offline
external usenet poster
 
Posts: 70
Default if formula showing Zero

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