Microsoft Office Tutorials and References

In Depth Information

**Audit a Worksheet for Errors**

11

CHAPTER

EXCEL

Working with Formulas and Functions

Trace Errors

1
Click the cell containing the

formula or function error that

you want to trace.

2
Click the
Formulas
tab.

3
Click the
Error Checking

.

4
Click
Trace Error
.

E
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.

F
You can click
Remove Arrows
to

turn off the trace lines.

TIP

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

207