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:
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.
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”.
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.