3

118 Chapter 5 Creating Tables
For example, to refer to nine cells in column A (A2 through A10), you could drag from
cell A2 to cell A10. You can also:
a Click or type A2.
b Type a colon.
c Click or type A10.
5 Click the Accept button or press Return or Enter to save the formula.
Operators and Functions for Advanced Users
After becoming familiar with the Formula Editor and cell references, you can create a
wide variety of formulas.
This section fully describes the operators and functions that you can include in your
formulas when you type them in the text field of the Formula Editor.
Defining Formulas That Use Operators
You use operators in formulas when you want to perform arithmetic or comparison
operations:
 A2 + A3: This formula adds the values in two cells of the first column.
 A2 > B6: This formula determines whether the value in cell A2 is larger than the
value in cell B6. If it is, the result is TRUE; otherwise, it is FALSE.
Arithmetic operators perform arithmetic operations and return numerical results.
This operator Returns
Example (A2 contains 20 and
B2 contains 2)
+ The sum of two values A2+B2 returns 22
– The difference between two
values
A2–B2 returns 18
* The product of two values A2*B2 returns 40