Excel Function : IFERROR

Download now!

Excel Function : IFERROR

Category

Logical

Description

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

Microsoft Excel Reference Page

https://support.office.com/en-us/article/IFERROR-function-c526fd07-caeb-47b8-8bb6-63f3e417f611

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)