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




Custom Search