Correcting Formulas
Excel has several tools to help you find and correct problems with formulas. One tool is the Watch window and another is the Error checker. The Watch window keeps track of cells and their formulas as you make changes to a worksheet. Excel uses an error checker in the same way Microsoft Word uses a grammar checker. The Error checker uses certain rules, such as using the wrong argument type, a number stored as text or an empty cell reference, to check for problems in formulas.
Watch Cells and Formulas
Select the cells you want to watch.
Click the Formulas tab.
Click the Watch Window button.
Click the Add Watch button on ...
Get Excel® 2013 On Demand 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.
