Microsoft Office Tutorials and References
In Depth Information
Understanding Error Messages in Formulas
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-
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
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-
33. From the drop-down menu, select Trace Error. Excel draws in red ar-
For example, from the original #N/A! error in cell D11, blue arrows
demonstrate what cells were causing the error.