IFERROR Function
Handle errors gracefully using IFERROR.
Task:
You are performing division calculations and want to display a user-friendly message instead of an error when dividing by zero. Calculate the division in column C but show 'N/A' for division by zero to improve the user experience.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of IFERROR
0/3The same formula in the other shapes it takes at work.
- IFERROR Function
Handle errors gracefully using IFERROR.
CoreIntermediate - IFERROR returning 0 so totals still add
A text fallback turns a number column into a mixed one; a zero keeps it numeric.
Intermediate - IFERROR around a conversion
Turn imported text into numbers, and anything unreadable into a known default.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Numerator | Denominator | Result |
| 2 | 100 | 5 | |
| 3 | 75 | 0 | |
| 4 | 200 | 8 | |
| 5 | 150 | 0 | |
| 6 | 90 | 3 |
Functions used here
What this exercise teachesMay contain the answer
IFERROR function helps handle errors gracefully in formulas, preventing error messages like #DIV/0! from appearing and instead showing a custom value.