Microsoft Office Tutorials and References

In Depth Information

**Error Messages**

What’s curious about this message is that even though you’ve deleted row 17,

another row 17 moves in its place, of course – the row which had heretofore

occupied row 18. But that “new” row 17 won’t stave off the error message.

e.

VALUE
!-Appears when your formula tries to work with textual data inscribed
#

between the parentheses, but you wanted to work with numeric values, e.g.,

=MAX(SCORE,3,4,6)

But keep in mind that if you write

=MAX(A6:A10)

And some of the entries in that range are textual, the formula
won’t
report an

error-it will simply ignore the textual data here and consider the numeric

values only. (Note that if you had named a range of values SCORE in the first

formula, Excel
would
have computed the result).

In addition, Excel supplies you with a collection of Formula Auditing tools gathered into a button group

on the Formulas ribbon which help you identify the cells contributing to the formulas you compose, and

as such can help you isolate sources of error (Figure C–3):

Figure C–3.
The Formula Audting button group

The Trace Precedents and Dependents buttons enable you to visually flag those cells which impact a

formula result (precedents) and the ones which are impacted (dependents). Thus if we write

=A34+B22

in cell D18, A34 and B22 serve as
precedent
cells to the result in D18. Say A34 contains 42 and B22 23.

Click in D18 and click Trace Precedents. You’ll see (Figure C–4):