| Function
| Description
|
| ABS
| Returns the absolute value of a number
|
| ACOS
| Returns the arccosine of a number
|
| ACOSH
| Returns the inverse hyperbolic cosine of a number
|
| ASIN
| Returns the arcsine of a number
|
| ASINH
| Returns the inverse hyperbolic sine of a number
|
| ATAN
| Returns the arctangent of a number
|
| ATAN2
| Returns the arctangent from x- and y-coordinates
|
| ATANH
| Returns the inverse hyperbolic tangent of a number
|
| CEILING
| Rounds a number to the nearest integer or to the nearest multiple of significance
|
| COMBIN
| Returns the number of combinations for a given number of objects
|
| COS
| Returns the cosine of a number
|
| COSH
| Returns the hyperbolic cosine of a number
|
| DEGREES
| Converts radians to degrees
|
| EVEN
| Rounds a number up to the nearest even integer
|
| EXP
| Returns e raised to the power of a given number
|
| FACT
| Returns the factorial of a number
|
| FACTDOUBLE
| Returns the double factorial of a number
|
| FLOOR
| Rounds a number down, toward zero
|
| GCD
| Returns the greatest common divisor
|
| INT
| Rounds a number down to the nearest integer
|
| LCM
| Returns the least common multiple
|
| LN
| Returns the natural logarithm of a number
|
| LOG
| Returns the logarithm of a number to a specified base
|
| LOG10
| Returns the base-10 logarithm of a number
|
| MDETERM
| Returns the matrix determinant of an array
|
| MINVERSE
| Returns the matrix inverse of an array
|
| MMULT
| Returns the matrix product of two arrays
|
| MOD
| Returns the remainder from division
|
| MROUND
| Returns a number rounded to the desired multiple
|
| MULTINOMIAL
| Returns the multinomial of a set of numbers
|
| ODD
| Rounds a number up to the nearest odd integer
|
| PI
| Returns the value of pi
|
| POWER
| Returns the result of a number raised to a power
|
| PRODUCT
| Multiplies its arguments
|
| QUOTIENT
| Returns the integer portion of a division
|
| RADIANS
| Converts degrees to radians
|
| RAND
| Returns a random number between 0 and 1
|
| RANDBETWEEN
| Returns a random number between the numbers you specify
|
| ROMAN
| Converts an arabic numeral to roman, as text
|
| ROUND
| Rounds a number to a specified number of digits
|
| ROUNDDOWN
| Rounds a number down, toward zero
|
| ROUNDUP
| Rounds a number up, away from zero
|
| SERIESSUM
| Returns the sum of a power series based on the formula
|
| SIGN
| Returns the sign of a number
|
| SIN
| Returns the sine of the given angle
|
| SINH
| Returns the hyperbolic sine of a number
|
| SQRT
| Returns a positive square root
|
| SQRTPI
| Returns the square root of (number * pi)
|
| SUBTOTAL
| Returns a subtotal in a list or database
|
| SUM
| Adds its arguments
|
| SUMIF
| Adds the cells specified by a given criteria
|
| SUMIFS
| Adds the cells in a range that meet multiple criteria
|
| SUMPRODUCT
| Returns the sum of the products of corresponding array components
|
| SUMSQ
| Returns the sum of the squares of the arguments
|
| SUMX2MY2
| Returns the sum of the difference of squares of corresponding values in two arrays
|
| SUMX2PY2
| Returns the sum of the sum of squares of corresponding values in two arrays
|
| SUMXMY2
| Returns the sum of squares of differences of corresponding values in two arrays
|
| TAN
| Returns the tangent of a number
|
| TANH
| Returns the hyperbolic tangent of a number
|
| TRUNC
| Truncates a number to an integer |