Microsoft Office Tutorials and References
In Depth Information
Tip 32: Using Named Constants
Using Named Constants
This tip describes a useful technique that can remove some clutter from your worksheets: named
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 store your sales tax rate by using a name (and avoid using a cell). Figure 32-1 demonstrates
the following steps:
1. Choose Formulas➜Defined Names➜Define Name to open the New Name dialog box.
2. Type the name (in this case, SalesTax ) into the Name field.
3. Specify Workbook as the scope for the name. If you want the name to be valid only on a
particular worksheet, specify the worksheet in the Scope field of the New Name dialog box.
4. Click the Refers To field, delete its contents, and replace it with a simple formula, such as
5. Click OK to close the dialog box.
Figure 32-1: Defining a name that refers to a constant.