Microsoft Office Tutorials and References
In Depth Information
Using Range Names
In Chapter 1, “Creating a Basic Excel Worksheet,”
you learned how to name a cell or range of cells
with a range name. If you plan on referring to a
special cell in several formulas, you can give it a
name such as Gross_Pay. Then, to calculate the
Social Security tax (which is currently 6.2%),
you could use this formula: =Gross_Pay*.062.
5. Click the next cell you want to reference in
the formula, or type its address. For example,
click cell C12. Excel places a differently
colored box around this new cell, and uses that
same color for the cell address shown in the
Formula bar. You can type a value (such as
1.35) instead of referencing a cell if you want;
for example, you might type =D25*.07 to
calculate a 7% sales tax on an invoice total.
6. Press Enter to complete the formula. The
result of the calculation appears in the cell
you selected in Step 1.
To calculate the amount of 401(k) withholding
(assuming the employee wants to save 4% of his
pay), you could use the formula =Gross_Pay*.04.
To quickly name a cell, click it, type a range name
in the Name box at the left end of the Formula
bar (see Figure 2-4), and then press Enter.
If you start typing a formula but no longer
want to enter it, press Esc or click the
Cancel button on the Formula bar (the X).
A formula does not need to contain cell references,
as you know. In fact, a formula can contain only
constants if you want, thus having Excel act like
a sort of calculator. For example, you might type
=387*.0024 in a cell. After you press Enter, Excel
provides the answer, just like any other calculator:
Use named ranges in your formulas to make
it easier to reference the right cells.