IFERROR
Shows a replacement when a formula returns an error.
How it’s written
IFERROR(formula, if_error)Example
| A | B | |
|---|---|---|
| 1 | Sales | Calls |
| 2 | 40 | 0 |
=IFERROR(A2/B2,0)Result: 0
Dividing by zero is an error, so it shows 0.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
It hides every kind of error, including real mistakes, so use it deliberately.
Practice it properly
Handling errors and gaps gives you real tasks, with your formulas tested on data you haven’t seen.