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

if formula showing Zero
 

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

if formula showing Zero
 

If this appears twice, blame it on Google. Try this.

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


"Juan" wrote in message
...
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

if formula showing Zero
 

Hello JLG,
thanks for info but formula not working and not sure
this is what I'm looking for. I'm not evaluating U9 to see if it has
zero,blank or X
Just evaluating if U9 X, then put F9 info but if F9 has no data
then it puts 0, I want it to be blank if F9 doesn't have any data.
Hope this is not confusing.

Please advise if you have any idea. Really appreciate your time and help.

Juan

"JLGWhiz" wrote:

If this appears twice, blame it on Google. Try this.

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


"Juan" wrote in message
...
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

if formula showing Zero
 

It's hard to test with "X" but try =IF(Detail!$U$9
"X",IF(Detail!F9=0,""),"")


--
mdmackillop
------------------------------------------------------------------------
mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68819