OpenOffice3.org Calc 3. Information Functions
ISTEXT(value) Function
Returns a logical value. If the argument
“value” contains a text, the function returns TRUE. Conversely, if the argument
is not a text, the function returns FALSE. The argument “value” contains the
reference to a cell, a constant or an expression. The function returns FALSE if
the argument contains a numerical data, a date, time or a logical value. For
example:
=ISTEXT(33) Returns FALSE. The argument is a number, not text.
=ISTEXT("hola") Returns TRUE. The argument is of type text.
=ISTEXT(A1) If the contents of cell A1 is text, the function returns TRUE,
otherwise returns FALSE.