Chapter 19: Making Your Formulas Error-Free
19
FIGURE 19.2
The Evaluate Formula dialog box shows a formula being calculated one step at a time.Click the Evaluate button to show the result of calculating the expressions within the for-
mula. Each click of the button performs another calculation. This feature may seem a bit
complicated at first, but if you spend some time working with it, you’ll understand how it
works and see the value.Excel provides another way to evaluate a part of a formula:- Select the cell that contains the formula.
- Press F2 to get into Cell Edit mode.
- Use your mouse to highlight the portion of the formula you want to evaluate,
or press Shift and use the navigation keys. - Press F9.
The highlighted portion of the formula displays the calculated result. You can evaluate
other parts of the formula or press Esc to cancel and return your formula to its previous
state.Be careful when using this technique because if you press Enter (rather than Esc), the formula will be modified to use
the calculated values.