Microsoft Office Tutorials and References

In Depth Information

**Display Text Rather than Error Values**

Chapter 4: Getting More Out of Formulas

4
After the formula, type a

comma followed by the

text, in quotation marks,

that you want Excel to

display in place of any

error, followed by a

closing parenthesis.

5
Press Ctrl+Enter.

4

Excel displays the

formula result in cells

where there is no error.

●

Excel displays the text

message in cells that

generate an error.

●

Did You Know?

Excel has a number of error values that it can generate. The following six are the most

common:

Excel’s Most Common Error Values

Error

Description

#DIV/0

Your formula is dividing by zero. Check the divisor input cells for values that are

either zero or blank.

#N/A

Your formula could not return a legitimate result. Check that your function

arguments are appropriate for each function.

#NAME?

Your formula uses a range name or function name that Excel does not recognize.

Check your range names and function names.

#NUM!

Your formula uses a number inappropriately. For example, you entered a

negative number as the argument for the
SQRT()
. Check the arguments for your

mathematical functions to make sure they use the correct types of numbers.

#REF#

Your formula contains an invalid cell reference. This usually occurs when you

delete a cell referenced by a formula. Restore the deleted cell or adjust the

formula to use a different cell.

#VALUE!

Your formula uses an inappropriate value in a function argument. For example,

you might have used a string value instead of a numeric value. Check your

function arguments to make sure they use the correct data type.