Formulas and Functions

Chapter 8 Numeric Functions 169
Function Description
“ROUND” (page 191 ) The ROUND function returns a number rounded
to the specied number of places.
“ROUNDDOWN” (page 192 ) The ROUNDDOWN function returns a number
rounded toward zero (rounded down) to the
specied number of places.
“ROUNDUP” (page 193 ) The ROUNDUP function returns a number
rounded away from zero (rounded up) to the
specied number of places.
“SIGN” (page 195) The SIGN function returns 1 when a given
number is positive, –1 when it is negative, and 0
when it is zero.
“SQRT” (page 195) The SQRT function returns the square root of a
number.
“SQRTPI” (page 196 ) The SQRTPI function returns the square root of a
number multiplied by π (pi).
“SUM” (page 19 6) The SUM function returns the sum of a collection
of numbers.
“SUMIF” (page 197 ) The SUMIF function returns the sum of a
collection of numbers, including only numbers
that satisfy a specied condition.
“SUMIFS” (page 198) 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.
“SUMSQ” (page 201) The SUMSQ function returns the sum of the
squares of a collection of numbers.
“SUMX2MY2” (page 202) The SUMX2MY2 function returns the sum of the
dierence of the squares of corresponding values
in two collections.
“SUMX2PY2” (page 203) The SUMX2PY2 function returns the sum of
the squares of corresponding values in two
collections.
“SUMXMY2” (page 204) The SUMXMY2 function returns the sum
of the squares of the dierences between
corresponding values in two collections.
“TRUNC” (page 204) The TRUNC function truncates a number to the
specied number of digits.