What do I use to test this. Not isblank

[dbuchanan]

A cell contains a very complicated formula that is written to return a
number, text, or an empty string. How to I test for an empty string?

None of the logical tests seem to be any good.
IsBlank, IsText, IsNumber, IsNonText... none of these will work.

Using AND or OR with a combination of these does no good either.

There seems to be no logical way to test this. Any suggestions?

- Doug

 

[Ragdyer]

If you're looking to test a cell that looks empty to see if it contains a
formula that has returned a < "" >, you could try this:

=COUNTIF(A1,"*")

Will return a "1" if A1 contains a < "" >,
And will return "0" if A1 is truly empty.

This will count text, as well as "nulls".

 

[Ragdyer]

BTW,

=ISTEXT(A1)

Should return TRUE.

Did you say that you tied that and it failed?

 

[Peo Sjoblom]

=LEN(A1)>0

 

[Dave Peterson]

With the formula in A1:

=if(a1="","it looks empty","It looks filled in")