Owner manual

Chapter 8 Creating Tables 193
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 Table Formula Users
After becoming familiar with the Formula Editor and cell references, you can create a
wide variety of formulas.
The remainder of this chapter 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 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