Excel: clean reports with IFERROR
Sign up free to unlock this topic
Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.
Try the free sample: The ideal gas law · Have a class or homeroom code? Join here
Key idea: Excel: clean reports with IFERROR
Errors like #DIV/0! and #N/A make reports look broken. IFERROR(calculation, what to show instead) shows a clean value, such as 0 or "", when the calculation fails.
Key words
- #DIV/0!
- Dividing by 0 or an empty cell.
- #N/A
- A lookup found nothing.
🔎 What to look for: Use IFERROR on purpose: it can also hide a real mistake.
