FOLLOW

FOLLOW

SHARE

What’s in a Name?

How to assign a name to a constant in Microsoft Excel.

21Mar

Q: I’ve seen how to assign a name to a cell. Is it also possible to assign a name to a constant? That could be useful for a number, such as a local sales tax rate, that changes periodically.

A: To assign names to constants, follow these steps:

1. Select Formula, Define Name.

2. In the New Name dialog, type a name such as SalesTax in the Name text box. In the Refers To box, type 0.065 and then click OK.

3. In this workbook, you can now use a formula such as =SalesTax*D2.

4. If the tax rate changes later, select Formulas, Name Manager. In the Name Manager, select the constant’s name and click Edit.

If you would like to submit a question to Bill “MrExcel” Jelen, e-mail him at billjelen@cfo.com.

Comments

comments powered byDisqus
Wrestlingring

Read next:

Becoming a Value Integrator: A CFO Journey

i