|
|
What do I use to test this. Not isblank |
|
Author |
Message |
Vito
|
Posted: Sun May 15 22:17:48 CDT 2005 |
Top |
Excel >> What do I use to test this. Not isblank
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
Excel94
|
|
|
|
|
Ragdyer
|
Posted: Sun May 15 22:17:48 CDT 2005 |
Top |
Excel >> What do I use to test this. Not isblank
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".
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
> 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
|
Posted: Sun May 15 22:22:25 CDT 2005 |
Top |
Excel >> What do I use to test this. Not isblank
BTW,
=ISTEXT(A1)
Should return TRUE.
Did you say that you tied that and it failed?
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
> 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
>
|
|
|
|
|
Peo
|
Posted: Sun May 15 23:37:34 CDT 2005 |
Top |
Excel >> What do I use to test this. Not isblank
=LEN(A1)>0
--
Regards,
Peo Sjoblom
>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
>
|
|
|
|
|
Dave
|
Posted: Mon May 16 06:48:48 CDT 2005 |
Top |
Excel >> What do I use to test this. Not isblank
With the formula in A1:
=if(a1="","it looks empty","It looks filled in")
>
> 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
--
Dave Peterson
|
|
|
|
|
|
|