Microsoft Office Tutorials and References
In Depth Information
One More Example—If You Have a Ready Model
FIGURE 15.7 Formulas without Names
FIGURE 15.8 Creating Names in Excel 2003
FIGURE 15.9 Models with Names in Formulas
See Figure 15.8 for the way it is done.
Now look at the results in Figure 15.9.
One More Example
In the second example, we already have all the formulas. What we want to do is
change the formulas to reflect the names. See the sheet BEP Example no names in the
Chapter 15 Excel file. I want to change the names in the cells in column C. However,
I do not want to recreate the formulas after I change the names. See Figure 15.10 for