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.
Search JabSto ::




Custom Search