Detecting text and returning a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am struggling with getting a return value of 1 or 0, or true or false from
a cell that conatins text.

I have text in one cell, what i need is to look at that cell, detect either
text or nothing and return the value of true/false, or 0 or 1.

Can anyone help???

Regards
 
=LEN(T(A1))>0
returns true if text
false if nothing

Regards,
Stefi


„Confuddled User!!!!!!!!!!!!!†ezt írta:
 
Hi,

There are lots of ways to do this, here's one:

=IF(A1<>"",TRUE,FALSE)

Where A1 is the cell that contains whatever (text in your case). I put this
formula in cell B1. You could also replace TRUE,FALSE with 0,1 or "There's
something","There's Nothing", etc...

hth

BigPig
 
Many thanks Stefi, worked a treat

Stefi said:
=LEN(T(A1))>0
returns true if text
false if nothing

Regards,
Stefi


„Confuddled User!!!!!!!!!!!!!†ezt írta:
Click to expand...
 
You are welcome! Thanks for the feedback!
Stefi


„Confuddled User!!!!!!!!!!!!!†ezt írta:
 
Why not just

=ISTEXT(A1)
?
--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top