Microsoft Office Tutorials and References

In Depth Information

**Controlling which error messages appear**

Controlling which error messages appear

We all make mistakes, but some of those mistakes are easier

to recover from than others. If you create a formula that tries

to have Excel divide a value by zero or use a value from a cell

that’s currently blank, Excel displays an error flag indicating that

it thinks you made a mistake. If the error is that no value is in a

cell that you refer to in a formula, you can fix the problem by

putting a value in that cell.

a worksheet that contains five columns of data and you find

the sum of each of those columns, Excel identifies the pattern

inherent in those formulas. If you put a different type of formula

(such as a formula that finds the maximum value in all five rows)

in the cell next to those five consistent formulas, Excel displays

an error indicating that the formula is inconsistent. Fortunately,

you can choose to turn several types of error indicators on or

off, saving you and your colleagues from worrying about errors

that don’t exist.

However, sometimes Excel identifies a formula as an error

when it’s exactly what you intended. For example, if you create

Choose which error messages appear

1
Click the File tab.

2
Click Options.

3
Click Formulas.

4
Clear the check boxes next to the errors that you want Excel to

ignore.

5
Click OK.

3

4

5

2

TIP The most common errors that you’ll want to ignore are

formulas that are inconsistent with other formulas in the region

and formulas that omit cells in a region.