IFERROR for error handling in Excel - Cell-by-Cell Formula Trace

Sample Data

Sample data with numbers in columns A and B, including zeros to cause division errors.

Cell	Value
A1	10
A2	0
A3	5
B1	2
B2	0
B3	0

Formula Trace

=IFERROR(A1/B1, "Error")

Step 1: A1/B1

Step 2: 10/2

Step 3: IFERROR(5, "Error")

Cell Reference Map

    A    B
1 | 10 |  2 |
2 |  0 |  0 |
3 |  5 |  0 |

Formula in C1: =IFERROR(A1/B1, "Error")
References A1 and B1 for division.

The formula uses cells A1 and B1 to perform division and handle errors.

Result

    A    B    C
1 | 10 |  2 |  5 |
2 |  0 |  0 |    |
3 |  5 |  0 |    |

Cell C1 shows 5, the result of the division without error.

The formula result 5 appears in cell C1 because division was successful.

Sheet Trace Quiz - 3 Questions

What does IFERROR return if the division causes an error?

A The error message specified in the formula

B The division result even if it's an error

C Zero

D Nothing, the cell stays blank

Key Result

IFERROR(expression, value_if_error) returns the expression result or the specified value if there is an error.