February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...