Microsoft Office Tutorials and References

In Depth Information

**Finding and correcting errors in calculations**

3

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.