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