Error Checking

I would like to discuss how can we trace error in excel formulas. There are several methods to do so. Let's consider some of them. Download the data file from here.

Excel sheets may have lots of equations to proper functioning. If there is a mistake in one of those equations it's very difficult to locate the correct cell manually.  We can use "Trace Precedents" and "Trace Dependents" options to locate correct cell.

Go to "Formula Auditing" group in "Formulas" tab.

You can find  "Trace Precedents" and "Trace Dependents" options left side of the group.

Select the cell which contains the error formula.

Click on "Trace Precedents".

See the arrow lines connecting all relevant cells.

Likewise see the "Trace dependents" option.

We can use "Remove Arrows" option to clear arrows.

If there is an error in formula we can use "Error Checking" function.

Go to "Formula Auditing" group in "Formulas" tab.

Select the cell which containing the error value.

Then click  the small arrow on "Error Checking"

Select "Trace Error"

See red arrow from the cell which is caused to error.