Microsoft Office Tutorials and References
In Depth Information
Making an Error Behave the Way You Want
Display the Check Error dialog box by clicking the Error Checking selection
in the Error Checking drop-down menu on the Ribbon (on the Formulas tab,
The dialog box has a handful of buttons that let you analyze the error and
make decisions about it:
✓ Help on this error starts the Excel Help system.
✓ Show Calculation Steps opens the Evaluate Formula dialog box.
✓ Ignore Error ensures that Excel no longer cares about the error. The cell
may still display an error symbol, but Excel does not give a hoot, and
probably you won’t either, since you clicked the button.
✓ Edit in Formula Bar places the cursor in the Formula Bar, making it easy
for you to edit the formula.
✓ Options opens the Excel Options dialog box.
✓ PreviousandNext cycle through the multiple errors on the worksheet,
assuming there is more than one error.
The Error Checking drop-down hosts the Trace Error command. Only
precedents are pointed out by the tracer lines. This makes it easy to see the cells
that feed into a cell that has an error.
Making an Error Behave
the Way You Want
Excel has a neat function: IfError. Don’t confuse it with IsError, which is
similar but not as slick. Figure 4-19 shows how IfError one-ups IsError. In the
figure, F7 has the dreaded Divide by Zero error. It’s not a pretty thing to see,
and I am sure the boss would appreciate a cleaner visual to work with.
Two ways to