Apple Numbers '09 - Manual (Page 131)

Chapter 6 Using Formulas in Tables 131
When you want to determine
whether Use this comparison operator For example, if A2 contains 20
and B2 contains 2, the formula
Two values are equal = A2 = B2 returns FALSE.
Two values aren’t equal <> A2 <> B2 returns TRUE.
The first value is greater than
the second value > A2 > B2 returns TRUE.
The first value is less than the
second value < A2 < B2 returns FALSE.
The first value is greater than
or equal to the second value >= A2 >= B2 returns TRUE.
The first value is less than or
equal to the second value <= A2 <= B2 returns FALSE.
Text strings are larger than numbers. For example, “hello” > 5 returns TRUE.
TRUE and FALSE can be compared with each other, but not with numbers or text
strings. TRUE > FALSE, and FALSE < TRUE, because TRUE is interpreted as 1 and FALSE is
interpreted as 0. TRUE = 1 returns FALSE, and TRUE = “SomeText” returns FALSE.
Comparison operations are used primarily in functions such as IF, which compare two
values and then perform other operations depending on whether the comparison
returns TRUE or FALSE. For more information about this topic, choose Help > iWork
Formulas and Functions Help or Help > iWork Formulas and Functions User Guide.
Copying or Moving Formulas and Their Computed Values
Here are techniques for copying and moving cells related to a formula:
To copy the computed value in a formula cell but not the formula, select the cell,
m
choose Edit > Copy, select the cell you want to hold the value, and then choose Edit >
Paste Values.
To copy or move a formula cell or a cell that a formula refers to, follow the instructions
m
in “Copying and Moving Cells” on page 88.
If the table is large and you want to move the formula to a cell that’s out of view, select
the cell, choose Edit > “Mark for Move,” select the other cell, and then choose Edit >
Move. For example, if the formula =A1 is in cell D1 and you want to move the same
formula to cell X1, select D1, choose Edit > “Mark for Move,” select X1, and then choose
Edit > Move. The formula =A1 appears in cell X1.
If you copy or move a formula cell, change cell references, as “Distinguishing Absolute
and Relative Cell References” on page 129 describes, if needed.