Troubleshooting Formulas
Formulas are extremely powerful tools, especially when they include functions, and constructing valid formulas can be a bit tricky. Fortunately, Excel provides a group of formula-auditing tools that can help you find and fix errors such as circular references, incorrect syntax in a formula, or a referenced cell that has been deleted.
Review the Errors
On the Formulas tab, click the Show Formulas button to display all the formulas in the worksheet.
Click the Error Checking button.In the Error Checking dialog box, use the Next ...
Get 2007 Microsoft® Office System Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
