| ABS |
Returns the absolute value of a number. |
| ACOS |
Returns the arccosine of a number in radians in the range 0 to pi. |
| ACOSH |
Returns the inverse hyperbolic cosine of a number. |
| ASIN |
Returns the arcsine of a number in radians in the range -pi/2 to pi/2. |
| ASINH |
Returns the inverse hyperbolic sine of a number. |
| ATAN |
Returns the arctangent of a number in radians in the range -pi/2 to pi/2 |
| ATAN2 |
Returns the four-quadrant arctangent of the specified x- and y- coordinates in radians between -pi and pi excluding -pi. A positive result represents a counterclockwise angle from the x-axis, a negative result represents a clockwise angle. |
| ATANH |
Returns the inverse hyperbolic tangent of a number. |
| CEILING |
Returns a number rounded up, away from zero, to the nearest multiple of significance. |
| COMBIN |
Returns the number of combinations for a given number of items. |
| COS |
Returns the cosine of the given angle. |
| COSH |
Returns the hyperbolic cosine of a number. |
| DEGREES |
Converts radians into degrees. |
| EVEN |
Returns a number rounded up to the next even integer for positive integers and rounded down to the next even integer for negative numbers. |
| EXP |
Returns e (2.71828182845804) raised to the power of a specified number. |
| FACT |
Returns the factorial of a number. |
| FLOOR |
Returns a number rounded down, toward zero, to the nearest multiple of significance. |
| INT |
Rounds a number down to the nearest integer. |
| LN |
Returns the natural (base e) logarithm of a number. |
| LOG |
Returns the logarithm of a number of the base you specify. |
| LOG10 |
Returns the base-10 logarithm of a number. |
| MDETERM |
Returns the matrix determinant of an array. |
| MINVERSE |
Returns the inverse matrix for the matrix stored in an array. |
| MMULT |
Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. |
| MOD |
Returns the remainder of a division operation (modulus). |
| ODD |
Returns a number rounded up away from zero to the nearest odd integer. |
| PI |
Returns the approximate number 3.14159265358979, the mathematical constant pi, accurate to 15 digits. |
| POWER |
Returns the result of a specified number raised to a specified power. |
| PRODUCT |
Multiplies all the numbers given as arguments and returns the product. |
| RADIANS |
Converts degrees to radians. |
| RAND |
Returns an evenly distributed random number greater than or equal to 0 and less than 1. A new random number is returned every time the worksheet is calculated. |
| ROMAN |
Converts an Arabic numeral to Roman, as text. |
| ROUND |
Round a number to a specified number of digits. |
| ROUNDDOWN |
Rounds a number down, towards zero. |
| ROUNDUP |
Rounds a number up, away from zero. |
| SIGN |
Determines the sign of a number. Returns 1 if the value is positive, 0 if the value is 0, and -1 if the value is negative. |
| SIN |
Returns the sine of a given angle. |
| SINH |
Returns the hyperbolic sine of a number. |
| SQRT |
Returns a positive square root. |
| SUM |
Adds all the numbers in a range of cells. |
| SUMIF |
Adds the cells specified by a certain criteria. |
| SUMPRODUCT |
Multiplies corresponding components in the given arrays, and returns the sum of those products. |
| 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 the given angle. |
| TANH |
Returns the hyperbolic tangent of a number. |
| TRUNC |
Truncates a number to an integer by removing the fractional part of a number. |