Microsoft Office Tutorials and References
In Depth Information
Finding and correcting errors in calculations
TIP You can have the Error Checking tool ignore formulas that don’t use every cell in a
region (such as a row or column). If you clear the Formulas Which Omit Cells In A Region
check box, you can create formulas that don’t add up every value in a row or column (or
rectangle) without Excel marking them as an error.
For times when you just want to display the results of each step of a formula and don’t
need the full power of the Error Checking tool, you can use the Evaluate Formula dialog box
to move through each element of the formula. To open the Evaluate Formula dialog box,
you display the Formulas tab and then, in the Formula Auditing group, click the Evaluate
Formula button. The Evaluate Formula dialog box is useful for examining formulas that
don’t produce an error but aren’t generating the result you expect.
Finally, you can monitor the value in a cell regardless of where in your workbook you are
by opening a Watch Window that displays the value in the cell. For example, if one of your
formulas uses values from cells in other worksheets or even other workbooks, you can set
a watch on the cell that contains the formula and then change the values in the other cells.