Supported Formula Functions

(Reference: Office Open XML File Formats - ISO/IEC 29500 - 1, Chapter: 18.17.7 Predefined Function Definitions)

Mathematical and Trigonometric

For further information 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.

Statistical

For further information 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.

Formula Description
AVERAGE(argument-list) Computes the arithmetic mean of the numeric values of its arguments.
COUNT(argument-list) Counts the number of arguments in argument-list that contain numbers, and the number of cells referred to by arguments in argument-list, which contain numbers. (Limitations: Dates are not counted.)
COUNTA(argument-list) Counts the number of arguments that are not cell references, and the number of cells, referred to by arguments, which are not empty. (Limitations: Dates in arrays and cell reference values are not counted.)
COUNTBLANK ( cell-range ) Counts the number of cells in a specified range of cells, which are empty. (Limitations: Cell containing a formula that returns an empty string are not counted.)
MAX(argument-list) Computes the largest of a set of numbers.
MAXA(argument-list) Computes the largest of a set of numbers.
MIN(argument-list) Computes the smallest of a set of numbers.
MINA(argument-list) Computes the smallest of a set of numbers.

Logical

For further information 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.

Formula Description
AND(argument-list) Tests if all arguments in argument-list are TRUE. The function evaluates all arguments prior to returning a value.
FALSE() Computes the value FALSE. (A call to function FALSE is equivalent to using the logical-constant FALSE.)
IF(logical-value,[value-if-true][,[value-if-false]]) Tests logical-value, and if it is TRUE, value-if-true is evaluated and returned; otherwise, value-iffalse is evaluated and returned.
NOT(logical-value) Computes the logical negation of logical-value.
OR(argument-list) Tests if any one or more arguments in argument-list are TRUE. The function evaluates all arguments prior to returning a value.
TRUE() Computes the value TRUE. (A call to function TRUE is equivalent to using the logical-constant TRUE.)

Lookup and Reference

For further information 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.

Formula Description
ADDRESS(row-number,col-number[,[ref-type][,[ A1-ref-style-flag][,sheet-name]]]) Creates a cell address, given the specified row and column numbers.
CHOOSE(index,argument-list) Selects the argument in argument-list that corresponds by position to index.
COLUMN([ reference ]) Finds the number of the column(s) corresponding to reference. If reference is omitted, the behavior is as if reference referred to the cell containing the formula.
COLUMNS(array) Finds the number of columns corresponding to array. (Limitations: Only supported for cell references and cell reference ranges.)
ROW([ reference ]) Finds the number of the row(s) corresponding to reference. If reference is omitted, the behavior is as if reference referred to the cell containing the formula.
ROWS(array) Finds the number of rows corresponding to array (Limitations: Only supported for cell references and cell reference ranges.)

Information

For further information 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.

Formula Description
ISBLANK(value) Determines if value refers to an empty cell.
ISEVEN(value) Determines if value is an even number or refers to a cell containing an even number.
ISLOGICAL(value) Determines if value contains a logical value or refers to a cell containing a logical value.
ISNONTEXT(value) Determines if value does not contain text or does not refer to a cell containing text. An empty cell is not text.
ISNUMBER(value) Determines if value contains a number or refers to a cell that contains a number.
ISODD(value) Determines if value is an odd number or refers to a cell containing an odd number.
ISREF(value) Determines if value is a cell reference.
ISTEXT(value) Determines if value contains text or refers to a cell containing text.
N(value) Converts value to a number or, if value is a reference to a single cell, converts the value of that cell to a number.
NA() Gets the error value #N/A. (The error value #N/A can be used instead of a call to this function; the result is the same.)
TYPE(value) Computes the type of value or, if value is a reference to a single cell, the type of the value in that cell.