Goal: Calculate Price per Unit (Sales / Units). Problem: Dividing by zero creates a #DIV/0! error. Solution: Use IFERROR to catch it and show "0" instead.
Ready...
💻 Formula Structure
=IFERROR(value, value_if_error)
1. Value: The calculation to try (e.g., A1 / B1).
2. If Error: What to display if it fails (e.g., 0, "-", "Error").
-- Try Division, return 0 if it fails
=IFERROR( Sales/Units, 0 )
Safe Result:
-
🛡️
⚠️ Common Pitfalls
🚫 Masking Real Problems
IFERROR catches everything (#REF, #NAME, #VALUE). Sometimes you want to see errors (like typos) so you can fix them.
✅ Fix: Use IFNA to catch only VLOOKUP errors.
🚫 Returning Text for Math
If you return "Error" (text) instead of 0 (number), you won't be able to Sum that column later.