Datasheet

21
Chapter 1: Tapping into Formula and Function Fundamentals
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.
Figure 1-14:
Entering a
formula that
references
cells.
8. Enter a +.
9. Click the cell that has the second entered value.
In this example, this is cell B6. The formula in cell E3 now looks like this:
=B3 + B6. You can see this is Figure 1-15.
10. Press Enter.
This ends the entry of the function. All done! Congratulations!
Figure 1-16 shows how the example ended up. Cell E3 displays the result of
the calculation. Also notice that the Formula Bar displays the contents of cell
E3, which really is the formula.
05_568163-ch01.indd 2105_568163-ch01.indd 21 4/2/10 1:37 PM4/2/10 1:37 PM