Apple iWork '09 User Manual
Page 169
Chapter 8
Numeric Functions
169
Function
Description
The ROUND function returns a number rounded
to the specified number of places.
“ROUNDDOWN” (page 192)
The ROUNDDOWN function returns a number
rounded toward zero (rounded down) to the
specified number of places.
The ROUNDUP function returns a number
rounded away from zero (rounded up) to the
specified number of places.
The SIGN function returns 1 when a given
number is positive, –1 when it is negative, and 0
when it is zero.
The SQRT function returns the square root of a
number.
The SQRTPI function returns the square root of a
number multiplied by
π (pi).
The SUM function returns the sum of a collection
of numbers.
The SUMIF function returns the sum of a
collection of numbers, including only numbers
that satisfy a specified condition.
The SUMIFS function returns the sum of the cells
in a collection where the test values meet the
given conditions.
“SUMPRODUCT” (page 200)
The SUMPRODUCT function returns the sum of
the products of corresponding numbers in one or
more ranges.
The SUMSQ function returns the sum of the
squares of a collection of numbers.
The SUMX2MY2 function returns the sum of the
difference of the squares of corresponding values
in two collections.
The SUMX2PY2 function returns the sum of
the squares of corresponding values in two
collections.
The SUMXMY2 function returns the sum
of the squares of the differences between
corresponding values in two collections.
The TRUNC function truncates a number to the
specified number of digits.