Excel Function : IFERROR

Download now!

Excel Function : IFERROR




Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula

Microsoft Excel Reference Page


Syntax and Description of the IFERROR Excel Function

The syntax for the IFERROR function in Microsoft Excel is as follows: =IFERROR(value, value_if_error) where "value" is the value to be checked for an error, and "value_if_error" is the value to return if an error is found.

About IFERROR Excel Function

The IFERROR function returns a specified value if an error occurs, otherwise it returns the result of a specified formula. =IFERROR(value, value_if_error)