Microsoft Office Tutorials and References

In Depth Information

**Evaluating Part of a Formula**

mula. The following component of the formula is highlighted: It is the

next section of the formula to be calculated.

33. If desired, click Evaluate to calculate the highlighted portion of the

formula.

44. Click Step In to begin a new Evaluate section for the cell references

in the underlined portion of the formula.
Figure 9.31
shows the Evalu-

ate Formula dialog after stepping in to the E30 portion of the formula.

Figure 9.31.

Figure 9.31.
The Evaluate Formula dialog enables you to calculate a for-

The Evaluate Formula dialog enables you to calculate a for-

mula in slow motion.

mula in slow motion.

Evaluating Part of a Formula

When you do not need to evaluate an entire formula, use the Evaluate For-

mula feature. Follow these steps to evaluate part of a formula:

11. Use the mouse to select just the desired portion of the formula in the

formula bar, as shown in
Figure 9.32
.

Figure 9.32.

Figure 9.32.
You can select a portion of the formula in the formula bar.

You can select a portion of the formula in the formula bar.