OpenOffice3.org Calc 3. Information Functions

ISNONTEXT(value) Function

Returns a logical value. If the argument “value” is the reference to a cell containing a text, the function returns FALSE. If the cell not contain text, the function returns TRUE. The data other than text are logical values, dates, times and numbers. The argument “value” contains a constant, expression or reference to cell containing the value to determinate tha is not text. For example:

=ISNONTEXT(33) Returns TRUE. Indicates that the argument has no text.
=ISNONTEXT("rojo") Returns FALSE. The argument has text.

Back to the list of information functions