Formulas and Functions

SUMXMY2
The SUMXMY2 function returns the sum of the squares of the dierences between
corresponding values in two collections.
SUMXMY2(set-1-values, set-2-values)
 set-1-values: The rst 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 rst 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 specied 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
species 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