ISERROR Function

Summary

ISERROR returns TRUE when a value contains any Excel error. That includes #N/A, #VALUE!, #REF!, #DIV/0!, and the other standard error types.

This makes ISERROR the broad version of Excel error checking. If you do not need to separate one error type from another, it gives you a simple yes-or-no test that tells you whether the result is clean or not.

ISERROR is often used as a safety layer. It helps the workbook detect when a formula has failed so another formula can react with a cleaner message, a fallback value, or a simpler status label instead of showing the raw error directly to the user.

Syntax

=ISERROR(value)

You can test a cell reference, a formula result, or a direct expression. Microsoft groups ISERROR with the other IS functions, which all return only TRUE or FALSE based on the type of result they receive.

Arguments

• value - [required] The value, cell reference, or formula result you want to test.

ISERROR does not change the value. It only checks whether the result is an Excel error.

ISERROR vs Other Functions

Using ISERROR

The usual reason to use ISERROR is to test whether a result is valid before you do something else with it. That can be useful in dashboards, validation sheets, and helper columns where the next step depends on knowing whether the current formula worked at all.

ISERROR is also helpful when you want one broad rule for all error types. A missing lookup, a broken reference, and a divide-by-zero problem all return TRUE here. That can be convenient when the exact error type does not matter and you only want to know whether the result is safe to use.

One practical note matters here. The older pattern =IF(ISERROR(formula),fallback,formula) can evaluate the same formula twice. If your version of Excel supports IFERROR, that is often cleaner when your goal is simply to replace the error with another result. ISERROR is still useful when you want to test and branch more deliberately.

Example 1 - Catch Any Error Type

This example checks one cell to see whether it contains any normal Excel error. It is the broadest kind of error test because it does not care which specific error type is there.

That makes it useful when the main question is simply whether the value is safe to use or whether something went wrong and needs handling first.

=ISERROR(A1)

If A1 contains any standard Excel error, the result is TRUE. That makes this a quick way to check whether a cell is safe to use in later logic or whether it needs attention first.

Example 2 - Catch #N/A as Well

This example highlights one of the main differences between ISERROR and ISERR. ISERROR treats #N/A as an error too.

That is helpful when you want one broad error check and do not need to keep missing-lookups separate from the rest.

=ISERROR(C1)

If C1 contains #N/A, ISERROR still returns TRUE. That is useful when you want a broad error check and do not need to treat missing lookups differently from other errors.

Example 3 - Show a Fallback Message

This example turns the error test into a readable message. Instead of showing the raw error to the user, the formula swaps it for a fallback label.

That makes the sheet easier to read, especially in dashboards or reports where you want to explain the problem without exposing the error code itself.

=IF(ISERROR(A1),"Processing...",A1)

If A1 contains an error, the formula returns "Processing...". Otherwise it returns the original value. This works, but it is best used when you specifically want the logical test as part of a larger formula flow.

Example 4 - Confirm a Normal Value Is Clean

ISERROR is also useful for confirming that a good value is not being flagged.

=ISERROR(B2)

If B2 contains a valid number like 500, the result is FALSE. That may sound simple, but it is useful when you are auditing mixed data and want to separate clean rows from rows with problems.

Conclusion Recap

ISERROR is the broad version of an error check. In this lesson, it was used to catch any error, including #N/A, and to build simple fallback patterns.

It is useful when you care more about whether something failed than about the exact error type. If the error type matters, a more specific function is usually the better choice.

• Main job: ISERROR catches any Excel error.
• Includes #N/A: That is the key difference from ISERR.
• Good use: Broad error checks and helper logic in reports or validation steps.
• Common pair: Use it with IF when you want a message or alternate result.
• Modern alternative: Use IFERROR when you want to replace the error directly.