IFERROR Function
Office 2010
Returns the evaluated result of a primary expression, if it does not evaluate to an error. Otherwise, returns the evaluated result of an alternate expression.
IFERROR(primary expression, alternate expression)
Parameters
Name | Required/Optional | Data Type | Description |
|---|---|---|---|
primary expression | Required | String | The first expression to evaluate. |
alternate expression | Required | String | The alternate expression to evaluate if the primary expression evaluates to an error. |
Return Value
Varies
Show: