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