Learn How to Use Microsoft Excel IFERROR Function

What is Microsoft Excel IFERROR Function?

The primary purpose of the IFERROR function is to trap and handle errors. The IFERROR function in Microsoft Excel returns a custom result when you enter the wrong formula or formula generates an error and an expected result when no error is found. The IFERROR function is the best way to find and manage errors without using the more complicated nested IF statements.

Return Value of IFERROR Function

It is the value you specify or the error conditions.

Syntax of IFERROR Function

=IFERROR(Value, Value-If-Error)

How to Use Microsoft Excel IFERROR Function?

The IFERROR function is used to find the errors in the formulas you have created and return another result or formula when the error is located. The IFERROR function can be used to find and manage errors produced by using other formulas or functions. You can check the following errors with the IFERROR:

• #N/A,
• #VALUE!
• #REF!
• #DIV/0!
• #NUM!
• #NAME?
• #NULL!

Examples of Using IFERROR Function

• IFERROR (A1/B1, "Please enter a value in B1")

Let's say A1 is 10, B1 is blank, and C1 has the formula =A1/B1, then the above formula will give #DIV/0! error.

• IFERROR(VLOOKUP(value,data,column,0), "Not found")

In the above example, the IFERROR function that results. In the case of value, the return is #N/A error, that is because lookup value is not found, and IFERROR returns "Not Found."

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel