# Learn How to Use Microsoft Excel IFERROR Function

Written by | 0 Comments | 723 Views

In this article, you will learn how to use the Microsoft Excel IFERROR function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel IFERROR function return value and syntax with the help of some examples.

## 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.

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."