Microsoft Office Tutorials and References
In Depth Information
Use a constant whenever you want to use the same
value in different cells and/or formulas. With
constants, you can refer to a value, whether it is
simple or consists of many digits, by simply using
the constant’s name.
You can use constants in many applications. For
example, sales tax rate is a familiar constant that,
when multiplied by the subtotal on an invoice, results
in the tax owed. Likewise, income tax rates are the
constants used to calculate tax liabilities. Although
tax rates change from time to time, they tend to
remain constant within a tax period.
To create a constant in Excel, you need to type its
value in the New Name dialog box, the same dialog
box you use to name ranges as shown in Task #11.
When you define a constant, you determine the
scope of the constant by telling Excel whether it
applies to the current worksheet or the entire
workbook. To use the constant in any formula in the
same workbook, simply use the name you defined.
D EFINE A C ONSTANT
Click the Formulas tab.
Click Define Name.
The New Name dialog box
Type a name for the constant.
Click here and select the scope of
Type an equal sign (=) followed
by the constant’s value.
You can now use the constant.