Microsoft Office Tutorials and References

In Depth Information

Click the Evaluate button to show the result of calculating the expressions within the formula. Each click of the

button evaluates the underlined portion of the formula. 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:

1.
Select the cell that contains the formula.

2.
Press F2 to get into cell edit mode.

3.
Use your mouse to highlight the portion of the formula that you want to evaluate. Or, press Shift and use the

arrow keys.

4.
Press F9.

The highlighted portion of the formula displays the calculated result. You can evaluate other parts of the for-

mula 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.