Excel FunctionsLesson 86Free preview

IFERROR

This lesson is part of Excel · All levels

Summary

IFERROR is an Excel function that handles error values by displaying a more friendly replacement value. The syntax is. If the first value is not an error, the result is continued as it is, so it is convenient to wrap up the VLOOKUP or the partition.

Key points

Syntax: IFERROR(value, value_if_error)
Catch all sorts of errors like #N/A, #DIV/0!, and #VALUE!
The non-error value is continued unchanged
IFERROR differs from IFNA which specifically handles #N/A

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.