Information - ISERR Function

Description

The ISERR function returns the logical value TRUE if the value refers to an Excel Error, except the #N/A error. Otherwise returns FALSE.

Syntax

ISERR (value)

Arguments

Notes

• This function is useful in formulas for testing the outcome of a calculation. When combined with the IF function, this function provides a method for locating errors in formulas.

• Both ISERR and ISERROR Functions test a value and return True or False depending on whether the value is an error or not. The only difference is −

  • The ISERROR function returns True if value is any error

  • The ISERR function returns True if value is any error except the #N/A error

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example