Goal: Identify and fix formula errors.
Excel uses specific codes (starting with #) to tell you exactly what went wrong.
Ready...
💻 Error Library
ERROR CODES
- #DIV/0!: Trying to divide by zero or an empty cell.
- #N/A: Value Not Available (Lookup failed).
- #NAME?: Excel doesn't recognize text (typo in function).
- #VALUE!: Wrong type of argument (Math on text).
- #REF!: Invalid cell reference (Cell deleted).
-- Debugging...
Select an error to analyze.
⚠️ Quick Fixes
🛡️ IFERROR
Wrap risky formulas in =IFERROR(Value, "Message") to catch any error and display a clean message or 0 instead.
🔍 Trace Precedents
Go to the Formulas Tab > Trace Precedents to see arrows pointing to the cells causing the error.