IFERROR for error handling in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to return 0 if there is an error in cell A1 divided by B1.

Excel

=IFERROR(A1/B1, [1])

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

AA1

B0

CB1

D"Error"

Attempts:

3 left

💡 Hint

Common Mistakes

Putting the formula inside quotes.

Using a cell reference instead of a number for the error result.

The IFERROR function returns the result of A1/B1 if no error occurs. If there is an error (like division by zero), it returns 0.

2fill in blank

medium

Complete the formula to show "N/A" if the VLOOKUP in cell C2 causes an error.

Excel

=IFERROR(VLOOKUP(C2, A1:B10, 2, FALSE), [1])

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

A"N/A"

B0

CFALSE

DC2

Attempts:

3 left

💡 Hint

Common Mistakes

Not putting the text inside quotes.

Using a number instead of text for the error message.

The IFERROR function will return the result of the VLOOKUP if it finds a match. If not, it returns the text "N/A" to indicate no data found.

3fill in blank

hard

Fix the error in the formula to return "Invalid" if the division causes an error.

Excel

=IFERROR(A2[1]B2, "Invalid")

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

A-

B*

C+

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using multiplication or addition instead of division.

Leaving out the operator.

The formula needs the division operator / between A2 and B2. IFERROR will catch errors like division by zero and return "Invalid".

4fill in blank

hard

Fill both blanks to create a formula that returns the sum of A1 and B1, or 100 if there is an error.

Excel

=IFERROR(A1 [1] B1, [2])

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

A+

B-

C100

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using subtraction instead of addition.

Returning zero instead of 100 on error.

The formula adds A1 and B1 using the plus sign. If there is an error, it returns 100.

5fill in blank

hard

Fill all three blanks to create a formula that returns the uppercase of A1 if no error, or "ERROR" if there is an error.

Excel

=IFERROR([1](A1), [2])

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

AUPPER

B"ERROR"

C"Error"

DLOWER

Attempts:

3 left

💡 Hint

Common Mistakes

Using LOWER instead of UPPER.

Not putting the error message inside quotes.

The formula uses the UPPER function to convert text in A1 to uppercase. If there is an error, it returns the text "ERROR".