Return blank if Cell is blank or contains formula)

**oo0tommyk0oo** · 12-28-2010, 06:12 PM

Im trying to return a "" if L2 is blank. However L2 contains a formula which returns blank if a test is not met. So my formula bellow does not work because the cell is blank only to the eye, it actually contains a formula.

=IF(L2="","",IF(L2<800,"Y","N"))

I tried

=IF(ISTEXT (L3),"",IF(L3<800,"Y","N"))

but did not work

Any help much appreciated.

Thanks

**shg** · 12-28-2010, 06:21 PM

However L2 contains a formula which returns blank if a test is not met.

If the formula in L2 really returns a null string, the second formula should work fine. What's the formula in L2?

**Richard Buttrey** · 12-28-2010, 06:23 PM

Hi,

Stating the obvious I'm assuming you are entering this formula somewhere other than L2.

You are misunderstanding what the IF is testing. It's not testing whether L2 has a formula but what the results of that formula are. If the formula in L2 really does return null, i.e. a complete blank then your formula will return a null. If it's not then L2 is not returning a blank.

Rgds

**oo0tommyk0oo** · 12-28-2010, 06:23 PM

=IF(COUNTIF('Assembly Location'!$A$2:$A$500,K3),VLOOKUP(K3,'Assembly Location'!$A$2:$B$500,2,FALSE)," ")

This is in L2

Thanks for any help

**shg** · 12-28-2010, 06:25 PM

=IF(COUNTIF('Assembly Location'!$A$2:$A$500,K3),VLOOKUP(K3,'Assembly Location'!$A$2:$B$500,2,FALSE), " ")

That's returning a space, not a blank.

**oo0tommyk0oo** · 12-28-2010, 06:28 PM

LOL

Thank you very much

Im such a rookie!

**camdameron** · 03-22-2011, 05:17 PM

I have this same issue.
I am trying to get cells to populate for certain criteria. And i have a formula with ISBLANKs referring to another cell with ISBLANKs and I dont think it is reading it as truly blank.

I have attached an example.

The column K (where "Action" is populated all the way down) should be blank until something is populated in cells A, B, C or J.

Any ideas?

I appreciate your help!