ISNONTEXT (Value) ISNONTEXT (Value)
Value
The value to check.
Returns
Logical Logical
Whether the given value is not a text value.
Returns whether the given value is not a text value. Blank values are not considered text values. As such, ISNONTEXT ("test") ISNONTEXT ("test") returns FALSE, ISNONTEXT (47) ISNONTEXT (47) returns TRUE and ISNONTEXT (TextValue) ISNONTEXT (TextValue) returns TRUE if TextValue is blank and FALSE otherwise.
Examples
ISNONTEXT ("test")
ISNONTEXT ("test")
Returns FALSE.
ISNONTEXT (47)
ISNONTEXT (47)
Returns TRUE.
ISNONTEXT ("47")
ISNONTEXT ("47")
Returns FALSE.
ISNONTEXT (TextValue)
ISNONTEXT (TextValue)
Returns TRUE if TextValue is blank and FALSE otherwise.