The **IFERROR** function evaluates a formula and returns a specified value if the formula generates an error. Otherwise, the function returns the result of the formula. In this guide, we’re going to show you how to use the **IFERROR** function and also go over some tips and error handling methods.

# Supported Excel versions

- (Windows) Excel 2007 and above
- (Mac) Excel for Mac 2011 and above
- Web and mobile versions

# Syntax

IFERROR(value, value_if_error)

# Arguments

value |
The formula or the reference which is evaluated for an error. |

value_if_error |
The return value that if the formula evaluates to an error. |

Examples

In this example we've used named ranges to make the formulas easier to read. This is not required.

## Example 1

=IFERROR(VLOOKUP(Search_Value,Table,2,0),"Not found")

*"Not found"*. Since the search value,

*"Mew"*, doesn’t exist in the table, the

**VLOOKUP**formula returns an

*#N/A*error.

## Example 2

=IFERROR(VLOOKUP(Search_Value_2,Table,2,0),"Not found")

*340*. Since the search value,

*"Staryu"*, exists in the table, the

**VLOOKUP**formula returns the value form the 2

^{nd}column of the range.

## Example 3

=IFERROR(SUM(Total)/Divisor,IF(Divisor=0,"Divisor should not be 0","Please check the values in Total column"))

^{nd}argument as

*"Divisor should not be 0",*because dividing a value to

*0*throws

*#DIV/0!*error. When the first argument of the

**IFERROR**function results in an error, the formula from the second argument is used as the return value.

# Tips

- The
**IFERROR**checks for the following errors:*#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?,*or*#NULL!*. - If a reference cell is empty, the
**IFFERROR**function treats it as an empty string (*""*). - You can also use the
**IFNA**function to handle*#N/A*errors. - You can use the
**ISERROR**and the**ISERR**functions to detect errors without replacing them.