What does IFERROR do in Excel?

IFERROR returns a custom value when a formula returns an error, such as #N/A, #DIV/0!, or #VALUE!.

Is IFERROR bad practice?

IFERROR is useful for reports, but it can hide real problems if used without checking why the error happens.

Why does my formula show an error?

Open the linked error pages (#N/A, #VALUE!, #REF!) from our directory. Most formula posts fail because of data type mismatches, deleted references, or wrong match modes — not because the function name is wrong.

Should I copy formulas down or use a Table?

Copying down is fine for one-off models. Convert the range to an Excel Table when you add rows often — structured references stay readable and break less.

Should I still learn VLOOKUP in 2026?

Yes for legacy files and teams on older Excel. Learn XLOOKUP as well if you use Microsoft 365 — many new models start there.

Formulas - 2026-05-12

IFERROR in Excel: Practical Examples

Learn IFERROR in Excel for cleaner VLOOKUP, XLOOKUP, division, dashboard formulas, and error handling without hiding real data problems.

What IFERROR Does

IFERROR returns a custom result when a formula returns an error. It is commonly used to make reports cleaner. Syntax: \\\ =IFERROR(value, value_if_error) \\\

IFERROR with VLOOKUP

\\\ =IFERROR(VLOOKUP(E2,A:C,3,FALSE),"Not found") \\\ This replaces #N/A with a clear message.

IFERROR with Division

\\\ =IFERROR(B2/C2,0) \\\ This prevents #DIV/0! when the denominator is zero or blank.

When Not to Use IFERROR

Do not use IFERROR to hide problems you should fix. If a formula is failing because the source data is wrong, fix the source data first. Use specific checks when possible, such as testing for blanks before calculating.

Related Guides

IFERROR function VLOOKUP Returning #N/A? How to Use the IF Function in Excel Fix Excel Formula Errors

Formula debugging workflow

Step Action 1 Select the cell and read the formula in the formula bar 2 Use Formulas → Evaluate Formula for nested functions 3 Check for text stored as numbers (green triangle) 4 Fix errors using our formula error guide Go deeper: Compare similar functions · Fix common problems \nLookup help: VLOOKUP function · VLOOKUP tutorial · Fix #N/A · vs XLOOKUP

Frequently asked questions

What does IFERROR do in Excel? IFERROR returns a custom value when a formula returns an error, such as #N/A, #DIV/0!, or #VALUE!.
Is IFERROR bad practice? IFERROR is useful for reports, but it can hide real problems if used without checking why the error happens.
Why does my formula show an error? Open the linked error pages (#N/A, #VALUE!, #REF!) from our directory. Most formula posts fail because of data type mismatches, deleted references, or wrong match modes — not because the function name is wrong.
Should I copy formulas down or use a Table? Copying down is fine for one-off models. Convert the range to an Excel Table when you add rows often — structured references stay readable and break less.
Should I still learn VLOOKUP in 2026? Yes for legacy files and teams on older Excel. Learn XLOOKUP as well if you use Microsoft 365 — many new models start there.