This includes numbers, dates, times, errors, and formulas that return non-text results.
ISNONTEXT also returns TRUE when a cell is empty.
Typically,valueis entered as a cell reference like A1.
Whenvalueis not text, the ISNONTEXT function will return TRUE.
Ifvalueis text, ISNONTEXT will return FALSE.
When values are concatenated, the result is text.
you’re free to also use theCOUNTIF functionto count cells that do not contain text, asexplained here.
For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE.
ISODD will return the #VALUE error if a value is not numeric.
ISREF Function
The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not.
you’re free to use the ISREF function to check for a reference in a formula.
ISEVEN will return the #VALUE error if a value is not numeric.
