Datasheet

That was easy, wasn’t it? You should see the result of the formula — the
number 20.
Try another. This time you create a formula that adds together the value of
two cells:
1. Click any cell.
2. Type in any number.
3. Click another cell.
4. Type in another number.
5. Click a third cell.
This cell will contain the formula.
6. Type a =.
7. Click the first cell.
This is an important point in the creation of the formula. The formula
is being written by both your keyboard entry and clicking around with
the mouse. The formula should look about half complete, with an equal
sign immediately followed by the address of the cell you just clicked.
Figure 1-14 shows what this looks like. In the example, the value
15 has
been entered into cell B3 and the value
35 into cell B6. The formula was
started in cell E3. Cell E3 so far has
=B3 in it.
8. Enter a +.
Figure 1-14:
Entering a
formula that
references
cells.
21
Chapter 1: Tapping into Formula and Function Fundamentals
05_046555 ch01.qxp 12/26/06 7:54 PM Page 21