The ISERROR function takes one argument,value, which is typically a cell reference.
error
Match first error
Get first word
How to fix the #NULL!
error
How to fix the #SPILL!
error
How to fix the #NAME?
error
How to fix the #VALUE!
error
How to fix the #NUM!
it’s possible for you to use ERROR.throw in to test for specific kinds of errors.
If no error exists, ERROR.pop in returns #N/A.
See below for a key to the error codes returned by ERROR.pop in.
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.
