␡
- Introduction
- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
This chapter is from the book
This chapter is from the book
This chapter is from the book
This chapter is from the book
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 the Watch Window dialog box.
Click Add.
Click Close.
)
Remove Cells from the Watch Window
- Click the Formulas tab.
- Click the Watch Window button.
- Select the cells you want to delete. Use the Ctrl key to select multiple cells.
- Click Delete Watch.
- Click Close.
)
Set Error Checking Options
- Click the File tab, and then click Options.
- In the left pane, click Formulas.
- Select the Enable background error checking check box.
- Point to the help icons at the end of the error checking rule options to display a ScreenTip describing the rule.
- Select the error checking rules check boxes you want to use.
- Click OK.
)
Correct Errors
- Open the worksheet where you want to check for errors.
- Click the Formulas tab.
- Click the Error Checking button.
The error checker scans the worksheet for errors, generating the Error Checking dialog box every time it encounters an error.
- If necessary, click Resume.
- Choose a button to correct or ignore the problem.
- Help on this error.
- Show Calculation Steps. Click Evaluate to see results.
- Ignore Error.
- Edit in Formula Bar.
- Previous or Next.
- If necessary, click Close.
)
)