Microsoft Office Tutorials and References
In Depth Information
Figure 3-18: 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 follow-
ing 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 com-
plex 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.
Naming text constants
In the preceding example, the constant consisted of a numeric value. A constant can also consist of text. For ex-
ample, you can define a constant for a company's name. You can use the New Name dialog box to create the
following formula named MS:
=”Microsoft Corporation”
Then you can use a cell formula, such as the following:
=”Annual Report: “&MS
This formula returns the text Annual Report: Microsoft Corporation.
Names that do not refer to ranges do not appear in the Name box or in the Go To dialog
box (which appears when you press F5). This makes sense because these constants
Search JabSto ::




Custom Search