Hey excel users, how do we handle the error that is produced by another formulas or functions in excel?

**IFERROR**: Excel IFERROR function returns a custom result when a formula generates an error. Also, it generates a standard result if no error is detected. Thus, IFERROR can trap and manage error.

**Purpose**: Trap and handle the error.

## IFERROR Formula Syntax:

**Arguments**

Value: The reference or formula to check for an error

Value_if_error: The value to return if an error is found.

IFERROR can handle any type of error.

IFERROR converts all error to specified value.

Example:-

In column C we devide Numberator with Denominator, in highlighted cell (C3,C4 & C7) results an error #DIV/0! & #VALUE. With use of IFERROR in column D all error coverts into specified value “Not use”.

**Explanation**:

IFERROR function is just similar to IF function, but the only difference is it returns 0 instead of an error.

IFNA & IFERROR are used to converts result as 0.

**What is the difference between IFNA & IFERROR function?**

IFNA can only handle #N/A error, where IFERROR can handle any types of ERROR.

**IFERROR in with VLOOKUP**

Since Jim is not in the lookup table, result in cell C11 is the Specified value “Not use” in place of #N/A error.

**IFERROR with HLOOKUP**

Since Michel is not in the lookup table, result in cell C7 is the Specified value “Not use” in place of #N/A error.

## Leave a Reply