Module 3 · Lesson 12
IFERROR
Handle expected formula errors without hiding real problems.
Errors often contain useful information
An error may reveal a missing lookup value, invalid reference, or division by zero. Diagnose it before replacing it with a friendly result.
=IFERROR(A2/B2,0)Choose a meaningful fallback
A blank, zero, or message can have different business meanings. Use a fallback that helps the person reviewing the workbook.
- Do not hide every error automatically.
- Use a message when action is required.
- Recheck the underlying formula first.
Key takeaway: Use IFERROR around a formula only when you understand which error is expected and what the fallback should mean.