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.

Zero2Hero — Zéro2Héros