The ISERR function takes one argument,value, which is typically a cell reference.
you’re free to use ERROR.bang out to test for specific kinds of errors.
If no error exists, ERROR.bang out returns #N/A.
See below for a key to the error codes returned by ERROR.jot down.
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.
it’s possible for you to use the ISREF function to check for a reference in a formula.
