ISTEXT function
From Apache OpenOffice Wiki
<
Documentation
|
How Tos
Revision as of 13:27, 31 January 2024 by
DiGro
(
Talk
|
contribs
)
(
diff
)
← Older revision
| Latest revision (diff) | Newer revision → (diff)
Jump to:
navigation
,
search
CALC FUNCTIONS
Information Functions
FUNCTIONS
CELL
CURRENT
FORMULA
ISBLANK
ISERR
ISERROR
ISEVEN
ISEVEN ADD
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISODD ADD
ISREF
ISTEXT
N
NA
TYPE
< Previous Page
Next Page >
ISTEXT
Tests if a cell contains text.
Syntax:
ISTEXT(value)
Returns
TRUE
if
value
is or refers to text, and
FALSE
otherwise.
Example:
ISTEXT(“dog”)
returns
TRUE
.
ISTEXT(C2)
where cell C2 contains
cat
returns
TRUE
.
ISTEXT(C3)
where cell C3 contains
=NA()
returns
FALSE
, because
NA()
returns an error value, not text.
ISTEXT(C4)
where C4 is an empty cell returns
FALSE
(an empty cell contain no text).
See Also
ISNONTEXT
ISNUMBER
Information functions
Functions listed alphabetically
Functions listed by category
Categories
:
Documentation/Reference/Calc
Documentation/Reference/Calc/Information functions
Views
Page
Discussion
View source
History
Personal tools
Log in
Navigation
Main Page
Recent changes
Download AOO
Documentation
User Forum
Extensions
Templates
Wiki Help
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information
In other languages
Nederlands