IFERROR Function in Excel

What is the use of IFERROR function?

IFERROR Function in Excel check a value and it returns the value if there is no error or else it returns the specified value_if error

What is the syntax of IFERROR function?

IFERROR( value, value_if_error )

value : value to be checked
value_if_error : value to be returned if the given value is error

IFERROR Function in Excel – Examples

Example 1: Returns the actual value 2000 as it is not found any error
Example 2: Returns “error” asthe given value is an error
Example 3: Returns the actual value 4000 as it is not found any error
Example 4: Returns “error” asthe given value is an error

Reference:

Please refer the below article for more Logical Excel functions.
Logical Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home