Tip Printed from ExcelTip.com

---

Tracing Errors in Formula Results


To trace an error when using Excel 2002 & Excel 2003:

1. Select cell B1 (a cell containing an error), and click Error Checking (the first icon on the left of the Auditing Formulas toolbar).
OR
Use the Smart Tag to open the Error Checking dialog box.
2. Click Options.