Microsoft Office Tutorials and References

In Depth Information

**The Range Name Game**

2. Place the cell cursor in the cell where the formula is to appear.

For this example, put the cell cursor in cell K3.

3. Type
(equal sign) to start the formula.
=

4. Select the first cell referenced in the formula by selecting its cell

(either by clicking the cell or moving the cell cursor into it).

For this example, you select the Hours cell by selecting cell I3.

5. Type the arithmetic operator to use in the formula.

For this example, you would type
(asterisk) for multiplication. (Refer
*

to Chapter 2 for a list of the other arithmetic operators.)

6. Select the second cell referenced in the formula by selecting its cell

(either by clicking the cell or moving the cell cursor into it).

For this example, you select the Rate cell by selecting cell J3.

7. Click the Enter button or press Enter to complete the formula.

In this example, Excel enters the formula =Hours*Rate in cell K3.

You can’t use the fill handle to copy a formula that uses cell names, rather

than cell addresses, to other cells in a column or row that perform the same

function (see Chapter 4). When you copy an original formula that uses names

rather than addresses, Excel copies the original formula without adjusting the

cell references to the new rows and columns. See the upcoming “Naming

constants” section to find a way to use your column and row headings to

identify the cell references in the copies, and include the original formula from

which the copies are made.

Naming constants

Certain formulas use constant values, such as an 8.25% tax rate or a 10%

discount rate. If you don’t want to have to enter these constants into a cell of

the worksheet in order to use the formulas, you create range names that hold

their values and then use their range names in the formulas you create.

For example, to create a constant called
tax_rate
(of 8.25%), follow these

steps:

1. Click the Define Name button on the Ribbon’s Formulas tab or press

Alt+MMD to open the New Name dialog box.

2. In the New Name dialog box, type the range name (
tax_rate
in this

example) into the Name text box.