Microsoft Office Tutorials and References
In Depth Information
Display Text Rather than Error Values
Display Text Rather
than Error Values
You can avoid unsightly and unhelpful error
values in your worksheets by using the
IFERROR function to display a text string
rather than an error.
If Excel encounters an error when calculating a
formula, it often displays an error value as the
result. For example, if your formula divides by
zero, Excel indicates the error by displaying
the value #DIV/0 in the cell.
This is often useful because it lets you know
that a formula did not calculate properly, so
you can investigate the problem. However,
there may be times when you know the error is
temporary or is otherwise unimportant. For
example, if your worksheet is missing some
data, then a blank cell might be causing the
Rather than displaying an error value, you can
use the IFERROR function to test for an error
and display a more useful result in the cell:
IFERROR( expression , error_result )
Here, expression is the formula you are using,
and error_result is the text you want Excel to
display if the formula produces an error.
1 Select the range that
contains the formulas
you want to edit.
2 Press F2.
Excel opens the first cell
3 After the formula’s equals
sign (=), type iferror( .