ISNONTEXT
Returns TRUE if the value is not text.
InformationInformation & Auditing
What it does
Returns TRUE if value is anything other than text (includes numbers, blanks, errors).
Syntax
ISNONTEXT(value)
Arguments
value(value) — Value to check.
Examples
Check Non-Text
Check number 1.
FORMULA
=ISNONTEXT(1)
RESULT
true
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | 1 |