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.
Search JabSto ::

Custom Search