Information - ISERROR Function



Description

The ISERROR function returns the logical value TRUE if the value refers to an Excel Error. Otherwise returns FALSE.

Syntax

ISERROR (value)

Arguments

Argument Description Required/Optional
value An error Required

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

ISERROR Function
advanced_excel_information_functions.htm
Advertisements