Apple iWork '09 - Manual (Page 204)

SUMXMY2
The SUMXMY2 function returns the sum of the squares of the differences between
corresponding values in two collections.
SUMXMY2(set-1-values, set-2-values)
 set-1-values: The first collection of values. set-1-values is a collection containing
number values.
 set-2-values: The second collection of values. set-2-values is a collection containing
number values.
Example
Given the following table:
=SUMXMY2(A1:A6,B1:B6) returns 196, the sum of the squares of the values in column A and the
squares of the values in column B. The formula for the first such sum is (A1 – B1)
2 .
Related Topics
For related functions and additional information, see:
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
TRUNC
The TRUNC function truncates a number to the specified number of digits.
TRUNC(number, digits)
 number: A number. number is a number value.
 digits: An optional value specifying the number of digits you want to retain, relative
to the decimal point. digits is a number value. A positive number represents digits
(decimal places) to the right of the decimal point to include. A negative number
specifies digits to the left of the decimal point to replace with zeros (the number of
zeros at the end of the number).
204 Chapter 8 Numeric Functions