IFERROR

LogicalExcel 2007

Return a fallback when a formula errors, otherwise the result.

Syntax

IFERROR(value, value_if_error)

How it works

Catches every error type (#N/A, #DIV/0!, #VALUE!, …). Use IFNA if you only want to catch #N/A.

Examples

=IFERROR(A2/B2, 0)

→ 0 when B2 is blank/0

=IFERROR(VLOOKUP(A2, tbl, 2, 0), "Not found")

→

Good to know

Don't wrap a whole complex formula in IFERROR blindly — it can hide a real bug. Fix the cause where you can.

Related functions

IFNA ISERROR IF

More Logical functions

AND FALSE IF IFNA IFS LAMBDA LET NOT OR SWITCH TRUE XOR

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.