Problem: You’ve seen how you can assign a name to a cell. It is also possible to assign a name to a constant. This could be useful if you have a number, such as a local sales tax rate, that changes once a year.
See all Microsoft Excel tips
In this workbook, you can now use a formula such as =SalesTax*D2, as shown in Fig. 213.
If the tax rate changes later use Insert – Name – Define to change the constant assigned to the name.
Summary: To name a constant in a workbook use Insert – Name – Define, type in the name of the constant, and then define the constant in the Refers to: box.
Commands Discussed: Insert – Name – Define
See all Microsoft Excel tips
