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. |