IFERROR and IFNA in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to return 0 if A1 has an error.

Google Sheets

=IFERROR(A1, [1])

Drag options to blanks, or click blank then click option'

ATRUE

B0

C"Error"

DA1

Attempts:

3 left

💡 Hint

Common Mistakes

Using A1 as the error value returns the error again.

Using TRUE returns TRUE instead of a number.

The IFERROR function returns the value of A1 if no error occurs. If there is an error, it returns the value you provide, here 0.

2fill in blank

medium

Complete the formula to return "No Data" if B2 has an #N/A error.

Google Sheets

=IFNA(B2, [1])

Drag options to blanks, or click blank then click option'

AB2

B0

CTRUE

D"No Data"

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 returns zero even if the error is #N/A.

Using B2 repeats the error instead of replacing it.

The IFNA function returns the value of B2 if it is not an #N/A error. If it is #N/A, it returns the text "No Data".

3fill in blank

hard

Fix the error in the formula to return "Missing" if C3 has an #N/A error.

Google Sheets

=IFNA(C3 [1] "Missing")

Drag options to blanks, or click blank then click option'

A,

B;

C:

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolon or colon causes a formula error.

Using plus sign is invalid syntax here.

The IFNA function requires a comma to separate the value and the value_if_na arguments.

4fill in blank

hard

Fill both blanks to return "Error" if D4 has any error, else return D4.

Google Sheets

=IFERROR([1], [2])

Drag options to blanks, or click blank then click option'

AD4

B"Error"

C0

DD5

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 instead of "Error" changes the output meaning.

Using D5 instead of D4 checks the wrong cell.

The IFERROR function returns the value of D4 if no error occurs. If there is an error, it returns the text "Error".

5fill in blank

hard

Fill all three blanks to return "No Value" if E5 has #N/A error, else return E5 if no error, else return 0.

Google Sheets

=IFERROR(IFNA([1], [2]), [3])

Drag options to blanks, or click blank then click option'

AE5

B"No Value"

C0

D"Error"

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the order of IFNA and IFERROR causes wrong results.

Using "Error" instead of 0 changes the fallback value.

This formula first checks if E5 has an #N/A error using IFNA. If yes, it returns "No Value". If no #N/A error, it returns E5. Then IFERROR catches any other errors and returns 0.