ƒx

Excel IFERROR Formula

data Difficulty:

One-Click Copy

IFERROR(value, value_if_error)

Quick context

• Works in both Excel and Google Sheets.
• Use when you need consistent, auditable results.
• Copy the snippet above and adjust only the ranges.

When to use

Returns a custom result if a formula evaluates to an error; otherwise, returns the result of the formula.

Replace ugly error codes like #N/A with custom text or values.

Handle Errors Gracefully

Replace ugly error codes like #N/A with custom text or values.

Inputs

value The formula or value to check for error.
value_if_error The value to return if an error is found.

Practical Example

=IFERROR(A1/B1, "Error in Calculation")

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.