Microsoft Office Tutorials and References

In Depth Information

Tracing error values

Often, an error in one cell is the result of an error in a
precedent cell
(a cell that is used by the formula). To help

track down the source of an error value in a cell, select the cell and choose Formulas⇒Formula Auditing⇒Error

Checking⇒Trace Error. Excel draws arrows to indicate the error source.

After you identify the error, use Formulas⇒Formula Auditing⇒Error Checking⇒Remove Arrows to get rid of the ar-

row display.

#DIV/0! errors

Division by zero is not a valid operation. If you create a formula that attempts to divide by zero, Excel displays

its familiar #DIV/0! error value.