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.
Search JabSto ::




Custom Search