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,

of course).

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.

Figure 4-19:

Two ways to

prevent an

error from

being seen.