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

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

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