(Reference: Office Open XML File Formats - ISO/IEC 29500 - 1, Chapter: 18.17.7 Predefined Function Definitions)
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. |
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. |
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. |
| 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. |
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. |
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.) |
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.) |
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/ |
| 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. |