Microsoft Office Tutorials and References
In Depth Information
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.
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.,
But keep in mind that if you write
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
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):