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




Custom Search