Rational
Substitute the error result and replace with an alternate value
Description
The Excel IFERROR function evaluates a given criterion (value) in case the return value is an error then it substitutes with a different text string. For example: =IFERROR(2/0,”Error”) will return “Error” as division 2/0 return #DIV/0! error.
Syntax
= IFERROR(value, value_if_error)
Parameters
value – The criteria to evaluate.
value_if_error [optional] – A text string if criteria return an error.
Return Value
The text string in case of error otherwise result of criteria (value)
Key Notes
- If the condition (value) after evaluating returns an error, only then the second argument trigger and return the text string given in the second argument [value_if_error].
- IFERROR function is useful to avoid any error value to display which may occur while evaluating other calculation or formula.
- If Value_if_error is an empty cell, IFERROR treats it as an empty string value (“”).
Keep Reading Similar Functions:
IFS
Rational Check multiple criteria and return the first match. Description The Excel IFS function evaluate multiple criteria at once and return the first TRUE criteria
IFNA
The IFNA function evaluate given criterion (value) in case the return value is a #N/A error then it substitutes with a different text string (value_if_na).
IF
The IF function is a handy logical operator that return value based on a valid test of criteria, if it matches (TRUE) and another value if it does not.