Microsoft Office Tutorials and References
In Depth Information
Understanding Error Messages in Formulas
Figure 9.4.
Figure 9.4. The error in E17 is actually caused by an error two calcula-
The error in E17 is actually caused by an error two calcula-
tions earlier.
tions earlier.
Figure 9.4 shows only a small table, so it is relatively easy to find the
earlier #N/A errors. However, if you were totaling 100,000 rows, it can be
difficult to find the one offending cell. To track down errors, follow these
steps:
11. Select the cell that shows the final error. To the left of that cell,
you should see an exclamation point in a yellow diamond.
22. Hover the cursor over the yellow diamond to reveal a drop-down ar-
row.
33. From the drop-down menu, select Trace Error. Excel draws in red ar-
rows pointing back to the source of the error, as shown in Figure 9.5 .
For example, from the original #N/A! error in cell D11, blue arrows
demonstrate what cells were causing the error.
Search JabSto ::




Custom Search