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




Custom Search