It returns a value you specify if a formula leads to an error. If there is no error in the formula IFERROR returns its result. It is part of the logical functions of Excel.
The syntax of the function is the following:
IFERROR(value, value_if_error)
value : The value or formula you are checking for an error.
value_if_error : The value to return if the value results to an error.
The error types that are evaluated are: N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the IFERROR function:
Use the IFERROR formula to make sure that the cells C10:K10 show the number 0, when the sum of the sales of all the companies is 0 in one month, as for example in August.