Microsoft Office Tutorials and References

In Depth Information

Figure 22-12:
Clicking an error's icon gives you a list of options.

Figure 22-13:
Using the Error Checking dialog box to cycle through potential errors identified by Excel.

It's important to understand that the error-checking feature is not perfect. In fact, it's

not even close to perfect. In other words, you can't assume that you have an error-free

worksheet simply because Excel does not identify any potential errors! Also, be aware

that this error checking feature won't catch a very common type of error — that of over-

writing a formula cell with a value.

Using Excel's Formula Evaluator

Excel's Formula Evaluator enables you to see the various parts of a nested formula evaluated in the order that

the formula is calculated.

To use the Formula Evaluator, select the cell that contains the formula and then choose Formula
⇒
Formula

Auditing
⇒
Evaluate Formula to display the Evaluate Formula dialog box, as shown in Figure 22-14.

Figure 22-14:
Excel's Formula Evaluator shows a formula being calculated one step at a time.