IF Statement recognizing any text

[tycasey17]

I assumed that the following statement would recognize any text (either numbers or letters) and have the return of "1" or "0" for true or false respectively.

Statement: =IF(A1="*",1,0) and I have tired =IF(A1=*,1,0) Niether have worked

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Text[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][blank][/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

I assumed that the following statement would recognize any text (either numbers or letters) and have the return of "1" or "0" for true or false respectively.

Statement: =IF(A1="*",1,0) and I have tired =IF(A1=*,1,0) Niether have worked

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Text[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][blank][/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

The IF function does not support wildcards; however, you can do what you want this way...

=IF(A1="",0,1)

 

[Trebor76]

Hi,

Not sure about using the wildcard, but this should do the job:

=IF(LEN(A1)>0,1,0)

HTH

Robert

 

[Danerida]

You could test for blank instead:
=IF(A1<>"",1,0)
or
=IF(ISBLANK(A1),0,1)