Understanding the arithmetic operators – Apple Numbers '08 User Manual
Page 95
Chapter 5
Using Formulas and Functions in Tables
95
Understanding the Arithmetic Operators
Arithmetic operators in table cell formulas perform arithmetic operations and return
numerical results.
Here are the arithmetic operators (examples presume that cell A2 contains 20 and
that B2 contains 2):
m
The operator + returns the sum of two values.
For example, A2 + B2 returns 22.
m
The operator – returns the difference between two values.
For example A2 – B2 returns 18.
m
The operator * returns the product of two values.
For example, A2 * B2 returns 40.
m
The operator / returns the result of dividing one value by another value.
For example, A2/B2 returns 10.
m
The operator ^ returns the result of raising one value to the power of another value.
For example, A2 ^ B2 returns 400.
m
The operator % returns the result of dividing a value by 100.
For example, A2% returns 0.2, formatted for display as 20%.
When a cell reference points to an empty cell, 0 is the value used.
When a cell reference points to a cell containing FALSE, 0 is used. If the cell contains
TRUE, 1 is used. For example, TRUE + 1 returns 2.
Using a string with an arithmetic operator returns an error. For example, 3 + "hello" is
not a correct arithmetic operation.