Formuladrill

IFERROR practice

IFERROR returns a replacement value when a formula produces an error. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.

Syntax

IFERROR(value, value_if_error)

What people get wrong

Wrap only the part that can fail, usually a lookup, so real mistakes elsewhere in the formula are not hidden.

Excel exercise that use IFERROR

Practice IFERROR now

The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.

Start practicing free