math functions
arithmetic, rounding, trigonometry and aggregation.
| function | signature | what it does | tests |
|---|---|---|---|
| ABS | ABS(number) | returns absolute value of a number | 1 |
| ACOS | ACOS(number) | returns arccosine of a number | — |
| ACOSH | ACOSH(number) | returns inverse hyperbolic cosine | — |
| ACOT | ACOT(number) | returns the arccotangent of a number | — |
| ACOTH | ACOTH(number) | returns the inverse hyperbolic cotangent | — |
| ARABIC | ARABIC(text) | converts roman numeral to arabic number | — |
| ASIN | ASIN(number) | returns arcsine of a number | — |
| ASINH | ASINH(number) | returns inverse hyperbolic sine | — |
| ATAN | ATAN(number) | returns arctangent of a number | — |
| ATAN2 | ATAN2(x_num, y_num) | returns arctangent from x and y coordinates | — |
| ATANH | ATANH(number) | returns inverse hyperbolic tangent | — |
| AVERAGE | AVERAGE(number…) | calculates arithmetic mean | 2 |
| BASE | BASE(number, radix, [min_length]) | converts number to text in given base | — |
| CEILING | CEILING(number, significance) | rounds up to the nearest multiple of significance | 1 |
| CEILING.MATH | CEILING.MATH(number, [significance], [mode]) | rounds up with optional significance and mode | — |
| CEILING.PRECISE | CEILING.PRECISE(number, [significance]) | rounds up to the nearest multiple, sign-independent | — |
| CHOOSE | CHOOSE(index_num, value…) | chooses a value from a list by index | 2 |
| COLUMN | COLUMN([reference]) | returns column number of a reference | 5 |
| COLUMNS | COLUMNS(array) | returns number of columns in a reference | — |
| COMBIN | COMBIN(number, number_chosen) | number of combinations of n items taken k at a time | — |
| COMBINA | COMBINA(number, number_chosen) | combinations with repetitions | — |
| COS | COS(number) | returns cosine of an angle | — |
| COSH | COSH(number) | returns hyperbolic cosine | — |
| COT | COT(number) | returns cotangent of an angle | — |
| COTH | COTH(number) | returns hyperbolic cotangent | — |
| CSC | CSC(number) | returns cosecant of an angle | — |
| CSCH | CSCH(number) | returns hyperbolic cosecant | — |
| DECIMAL | DECIMAL(text, radix) | converts text in given base to number | — |
| DEGREES | DEGREES(angle) | converts radians to degrees | — |
| EVEN | EVEN(number) | rounds up to the nearest even integer | 1 |
| EXP | EXP(number) | e raised to the power of a number | — |
| FACT | FACT(number) | factorial of a number | — |
| FACTDOUBLE | FACTDOUBLE(number) | returns double factorial of a number | — |
| FLOOR | FLOOR(number, significance) | rounds down to the nearest multiple of significance | — |
| FLOOR.MATH | FLOOR.MATH(number, [significance], [mode]) | rounds down with optional significance and mode | — |
| FLOOR.PRECISE | FLOOR.PRECISE(number, [significance]) | rounds down to the nearest multiple, sign-independent | — |
| GAMMA | GAMMA(number) | returns the gamma function value | 1 |
| GCD | GCD(number…) | greatest common divisor | — |
| INT | INT(number) | rounds down to the nearest integer | — |
| ISO.CEILING | ISO.CEILING(number, [significance]) | rounds up to the nearest multiple, sign-independent | — |
| LCM | LCM(number…) | least common multiple | — |
| LN | LN(number) | natural logarithm of a number | — |
| LOG | LOG(number, [base]) | logarithm to a given base | — |
| LOG10 | LOG10(number) | base-10 logarithm of a number | — |
| MAX | MAX(number…) | returns the largest value in a set | 3 |
| MDETERM | MDETERM(array) | returns matrix determinant of an array | — |
| MIN | MIN(number…) | returns the smallest value in a set | 3 |
| MINVERSE | MINVERSE(array) | returns matrix inverse of an array | — |
| MMULT | MMULT(array1, array2) | returns the matrix product of two arrays | — |
| MOD | MOD(number, divisor) | remainder after division | — |
| MROUND | MROUND(number, multiple) | rounds to the nearest multiple | — |
| MULTINOMIAL | MULTINOMIAL(number…) | returns the multinomial coefficient of a set of numbers | — |
| MUNIT | MUNIT(dimension) | returns identity matrix of given size | — |
| ODD | ODD(number) | rounds up to the nearest odd integer | 1 |
| PI | PI() | returns the value of pi | — |
| POWER | POWER(number, power) | returns number raised to a power | 2 |
| PRODUCT | PRODUCT(number…) | multiplies all numbers given as arguments | — |
| QUOTIENT | QUOTIENT(numerator, denominator) | integer portion of a division | — |
| RADIANS | RADIANS(angle) | converts degrees to radians | — |
| RAND | RAND() | returns a random number between 0 and 1 | — |
| RANDBETWEEN | RANDBETWEEN(bottom, top) | returns random integer between two values | — |
| ROMAN | ROMAN(number, [form]) | converts arabic number to roman numeral | — |
| ROUND | ROUND(number, num_digits) | rounds a number to specified digits | 4 |
| ROUNDDOWN | ROUNDDOWN(number, num_digits) | rounds a number down toward zero | — |
| ROUNDUP | ROUNDUP(number, num_digits) | rounds a number up away from zero | — |
| SEC | SEC(number) | returns secant of an angle | — |
| SECH | SECH(number) | returns hyperbolic secant | — |
| SERIESSUM | SERIESSUM(x, n, m, coefficients) | returns the sum of a power series | — |
| SIGN | SIGN(number) | sign of a number as -1, 0 or 1 | — |
| SIN | SIN(number) | returns sine of an angle | — |
| SINH | SINH(number) | returns hyperbolic sine | — |
| SQRT | SQRT(number) | returns square root of a number | 1 |
| SQRTPI | SQRTPI(number) | returns square root of number times pi | — |
| SUM | SUM(number…) | adds numbers together | 35 |
| SUMIF | SUMIF(range, criteria, [sum_range]) | sums cells that match a condition | 3 |
| SUMIFS | SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2…], [criteria2…]) | sums cells that match multiple conditions | 1 |
| SUMPRODUCT | SUMPRODUCT(array…) | returns sum of products of array components | — |
| SUMSQ | SUMSQ(number…) | sum of the squares of the arguments | — |
| SUMX2MY2 | SUMX2MY2(array_x, array_y) | sum of the difference of squares of two ranges | — |
| SUMX2PY2 | SUMX2PY2(array_x, array_y) | sum of the sum of squares of two ranges | — |
| SUMXMY2 | SUMXMY2(array_x, array_y) | sum of squared differences of two ranges | — |
| TAN | TAN(number) | returns tangent of an angle | — |
| TANH | TANH(number) | returns hyperbolic tangent | — |
| TRUNC | TRUNC(number, [num_digits]) | truncates a number to a given precision | — |