Page 78 - Excel Data Analysis

05 537547 Ch04.qxd 3/4/03 11:52 AM Page 64

EXCEL DATA ANALYSIS

EVALUATE A FORMULA

f the formula you create does not seem to return =4+B1+C1
appropriate results, you can use the Evaluate Formula When all arguments have values, Excel inputs the arguments
I dialog box. This option allows you to step through the into the function, solves the formula, and displays the result.
execution of the formula, letting you view how Excel applies You can repeat the process using the Restart button.
each argument.
The Step In button allows you to view the actual contents
The Evaluate Formula dialog box displays the formula and of the referenced cell before applying it to the formula by
the values you supply as arguments. For example, if you displaying it in a separate box. The Step Out button applies
have a formula that sums the values in cells A1, B1, and C1, the argument to the function and continues the process.
Excel displays the following in the dialog box:
The Evaluate Formula dialog box only allows you to view the
=A1+B1+C1
execution of a formula; it does not allow you to modify the
formula. If you want to change any portion of the formula,
You step through the calculation of the formula in the same
order Excel uses to solve it. When your formula includes a you must exit the Evaluate Formula dialog box to make
function, Excels solves for each argument of the function, and modifications. See the section "Edit Formulas" for more on
then solves the rest of the formula. For example, when you modifying the formulas in your worksheet.
apply the Evaluate button to the above example, Excel
changes the formula to display the value of the first argument:

EVALUATE A FORMULA

⁄ Click the cell containing ¤ Click Tools ➪ Formula ■ The Evaluate Formula ‹ Click Evaluate.
the formula to evaluate. Auditing ➪ Evaluate Formula. dialog box displays.

64