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.