The ISREF function takes oneargument,value, to test.
Ifvalueis a valid cell reference,range, ornamed range, ISREF returns TRUE.
Ifvalueis not a reference, ISREF returns FALSE.
ISREF does not evaluate thecontentsof a reference, just the reference itself.
As long as the reference is valid, ISREF returns TRUE:
To evaluate a reference astext(i.e.
For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE.
ISEVEN will return the #VALUE error if a value is not numeric.
When a cell contains a formula ISFORMULA will return TRUE regardless of the formula’s output or error conditions.
ISNONTEXT Function
The Excel ISNONTEXT function returns TRUE when a cell contains any value except text.
This includes numbers, dates, times, errors, and formulas that do not return text.
ISNONTEXT also returns TRUE when a cell is empty.
ISODD will return the #VALUE error if a value is not numeric.
