IFERROR Function in Excel: Syntax, Examples and Free Practice
IFERROR is an Excel Logic function. Runs a formula, but shows a fallback value instead of an error if it fails.
IFERROR syntax
Arguments
value: The value to evaluatevalue_if_error: What to return if the formula results in an error
When to use IFERROR
IFERROR is used to build decision rules directly into a spreadsheet instead of manually judging each row.
Practice IFERROR online, free
Open the live Excel-style spreadsheet and try IFERROR yourself. No Excel install or sign-up needed to start.
Practice IFERROR now →Learn more
Read the tutorial: How to use IFERROR.
IFERROR practice questions
- Divide the sales by the units for each row, but show 0 when the units are 0. Put it in…
- Look up the price of each item in the table (D2:E4). Show Not found if the item is not…
- The values are typed as text. Turn each into a number, and show 0 if it is not a number.…
- Find the growth (this year minus last year, divided by last year). Show New when last…
- Find the average of the three marks in B to D for each student. Show No marks when the…
- Look in list 1 (C2:D3) first, then in list 2 (E2:F3), and show Not found if the code is…
- Divide each sales figure in column A by the units in column B, treat the errors as 0,…
- Each note may contain a reference like #101. Take the number after the # sign, or show…
- Product IDs to price are in A2:A7 and the price list is in D2:E6. Show the price in…
More Logic functions
Frequently asked questions
What does the IFERROR function do in Excel?
Runs a formula, but shows a fallback value instead of an error if it fails.
What is the syntax of IFERROR in Excel?
The syntax is =IFERROR(value, value_if_error). value: The value to evaluate; value_if_error: What to return if the formula results in an error.
Where can I practice IFERROR online for free?
Open the free live spreadsheet on Cellgrids and try IFERROR yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Logic functions · Excel case studies · Excel tutorials · Excel shortcuts