Whenvalueis TRUE or FALSE, the ISLOGICAL function will return TRUE.
Ifvalueis any other value, ISLOGICAL will return FALSE.
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.
ISREF Function
The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not.
you’re able to use the ISREF function to check for a reference in a formula.
