IFERROR Formula

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:

=IFERROR (Value, Value_if_error)
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.

Recommended For You

About the Author: Mehul Vaghela

Howdy Math fan. I'm Mehul Vaghela - B.E.Mechanical. Enthusiastic and holds the passion of reading, writing, and learning. In 10 years of experience on the field, I've faced so much problem with managing data and learned to make that happen. ExcelElixir is one of the parts of passing it on (knowledge).

Leave a Reply

Your email address will not be published. Required fields are marked *