Excel Function

IFERROR

Returns fallback value when formula errors.

IFERROR(value, value_if_error)

Arguments

value

Required

Enter an expression such as comparison or calculation.

value_if_error

Required

Specify the value returned when the formula results in an error.

Practice Preview

Use IFERROR to return "N/A" when VLOOKUP("Not found",B2:D8,3,FALSE) results in an error.

Example Table

#	ALearner ID	BName	CScore
2	U001	Tanaka	82
3	U002	Sato	67
4	U003	Suzuki	91
5	U004	Takahashi	55
6	U005	Ito	78
7
8

How to Use (Formula)

=IFERROR(VLOOKUP("Not found",B2:D8,3,FALSE), "N/A")

Result

N/A

Practice This Function

Start Function Practice Back to Function List

IFERROR FAQ

How do I use IFERROR in Excel?

Use IFERROR when you want to show a fallback when a formula returns an error. Enter Value, Value if error in that order, then add optional arguments when needed.

Where can I practice IFERROR?

Use the "Start Function Practice" button to jump straight into IFERROR drills.

What arguments does IFERROR use?

The main arguments are Value, Value if error. Enter them in order.