Microsoft Office Tutorials and References
In Depth Information
Audit a Worksheet for Errors
EXCEL
chapter 11
Working with Formulas and Functions
Trace Errors
1 Click in the cell containing the
error that you want to trace.
2 Click the Formulas tab on the
Ribbon.
3 Click the Error Checking
2
3
4
.
4 Click Trace Error .
1
Excel displays trace lines from the
current cell to any cells referenced
in the formula.
‚óŹ
You can make changes to the cell
contents or changes to the
formula to correct the error.
Note:
Click the
Remove Arrows
button to turn
off the trace lines.
What kinds of error messages does Excel display for formula errors?
Different types of error values appear in cells when an error occurs:
Error
Problem
Solution
######
The cell is not wide enough to contain the value
Increase the column width
#DIV/0!
Dividing by zero
Edit the cell reference or value of the denominator
#N/A
Value is not available
Ensure that the formula references the correct value
#NAME?
Does not recognize text in a formula
Ensure that the name referenced is correct
#NULL!
Specifies two areas that do not intersect
Check for an incorrect range operator or correct the
intersection problem
#NUM!
Invalid numeric value
Check the function for an unacceptable argument
#REF!
Invalid cell reference
Correct cell references
#VALUE!
Wrong type of argument or operand
Double-check arguments and operands
201
 
Search JabSto ::




Custom Search