Page 350 - Excel 2013 All-in-One For Dummies

332 Range Names in Formulas
Figure 1-16:
Using the options in the Apply Names dialog box to assign range names to formulas.
After applying all the range names by using the default Apply Names options (that is, Ignore Relative/Absolute, Use Row and Column Names, Omit Column Name If Same Column, Omit Row Name If Same Row, and Name Order options selected), Excel replaces all the cell references in the formulas in the Sale Price table. In cell E3, for example, in place of the original formula, =C3–D3, the cell now contains the formula
=Retail_Price–Discount
Cell D3, to the immediate left, instead of =C3*discount_rate now contains:
=Retail_Price*discount_rate
Only one problem occurs with applying names by using the default settings. This problem begins to show up as soon as you select cell E4. Although this formula subtracts cell D4 from C4, its contents now also appear as
=Retail_Price–Discount
This is identical in appearance to the contents of cell E3 above (and, in fact, identical in appearance to cells E5, E6, and E7 in the cells below).