Want to use IF formula to show blank if empty, but my reference cell is not "empty" due to a formula

[drfernandombbs]

Hi everyone,

I'm puzzled with this one. My column A has an IF formula pointing to another sheet. The formula I have inn column A is:

=IF(Sheet2!A2=0,"",Sheet2!A2)

This returns the value if it exists in that sheet, and a blank if it does not exist.

Now, on my original sheet, in column B I want to use the following formula when referring to column A:

=IF(A2=0,"","Ground")

However, even the blank cells are showing "Ground". This is apparently due to the reference cell not technically being 0 as it has a formula. How can I get around this? I tried ISTEXT and ISBLANK, but both give me the same issues.

Thanks in advance!

 

[bschwartz]

Try:

=IF(A2="","","Ground")

 

[Misca]

I'd solve this with something like
=IF(A2="","","Ground")
or
=IF(VALUE(A2)=0,"","Ground")
or
=if(LEN(A2)<1,"","Ground").

 

[drfernandombbs]

Try:

=IF(A2="","","Ground")

Yes! Duh...it's not zero, it's blank. How could I overlook that.

Worked flawlessly. Thank you!

 

[bschwartz]

You're very welcome.