The ISERR function checks if the value is an error other than #N/A (value not available).
It returns a logical value: TRUE if the value is an error (for example, #DIV/0!, #NAME?, and so forth), and FALSE if there are no errors or the value is #N/A.
This feature helps create neater and more visually appealing spreadsheets by hiding technical errors.
Syntax
ISERR(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
A value that is checked whether it corresponds to any error value except the #N/A error |
Any value (number, text, formula, cell reference, and so forth) |
Examples of use
Use for values
=ISERR(1)
the result will be FALSE, since 1 is not an error.
Use for calculations
=ISERR(5/0)
the result will be TRUE, as this is a division by zero error.
Checking the result of the lookup formula
Suppose that the VLOOKUP function searches for the item code in the reference book. If the item is found, its price is returned. If not, the #N/A error.
The ISERR function will help distinguish the #N/A error from other errors (for example, the #REF! error due to an incorrect range):
=ISERR(VLOOKUP("Item_Х", $A$2:$B$100, 2, FALSE))
Result: If “Item_Х” is not found, the VLOOKUP function will return #N/A. The ISERR function will return FALSE.
If cell A1 contains an error, such as #NAME?, then when using the formula =ISERR(A1), the result will be TRUE.
Notes
–The ISERR function detects all types of errors except #N/A.
–To process specific types of errors, use specialized functions: ISERROR, ISNA, IFERROR, and others.
–This function is often used in conjunction with the IF function to create conditional formulas for processing errors.