IFERROR
LogicalIFERROR helps you perform conditional and boolean logic helpers for branching worksheet behavior.
Overview
Start with "=" then enter IFERROR(value, value_if_error). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=IFERROR(value, value_if_error)
2 required
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| value | Required | Single | Input argument used by this function. |
| value_if_error | Required | Single | Input argument used by this function. |
Example Inputs & Outputs
Formula
=IFERROR(<value>, <value_if_error>)
Example Output
Boolean or conditional result
Replace placeholders with your worksheet values or ranges to compute a result.