The ISNONTEXT function checks if a value is not of type text and returns the logical value True in positive case (if it is not of type text) and the logical value False in negative case (if it is of type text).
Syntax
ISNONTEXT(
value
)
Parameters
- value: Value to evaluate.
Returned value
The ISNONTEXT function returns a Boolean.
Additional Information
Both a blank space and an empty text string ("") are considered texts. A Blank value is not.
The result of this function matches the negation of the result of the ISTEXT function.
Examples
This first example checks if "a" is not text:
The following checks if a Boolean is not of type text:
This example checks if a blank space is not of type text:
We check below if an empty text string is not of type text:
Now it is checked if a Blank value is not of type text:
Category
Information
