IFERROR()
Syntax. IFERROR(value,value_if_error)
Definition. This function returns the second argument if the first argument results in an error. This function was introduced in Excel 2007.
Arguments
value (required). Any value or expression
value_if_error (required). The value that is returned if the value argument generates an error. The errors are
#NA!
,#VALUE!
,#REF!
,#DIV/0!
,#NUM!
,#NAME?
, or#NULL!
. If no error exists, the value of the first argument is returned.
Background. Use the IFERROR() function to test values and formulas based on conditions.
If the value or value_if_error argument refers to an empty cell, the function treats this cell as a cell containing an empty string (“”).
If value is an array formula, the IFERROR() function returns ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.