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.
Naming constants
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
SalesTax.
You can handle this situation another way. Figure 3-17 demonstrates the following steps:
1. Choose Formulas
Defined Names
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:
=SalesTax
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:
=A1*SalesTax
If you didn’t change the scope from the default of Workbook, you can use SalesTax in any
worksheet in the workbook.
 
Search JabSto ::




Custom Search