Documentation/How Tos/Calc: ISNONTEXT function

From Apache OpenOffice Wiki
Jump to: navigation, search


ISNONTEXT

Tests if a cell contains no text.

Syntax:

ISNONTEXT(value)

Returns TRUE unless value is or refers to text, in which case it returns FALSE.
ISNONTEXT(value) is equivalent to NOT(ISTEXT(value)).

Example:

ISNONTEXT(123)

returns TRUE.

ISNONTEXT(C2)

where cell C2 contains cat, returns FALSE.

ISNONTEXT(C3)

where cell C3 contains =1/0, returns TRUE, because =1/0 returns an error value, not text.

ISNONTEXT(C4)

where C4 is an empty cell, returns TRUE (an empty cell contains no text).
Template:Documentation/SeeAlso
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_ISNONTEXT_function&oldid=225657"
Views
Personal tools
Navigation
Print/export
Tools