Excel Tutorial – IFERROR

The IFERROR function in Microsoft Excel is a useful tool that allows you to handle errors that may occur in a formula. It is a handy function to use when you want to display a custom message or value if an error occurs, rather than the default error message.

Here is a step-by-step tutorial on how to use the IFERROR function in Microsoft Excel:

1. Open a new or existing spreadsheet in Microsoft Excel.
2. Select the cell where you want to enter the IFERROR function.
3. Type the =IFERROR( formula and press the Enter key.
4. In the IFERROR formula, enter the formula or function that may return an error as the first argument.
5. Enter the value or text string that you want to display if an error occurs as the second argument.
6. Press the Enter key to complete the IFERROR function.

Here is an example of an IFERROR formula:

=IFERROR(A1/B1, "Error occurred")

This formula divides the value in cell A1 by the value in cell B1. If an error occurs, such as a division by zero error, the text string “Error occurred” is displayed in the selected cell.

You can also use the IFERROR function to display a custom value if an error occurs. For example, if you want to display the value 0 if an error occurs, you can use the following IFERROR formula:

=IFERROR(A1/B1, 0)

This formula divides the value in cell A1 by the value in cell B1. If an error occurs, the value 0 is displayed in the selected cell.

In addition to displaying a custom message or value if an error occurs, you can also use the IFERROR function to ignore errors and display the result of the formula or function. To do this, you can use the VALUE function as the second argument in the IFERROR formula.

Here is an example of an IFERROR formula that ignores errors and displays the result of the formula:

=IFERROR(A1/B1, VALUE(A1/B1))

This formula divides the value in cell A1 by the value in cell B1. If an error occurs, the VALUE function is used to convert the result of the formula to a number and the result is displayed in the selected cell.

I hope this tutorial helps you understand how to use the IFERROR function in Microsoft Excel. It is a useful tool that can help you handle errors and display custom messages or values if an error occurs.