Microsoft Office Tutorials and References
In Depth Information
We see that D18 requires, or depends, on A34 (in addition to B22) for its result.
The Error Checking option is a particularly apt one if you’re having trouble determining exactly
where and why an error, or errors, have been perpetrated. Clicking the Error Checking button sets in
motion a dialog box which flits from error to error on your worksheet (not the entire workbook), and
describes each one. Say you’re entered =8/0 in cell A12 and AVERAGEX(D67:D10) in B21 (it doesn’t
matter if the cells in that range are blank). Click Error Checking and you’ll see (Figure C–6):
Figure C–6. The Error Checking dialog box
Note the report of the type of mistake that’s been committed in A12. Click Next and the error
checker will streak to the site of the next error–B21 (Figure C–7):
Figure C–7. Error prone, aren’t I?
And so on. Clicking Show Calculation Steps opens an Evaluate Formula dialog box in turn, which in our
latter case will disclose (Figure C–8):