Juniper Systems Allegro CX Manual - Manual (Page 151)

Allegro CX Owner’s Manual 151
Sum(number, number, ...)
Return the sum of all the numbers in the list of arguments.
Example: Sum(10, 20) equals 30.
SumIf(range, criteria, sumRange)
It sums up the values of only those cells from the sumRange for
which the corresponding cells in the range satisfy the criteria.
Example: Sumif(A1:A5,”>100000”,B1:B5).
Sumproduct(reference1, reference2, ...)
Multiplies corresponding numeric components in given ranges and
returns the sum of those products.
Sumsq(number, number, ...)
Returns the sum of squares of the arguments.
Sumx2my2(reference1, reference2)
Calculates the difference between the squares of corresponding
numbers in two ranges and then returns the sum of squares of the
differences.
Sumx2py2(reference1, reference2)
Calculates the sum of the squares of corresponding numbers in two
ranges and then returns the sum total of the sums.
Sumxmy2(reference1, reference2)
Calculates the differences of corresponding values in two ranges and
returns the sum of squares of the differences.
Tan(number)
Returns the tangent of the given angle.
Example: Tan(5) equals -3.38051.
Tanh(number)
Returns the hyperbolic tangent of the number.
Example: Tanh(1) equals 0.76159.
Trunc(number, numDigits)
Truncates the number to an integer. The argument numDigits is the
precision of the truncation. The default value for the numDigits is 0.
Example: Trunc(-7.8) equals -7.