📊 Excel Basics #18 – IFERROR() Function

The IFERROR() function helps you handle errors gracefully by displaying a custom message or value instead of Excel error codes. It's one of the most useful functions for creating professional reports and dashboards.

📌 What is the IFERROR() Function?
The IFERROR() function checks whether a formula returns an error.
• If no error occurs, it returns the formula's result.
• If an error occurs, it returns the value you specify.

Syntax:
=IFERROR(value, value_if_error)

📌 Example 1 – Avoid Division by Zero
Without IFERROR():
=A2/B2
If B2 = 0, Excel returns: #DIV/0!

With IFERROR():
=IFERROR(A2/B2,"Cannot Divide")

Result:
• If B2 = 10 → Returns the calculated value.
• If B2 = 0 → Returns "Cannot Divide".

📌 Example 2 – Return 0 Instead of an Error
=IFERROR(A2/B2,0)
If an error occurs, Excel returns 0 instead of an error message.

📌 Example 3 – Handle Lookup Errors
=IFERROR(VLOOKUP(E2,A2:C10,3,FALSE),"Not Found")
If the value isn't found, Excel displays "Not Found" instead of #N/A.

📌 Common Excel Errors
• #DIV/0! → Division by zero.
• #N/A → Value not found.
• #VALUE! → Incorrect data type.
• #REF! → Invalid cell reference.
• #NAME? → Misspelled function or name.
• #NUM! → Invalid numeric value.
• #NULL! → Incorrect range reference.

📌 Real-World Uses
✅ Display "Not Available" for missing data
✅ Prevent lookup formulas from showing errors
✅ Build clean dashboards without error messages
✅ Improve the appearance of reports shared with stakeholders

📌 Common Mistakes
❌ Using IFERROR() to hide errors without fixing the root cause
❌ Returning misleading values that make debugging difficult
❌ Wrapping every formula unnecessarily

✅ Best Practices
✅ Use IFERROR() only when errors are expected
✅ Choose meaningful replacement values like "Not Found" or "No Data" instead of leaving users confused.
✅ Fix the underlying issue whenever possible rather than simply hiding the error.
✅ Combine IFERROR() with lookup functions like VLOOKUP(), XLOOKUP(), and INDEX()/MATCH() for professional spreadsheets.

The IFERROR() function makes your Excel workbooks cleaner, easier to understand, and more user-friendly.

Double Tap ❤️ For More