Microsoft Office Tutorials and References
In Depth Information
Defining and using range names in formulas
Dei ning and using range names in formulas
You can make your formulas easier to build and read by using range names as operands. For
example, it is clearer to display a formula as AVERAGE(Expenses) than AVERAGE(B2:B10).
Before you can use a range name in a formula, you have to dei ne the name.
To open the document you need for this lesson:
Choose File > Open and navigate to the Excel05lessons folder.
Click excel0506 and then click Open.
Select File > Save As.
In the Save As text i eld, type excel0506_done and then click Save.
To dei ne a range name:
Click in cell D3, and then click the Formulas tab. In the Dei ned Names group, click
Dei ne Name.
The i rst character of the name must be a letter or an underscore (_). The name cannot include
spaces or cell references and must be less than 255 characters.
In the New Name dialog box, type Discount_rate in the Name text i eld; type 15% in
the Refers to: text i eld, and then click OK.
Enter a name in the New Name dialog box.