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

#DIV/0
error.

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.

1

3

Excel opens the first cell

for editing.

3
After the formula’s equals

sign (=), type
iferror(
.

●