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-
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.