Microsoft Office Tutorials and References

In Depth Information

**Creating Formulas**

Using Range Names

in Formulas

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.

Tip

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).

Name Box

Range Name

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:

0.9288.

Figure 2-4

Use named ranges in your formulas to make

it easier to reference the right cells.