Programmming Overview > Supported Formula Functions
For further informations about argument types, restrictions and return values please see Office Open XML File Formats - ISO/IEC 29500 - 1, Chapter: 18.17.7 Predefined Function Definitions.
| Function | Description | |
| ABS(x) | Computes the absolute value of x. | |
| ACOS(x) | Computes the arc cosine of x. | |
| ACOSH(x) | Computes the inverse hyperbolic cosine of x. | |
| ASIN(x) | Computes the arc sine of x. | |
| ASINH(x) | Computes the inverse hyperbolic sine of x. | |
| ATAN(x) | Computes the arc tangent of x. | |
| ATAN2(x,y) | Computes the arc tangent of the coordinates x and y. | |
| ATANH(x) | Computes the inverse hyperbolic tangent of x. | |
| CEILING(x,significance) | Computes a value that is x rounded-up, away from zero, to the nearest multiple of significance. Regardless of the sign of x, a value is rounded up when adjusted away from zero. | |
| COMBIN(number,number-chosen ) | Computes the possible number of groups of size number-chosen that can be formed from number objects. | |
| COS(x) | Computes the cosine of x. | |
| COSH(x) | Computes the hyperbolic cosine of x. | |
| DEGREES(angle) | Converts angle in radians into degrees. | |
| ECMA.CEILING(x,significance) | Computes a value that is x rounded-up, away from zero, to the nearest multiple of significance. Regardless of the sign of x, a value is rounded up when adjusted away from zero. | |
| EVEN(x) | Computes x rounded to the nearest even integer, away from zero. Regardless of the sign of x, a value is rounded up when adjusted away from zero. | |
| EXP(x) | Computes e^x, where the constant e is the base of the natural logarithm. | |
| FACT(x) | Computes the factorial of x. | |
| FACTDOUBLE(n) | Computes the double factorial of n. | |
| FLOOR(x,significance) | Computes x rounded down, toward zero, to the nearest multiple of significance. Regardless of the sign of x, a value is rounded down when adjusted away from zero. | |
| GCD(argument-list) | Computes the greatest common divisor of the one or more numbers, designated by arguments in argument-list. | |
| INT(x) | Computes x rounded down to an integer. | |
| ISO.CEILING(x[,significance]) | Computes a value that is x rounded-up, to the nearest multiple of significance. Regardless of the sign of x, a value is rounded up.If significance is omitted, its default value is 1. | |
| LCM(argument-list) | Computes the least common multiple of the one or more arguments in argument-list. | |
| LN(x) | Computes the natural logarithm of x. | |
| LOG(x[,base]) | Computes the logarithm of x to the specified base. If the base is omitted, base 10 is assumed. | |
| LOG10(x) | Computes the base-10 logarithm of x. | |
| MOD(x,y) | Computes the remainder when x is divided by y. The result has the same sign as y. | |
| MROUND(x,multiple) | Computes x rounded to multiple, away from zero. It rounds up if the remainder of dividing x by multiple is greater than or equal to half the value of multiple; otherwise, it rounds down. | |
| MULTINOMIAL(argument-list) | Computes the ratio of the factorial of the sum of the values in argument-list to the product of the factorials. | |
| ODD(x) | Computes x rounded to the nearest odd integer, away from zero. Regardless of the sign of x, a value is rounded up when adjusted away from zero. | |
| PI() | Computes the value π. | |
| POWER(x,y) | Computes x raised to the power y. | |
| PRODUCT(argument-list) | Multiplies the numeric values of arguments in argument-list. | |
| QUOTIENT(dividend,divisor ) | Computes the integer portion of the division of dividend by divisor. | |
| RADIANS(angle) | Converts angle in degrees into radians. | |
| RAND() | Computes an evenly distributed random real number greater than or equal to 0 and less than 1. | |
| RANDBETWEEN(lower-bound,upper-bound) | Computes a random integer number in the range lower-bound–upper-bound. | |
| ROUND(x,number-digits) | Rounds x to the number of digits specified by number-digits. | |
| ROUNDDOWN(x,number-digits) | Computes x rounded down, toward zero, to the number of digits specified by number-digits. | |
| ROUNDUP(x,number-digits) | Computes x rounded up, away from zero, to the number of digits specified by number-digits. [ | |
| SERIESSUM(input-value,initial-power,step,coefficients) | Computes the sum of a power series. | |
| SIGN(x) | Determines the sign of x. | |
| SIN(x) | Computes the sine of x. | |
| SINH(x) | Computes the hyperbolic sine of x. | |
| SQRT(x) | Computes the positive square root of x. | |
| SQRTPI(x) | Computes the positive square root of x × π. | |
| SUM(argument-list) | Adds the numeric values of arguments in argument-list. | |
| SUMSQ(argument-list) | Adds the squares of arguments in argument-list. | |
| SUMX2MY2(array-1,array-2) | Computes the sum of the difference of squares of the corresponding numerical elements in two arrays designated by array-1 and array-2. | |
| SUMX2PY2(array-1,array-2) | Computes the sum of the sum of the squares of the corresponding numerical elements in two arrays designated by array-1 and array-2. | |
| SUMXMY2(array-1,array-2) | Computes the sum of the squares of the difference between corresponding numerical elements in two arrays designated by array-1 and array-2. | |
| TAN(x) | Computes the tangent of x. | |
| TANH(x) | Computes the hyperbolic tangent of x. | |
| TRUNC(x[,number-digits]) | Truncates x to the number of fractional digits by number-digits. |