IFERROR practice
IFERROR returns a replacement value when a formula produces an error. Below are the 1 Google Sheets exercise on Sheetsdrill 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.
Google Sheets exercise that use IFERROR
Practice IFERROR now
Your first 15 exercises are free without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free