=If(text)=1,0) - approximate format required that works

[sonar]

Hi, I am looking for a format that will give me an answer of 1 whe
text is typed in and a 0 when cell is left blank

Please help

 

[Francis Lun]

Hi, you may try this =IF((ISBLANK(A1)=FALSE),0,1

Whatever you type in a cell the formula will return 1. Otherwise, it returns 0

 

[JE McGimpsey]

How about

=--ISTEXT(A1)

or

=--(A1<>"")

or, since space characters count as text, if you want to ignore just
space characters, perhaps:

=--(LEN(TRIM(A1))>0)

 

[Rob]

Hi,

Can someone please explain the -- (two minus signs), I've seen this used
elsewhere but can't figure it out. Excel help doesn't seem to cover this.

Thanks Rob

 

[Dave Peterson]

Try this in a test worksheet

A1: HiThere
B1: =istext(a1)
c1: =-istext(a1)
d1: =--istext(a1)

Then put a number in A1 and watch the differences.

You'll see True or false in B1. The first minus sign converts the true false to
a number (-1 or 0). The second minus sign changes the sign. (You wanted
+1/0???).

 

[Rob]

Dave,

Thanks for the explanation.

Rob

Try this in a test worksheet

A1: HiThere
B1: =istext(a1)
c1: =-istext(a1)
d1: =--istext(a1)

Then put a number in A1 and watch the differences.

You'll see True or false in B1. The first minus sign converts the true false to
a number (-1 or 0). The second minus sign changes the sign. (You wanted
+1/0???).