Mathematical and Trigonometric

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