IFERROR function
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
Syntax
IFERROR(value, value_if_error)Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| value | Yes | The argument that is checked for an error.A2/B2 |
| value_if_error | Yes | The value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!."Error in calculation" |
Try IFERROR
Keep an error-looking text label while replacing a real error
=HSTACK(IFERROR(A2,"Missing"),IFERROR(B2,"Missing"))A2 contains the text label #N/A; B2 calculates NA(), a real error. IFERROR keeps the text label and replaces only the error with Missing. The two values can look alike in a grid but have different types. This two-column display uses HSTACK; older Excel versions can place the two IFERROR calls in separate cells.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
IFERROR · inside HSTACK
=HSTACK(IFERROR(A2,"Missing"),IFERROR(B2,"Missing"))Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.