What you will fix
You will reproduce #DIV/0! in D2 by dividing 10 by 0, identify C2 as the zero denominator, then use an intentional IFERROR fallback in E2 and verify the result is 0.
Learning objectives
Open the practice workbook
Practice in your own copy
Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.
Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.
Sample data
| Case | Input A | Input B | Broken result | Fixed result |
|---|---|---|---|---|
| Example | 10 | 0 |
Keep B2=10 and C2=0 unchanged while reproducing and fixing the error.
Reproduce, diagnose, and fix the error
Step 1: Select D2, enter =B2/C2, and press Enter. Because B2 is 10 and C2 is 0, D2 must display #DIV/0!.
=B2/C2Step 2: Confirm C2 is the cause before hiding the error. Decide what a zero denominator should mean in your model. A numeric 0, a blank, and a warning message communicate different meanings.
Step 3: For this exercise, select E2, enter =IFERROR(B2/C2,0), and press Enter. Confirm E2 displays 0 while D2 remains #DIV/0! so the original failure stays visible for comparison.
=IFERROR(B2/C2,0)Checkpoint
| Cell | Expected |
|---|---|
| B2 | 10 |
| C2 | 0 |
| D2 | #DIV/0! |
| E2 | 0 |
The source inputs remain unchanged. D2 proves the zero-denominator error, and E2 proves the exercise fallback works.
Common mistakes and fixes
If E2 still errors, inspect B2 and C2 and confirm the formula references. If 0 is not a meaningful business result, replace the fallback with an intentional blank or message rather than silently reporting zero.
Independent practice
Temporarily change C2 from 0 to 2. Verify D2 and E2 both recalculate to 5, then restore C2 to 0 and confirm the checkpoint returns to #DIV/0! in D2 and 0 in E2.
Key takeaways
- ✓#DIV/0! appears when a formula attempts to divide by zero.
- ✓Inspect the denominator before adding an error-handling wrapper.
- ✓Keep the broken example visible while testing a correction.
- ✓Choose a fallback that communicates the intended meaning; 0, blank, and warning text are not interchangeable.
- ✓Verify both the original error in D2 and the corrected exercise result in E2.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue with Fix #NAME? errors.
Comments
No comments yet. Be the first to join the discussion.