Microsoft Office Tutorials and References
In Depth Information
The Secret to Understanding Names
At this point, you may be wondering whether it’s possible to create a named formula that doesn’t
contain any cell references. The answer comes in the next section.
Consider a worksheet that generates an invoice and calculates sales tax for a sales amount. The
common approach is to insert the sales tax rate value into a cell and then use this cell reference
in your formulas. To make things easier, you probably would name this cell something like
You can handle this situation another way. Figure 3-17 demonstrates the following steps:
1. Choose Formulas
Define Name to bring up the New Name dialog box.
2. Type the name (in this case, SalesTax ) into the Name field.
3. Click in the Refers To field, delete its contents and replace it with a simple formula, such
as =.075 .
4. Click OK to close the New Name dialog box.
Figure 3-17: Defining a name that refers to a constant.
The preceding steps create a named formula that doesn’t use any cell references. To try it out,
enter the following formula into any cell:
This simple formula returns .075, the result of the formula named SalesTax. Because this named
formula always returns the same result, you can think of it as a named constant. And you can use
this constant in a more complex formula, such as the following:
If you didn’t change the scope from the default of Workbook, you can use SalesTax in any
worksheet in the workbook.