Logical Functions
Intermediate
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.
Learning Objectives:
- Learn error handling with IFERROR
- Understand error prevention
- Practice robust formula design
Hints
Solve without hints for +5 XP
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 |
What this exercise teaches (contains the answer)
IFERROR function helps handle errors gracefully in formulas, preventing error messages like #DIV/0! from appearing and instead showing a custom value.