Recall & Review
beginner
What does the IFERROR function do in Google Sheets?
IFERROR checks a formula for an error. If there is an error, it shows a value you choose. If no error, it shows the formula result.
Click to reveal answer
intermediate
How is IFNA different from IFERROR?
IFNA only catches #N/A errors, while IFERROR catches all types of errors like #DIV/0!, #VALUE!, and #N/A.
Click to reveal answer
beginner
Write a simple IFERROR formula to avoid showing an error when dividing by zero.
Example: =IFERROR(A1/B1, "Cannot divide by zero") will show "Cannot divide by zero" if B1 is zero or empty.
Click to reveal answer
beginner
What happens if IFERROR's formula does not produce an error?
IFERROR returns the normal result of the formula without any change.
Click to reveal answer
intermediate
Why might you use IFNA instead of IFERROR in a lookup formula?
Because IFNA only handles #N/A errors, it lets other errors show up. This helps you catch missing data without hiding other problems.
Click to reveal answer
What will =IFERROR(10/0, "Error") display?
✗ Incorrect
Dividing by zero causes an error, so IFERROR shows the custom message "Error".
Which error does IFNA specifically catch?
✗ Incorrect
IFNA only catches the #N/A error, which means 'not available'.
If a formula returns 5, what does IFERROR(formula, "Oops") return?
✗ Incorrect
IFERROR returns the formula result if there is no error.
Which function would you use to hide all errors with a custom message?
✗ Incorrect
IFERROR hides all errors and shows your message instead.
Why use IFNA instead of IFERROR in a VLOOKUP?
✗ Incorrect
IFNA catches only #N/A errors, which happen when data is missing in lookup.
Explain how IFERROR works and give a real-life example where it helps.
Think about when a formula might break and how IFERROR can help.
You got /4 concepts.
Describe the difference between IFERROR and IFNA and when to use each.
Focus on the types of errors each function handles.
You got /4 concepts.