Microsoft Office Tutorials and References

In Depth Information

**Working with Formulas**

Chapter 9

Working with Formulas and Functions

5.
Type the reference to the second cell of the

formula. Excel references the second cell

address in a different color and places a

matching color box around the referenced

address.

Tip

When you have a compound formula, Excel

will do the multiplication and division first,

and then the addition and subtraction. If

you want a certain portion of the formula

to be calculated first, put it in parentheses.

Excel will do whatever is in the parentheses

before the rest of the formula. For

example, the formula =B11-B19*A23 will give a

different answer than =(B11-B19)*A23. It’s

the old school rule called “Rule of

Priorities” or “Order of Precedence”.

6.
Press the Enter key. The result of the

calculation appears in the cell (see Figure 9-2).

Actual formula Results

In the cell where you want the formula answer,

type an equals sign (=) to begin the formula and

type the reference to the first cell of the formula.

Next, type the operator and then type the

reference to the second cell of the formula. Type the

next operator and then the reference to the third

cell of the formula. Repeat adding operators and

references until the formula is complete, adding

parentheses wherever necessary. Press Enter to

accept the formula. Figure 9-3 illustrates a cell

with a compound formula.

Figure 9-2

The calculation results.

Tip

Notice how the result appears in the cell,

but the actual formula, =B5+C5, appears

in the Contents box of the Edit line.

Actual formula Results

Creating a Compound Formula

You use compound formulas when you need more

than one operator. Examples of a compound

formula might be =B7+B8+B9+B10 or =G4*H2+A16.

Figure 9-3

A compound formula.

If you are following the examples in this topic, try

changing one of the values you originally typed in

the worksheet and watch the answer to the formula

change.