Apple Numbers '09 - Manual (Page 130)

Here are ways to specify the absoluteness of cell reference components:
Type the cell reference using one of the conventions described above.
m
Click the disclosure triangle of a cell reference and choose an option from the m
pop-up menu.
Select a cell reference and press Command-K to cycle through options.
m
Using Operators in Formulas
Use operators in formulas to perform arithmetic operations and to compare values:
 Arithmetic operators perform arithmetic operations, such as addition and
subtraction, and return numerical results. See “The Arithmetic Operators” on
page 130 to learn more.
 Comparison operators compare two values and return TRUE or FALSE. See “The
Comparison Operators” on page 130 to learn more.
The Arithmetic Operators
You can use arithmetic operators to perform arithmetic operations in formulas.
When you want to Use this arithmetic operator For example, if A2 contains 20
and B2 contains 2, the formula
Add two values + (plus sign) A2 + B2 returns 22.
Subtract one value from
another value – (minus sign) A2 – B2 returns 18.
Multiply two values * (asterisk) A2 * B2 returns 40.
Divide one value by another
value / (forward slash) A2 / B2 returns 10.
Raise one value to the power
of another value ^ (caret) A2 ^ B2 returns 400.
Calculate a percentage % (percent sign) A2% returns 0.2, formatted for
display as 20%.
Using a text string with an arithmetic operator returns an error. For example, 3 + “hello”
is not a correct arithmetic operation.
The Comparison Operators
You can use comparison operators to compare two values in formulas. Comparison
operations always return the values TRUE or FALSE.
130 Chapter 6 Using Formulas in Tables