Mathematics

ABS — absolute value
ACOS — the arc cosine of x
ACOSH — the hyperbolic arc cosine of x
ACOT — inverse cotangent of x
ACOTH — the inverse hyperbolic cotangent of x
AGM — the arithmetic-geometric mean
ARABIC — the Roman numeral roman as number
ASIN — the arc sine of x
ASINH — the inverse hyperbolic sine of x
ATAN — the arc tangent of x
ATAN2 — the arc tangent of the ratio y/x
ATANH — the inverse hyperbolic tangent of x
AVERAGEIF — average of the cells in actual range for which the corresponding cells in the range meet the given criteria
AVERAGEIFS — average of the cells in actual_range for which the corresponding cells in the range meet the given criteria
BETA — Euler beta function
BETALN — natural logarithm of the absolute value of the Euler beta function
CEIL — smallest integer larger than or equal to x
CEILING — nearest multiple of significance whose absolute value is at least ABS(x)
CHOLESKY — the Cholesky decomposition of the symmetric positive-definite matrix
COMBIN — binomial coefficient
COMBINA — the number of k-combinations of an n-element set with repetition
COS — the cosine of x
COSH — the hyperbolic cosine of x
COSPI — the cosine of Pi*x
COT — the cotangent of x
COTH — the hyperbolic cotangent of x
COTPI — the cotangent of Pi*x
COUNTIF — count of the cells meeting the given criteria
COUNTIFS — count of the cells meeting the given criteria
CSC — the cosecant of x
CSCH — the hyperbolic cosecant of x
DEGREES — equivalent degrees to x radians
EIGEN — eigenvalues and eigenvectors of the symmetric matrix
EVEN — x rounded away from 0 to the next even integer
EXP — e raised to the power of x
EXPM1 — EXP(x)-1
FACT — the factorial of x, i.e. x!
FACTDOUBLE — double factorial
FIB — Fibonacci numbers
FLOOR — nearest multiple of significance whose absolute value is at most ABS(x)
G_PRODUCT — product of all the values and cells referenced
GAMMA — the Gamma function
GAMMALN — natural logarithm of the Gamma function
GCD — the greatest common divisor
GD — Gudermannian function
HYPOT — the square root of the sum of the squares of the arguments
IGAMMA — the incomplete Gamma function
INT — largest integer not larger than x
LAMBERTW — the Lambert W function
LCM — the least common multiple
LINSOLVE — solve linear equation
LN — the natural logarithm of x
LN1P — LN(1+x)
LOG — logarithm of x with base base
LOG10 — the base-10 logarithm of x
LOG2 — the base-2 logarithm of x
MAXIFS — maximum of the cells in actual_range for which the corresponding cells in the range meet the given criteria
MDETERM — the determinant of the matrix matrix
MINIFS — minimum of the cells in actual_range for which the corresponding cells in the range meet the given criteria
MINVERSE — the inverse matrix of matrix
MMULT — the matrix product of mat1 and mat2
MOD — the remainder of x under division by n
MPSEUDOINVERSE — the pseudo-inverse matrix of matrix
MROUND — x rounded to a multiple of m
MULTINOMIAL — multinomial coefficient (x1+⋯+xn) choose (x1,…,xn)
MUNIT — the n by n identity matrix
ODD — x rounded away from 0 to the next odd integer
ODF.SUMPRODUCT — multiplies components and adds the results
PI — the constant 𝜋
POCHHAMMER — the value of GAMMA(x+n)/GAMMA(x)
POWER — the value of x raised to the power y raised to the power of 1/z
PRODUCT — product of the given values
QUOTIENT — integer portion of a division
RADIANS — the number of radians equivalent to x degrees
REDUCEPI — reduce modulo Pi divided by a power of 2
ROMAN — n as a roman numeral text
ROUND — rounded x
ROUNDDOWN — x rounded towards 0
ROUNDUP — x rounded away from 0
SEC — Secant
SECH — the hyperbolic secant of x
SERIESSUM — sum of a power series at x
SIGN — sign of x
SIN — the sine of x
SINH — the hyperbolic sine of x
SINPI — the sine of Pi*x
SQRT — square root of x
SQRTPI — the square root of x times 𝜋
SUM — sum of the given values
SUMA — sum of all values and cells referenced
SUMIF — sum of the cells in actual_range for which the corresponding cells in the range meet the given criteria
SUMIFS — sum of the cells in actual_range for which the corresponding cells in the range meet the given criteria
SUMPRODUCT — multiplies components and adds the results
SUMSQ — sum of the squares of all values and cells referenced
SUMX2MY2 — sum of the difference of squares
SUMX2PY2 — sum of the sum of squares
SUMXMY2 — sum of the squares of differences
TAN — the tangent of x
TANH — the hyperbolic tangent of x
TANPI — the tangent of Pi*x
TRUNC — x truncated to d digits

ABS — absolute value

ABS(x)

x: number

ABS gives the absolute value of x, i.e. the non-negative number of the same magnitude as x.

This function is Excel compatible.

CEIL, CEILING, FLOOR, INT, MOD.

ACOS — the arc cosine of x

ACOS(x)

x: number

This function is Excel compatible.

COS, SIN, DEGREES, RADIANS.

ACOSH — the hyperbolic arc cosine of x

ACOSH(x)

x: number

This function is Excel compatible.

ACOS, ASINH.

ACOT — inverse cotangent of x

ACOT(x)

x: value

COT, TAN.

ACOTH — the inverse hyperbolic cotangent of x

ACOTH(x)

x: number

COTH, TANH.

AGM — the arithmetic-geometric mean

AGM(a,b)

a: value

b: value

AGM computes the arithmetic-geometric mean of the two values.

AVERAGE, GEOMEAN.

ARABIC — the Roman numeral roman as number

ARABIC(roman)

roman: Roman numeral

Any Roman symbol to the left of a larger symbol (directly or indirectly) reduces the final value by the symbol amount, otherwise, it increases the final amount by the symbol's amount.

This function is OpenFormula compatible.

ROMAN.

ASIN — the arc sine of x

ASIN(x)

x: number

ASIN calculates the arc sine of x; that is the value whose sine is x.

If x falls outside the range -1 to 1, ASIN returns #NUM!

This function is Excel compatible.

SIN, COS, ASINH, DEGREES, RADIANS.

ASINH — the inverse hyperbolic sine of x

ASINH(x)

x: number

ASINH calculates the inverse hyperbolic sine of x; that is the value whose hyperbolic sine is x.

This function is Excel compatible.

ASIN, ACOSH, SIN, COS.

ATAN — the arc tangent of x

ATAN(x)

x: number

ATAN calculates the arc tangent of x; that is the value whose tangent is x.

The result will be between −π/2 and +π/2.

This function is Excel compatible.

TAN, COS, SIN, DEGREES, RADIANS.

ATAN2 — the arc tangent of the ratio y/x

ATAN2(x,y)

x: x-coordinate

y: y-coordinate

ATAN2 calculates the direction from the origin to the point (x,y) as an angle from the x-axis in radians.

The result will be between −π and +π. The order of the arguments may be unexpected.

This function is Excel compatible.

This function is OpenFormula compatible.

ATAN, ATANH, COS, SIN.

ATANH — the inverse hyperbolic tangent of x

ATANH(x)

x: number

ATANH calculates the inverse hyperbolic tangent of x; that is the value whose hyperbolic tangent is x.

If the absolute value of x is greater than 1.0, ATANH returns #NUM!

This function is Excel compatible.

ATAN, COS, SIN.

AVERAGEIF — average of the cells in actual range for which the corresponding cells in the range meet the given criteria

AVERAGEIF(range,criteria,actual_range)

range: cell area

criteria: condition for a cell to be included

actual_range: cell area, defaults to range

This function is Excel compatible.

SUMIF, COUNTIF.

AVERAGEIFS — average of the cells in actual_range for which the corresponding cells in the range meet the given criteria

AVERAGEIFS(actual_range,range1,criteria1,…)

actual_range: cell area

range1: cell area

criteria1: condition for a cell to be included

This function is Excel compatible.

AVERAGE, AVERAGEIF.

BETA — Euler beta function

BETA(x,y)

x: number

y: number

BETA function returns the value of the Euler beta function extended to all real numbers except 0 and negative integers.

If x, y, or (x + y) are non-positive integers, BETA returns #NUM!

BETALN, GAMMALN.

BETALN — natural logarithm of the absolute value of the Euler beta function

BETALN(x,y)

x: number

y: number

BETALN function returns the natural logarithm of the absolute value of the Euler beta function extended to all real numbers except 0 and negative integers.

If x, y, or (x + y) are non-positive integers, BETALN returns #NUM!

BETA, GAMMALN.

CEIL — smallest integer larger than or equal to x

CEIL(x)

x: number

CEIL(x) is the smallest integer that is at least as large as x.

This function is the OpenFormula function CEILING(x).

CEILING, FLOOR, ABS, INT, MOD.

CEILING — nearest multiple of significance whose absolute value is at least ABS(x)

CEILING(x,significance)

x: number

significance: base multiple (defaults to 1 for x > 0 and -1 for x < 0)

CEILING(x,significance) is the nearest multiple of significance whose absolute value is at least ABS(x).

If x or significance is non-numeric, CEILING returns a #VALUE! error. If x and significance have different signs, CEILING returns a #NUM! error.

This function is Excel compatible.

CEILING(x) is exported to ODF as CEILING(x,SIGN(x),1). CEILING(x,significance) is the OpenFormula function CEILING(x,significance,1).

CEIL, FLOOR, ABS, INT, MOD.

CHOLESKY — the Cholesky decomposition of the symmetric positive-definite matrix

CHOLESKY(matrix)

matrix: a symmetric positive definite matrix

If the Cholesky-Banachiewicz algorithm applied to matrix fails, Cholesky returns #NUM! If matrix does not contain an equal number of columns and rows, CHOLESKY returns #VALUE!

MINVERSE, MMULT, MDETERM.

COMBIN — binomial coefficient

COMBIN(n,k)

n: non-negative integer

k: non-negative integer

COMBIN returns the binomial coefficient "n choose k", the number of k-combinations of an n-element set without repetition.

If n is less than k COMBIN returns #NUM!

This function is Excel compatible.

This function is OpenFormula compatible.

COMBINA — the number of k-combinations of an n-element set with repetition

COMBINA(n,k)

n: non-negative integer

k: non-negative integer

This function is OpenFormula compatible.

COMBIN.

COS — the cosine of x

COS(x)

x: angle in radians

This function is Excel compatible.

SIN, TAN, SINH, COSH, TANH, RADIANS, DEGREES.

COSH — the hyperbolic cosine of x

COSH(x)

x: number

This function is Excel compatible.

SIN, TAN, SINH, COSH, TANH.

COSPI — the cosine of Pi*x

COSPI(x)

x: number of half turns

COS.

COT — the cotangent of x

COT(x)

x: number

TAN, ACOT.

COTH — the hyperbolic cotangent of x

COTH(x)

x: number

TANH, ACOTH.

COTPI — the cotangent of Pi*x

COTPI(x)

x: number of half turns

COT.

COUNTIF — count of the cells meeting the given criteria

COUNTIF(range,criteria)

range: cell area

criteria: condition for a cell to be counted

This function is Excel compatible.

COUNT, SUMIF.

COUNTIFS — count of the cells meeting the given criteria

COUNTIFS(range,criteria,…)

range: cell area

criteria: condition for a cell to be counted

This function is Excel compatible.

COUNT, SUMIF.

CSC — the cosecant of x

CSC(x)

x: angle in radians

This function is not Excel compatible.

This function is OpenFormula compatible.

SIN, COS, TAN, SEC, SINH, COSH, TANH, RADIANS, DEGREES.

CSCH — the hyperbolic cosecant of x

CSCH(x)

x: number

This function is not Excel compatible.

This function is OpenFormula compatible.

SIN, COS, TAN, CSC, SEC, SINH, COSH, TANH.

DEGREES — equivalent degrees to x radians

DEGREES(x)

x: angle in radians

This function is Excel compatible.

RADIANS, PI.

EIGEN — eigenvalues and eigenvectors of the symmetric matrix

EIGEN(matrix)

matrix: a symmetric matrix

If matrix is not symmetric, matching off-diagonal cells will be averaged on the assumption that the non-symmetry is caused by unimportant rounding errors. If matrix does not contain an equal number of columns and rows, EIGEN returns #VALUE!

EVEN — x rounded away from 0 to the next even integer

EVEN(x)

x: number

This function is Excel compatible.

ODD.

EXP — e raised to the power of x

EXP(x)

x: number

e is the base of the natural logarithm.

This function is Excel compatible.

LOG, LOG2, LOG10.

EXPM1 — EXP(x)-1

EXPM1(x)

x: number

This function has a higher resulting precision than evaluating EXP(x)-1.

EXP, LN1P.

FACT — the factorial of x, i.e. x!

FACT(x)

x: number

The domain of this function has been extended using the GAMMA function.

This function is Excel compatible.

FACTDOUBLE — double factorial

FACTDOUBLE(x)

x: non-negative integer

FACTDOUBLE function returns the double factorial x!!

If x is not an integer, it is truncated. If x is negative, FACTDOUBLE returns #NUM!

This function is Excel compatible.

FACT.

FIB — Fibonacci numbers

FIB(n)

n: positive integer

FIB(n) is the nth Fibonacci number.

If n is not an integer, it is truncated. If it is negative or zero FIB returns #NUM!

FLOOR — nearest multiple of significance whose absolute value is at most ABS(x)

FLOOR(x,significance)

x: number

significance: base multiple (defaults to 1 for x > 0 and -1 for x < 0)

FLOOR(x,significance) is the nearest multiple of significance whose absolute value is at most ABS(x)

This function is Excel compatible.

FLOOR(x) is exported to ODF as FLOOR(x,SIGN(x),1). FLOOR(x,significance) is the OpenFormula function FLOOR(x,significance,1).

CEIL, CEILING, ABS, INT, MOD.

G_PRODUCT — product of all the values and cells referenced

G_PRODUCT(x1,x2,…)

x1: number

x2: number

Empty cells are ignored and the empty product is 1.

SUM, COUNT.

GAMMA — the Gamma function

GAMMA(x)

x: number

GAMMALN.

GAMMALN — natural logarithm of the Gamma function

GAMMALN(x)

x: number

This function is Excel compatible.

GAMMA.

GCD — the greatest common divisor

GCD(n0,n1,…)

n0: positive integer

n1: positive integer

GCD calculates the greatest common divisor of the given numbers n0,n1,..., the greatest integer that is a divisor of each argument.

If any of the arguments is not an integer, it is truncated.

This function is Excel compatible.

LCM.

GD — Gudermannian function

GD(x)

x: value

TAN, TANH.

HYPOT — the square root of the sum of the squares of the arguments

HYPOT(n0,n1,…)

n0: number

n1: number

MIN, MAX.

IGAMMA — the incomplete Gamma function

IGAMMA(a,x,lower,regularize,real)

a: number

x: number

lower: if true (the default), the lower incomplete gamma function, otherwise the upper incomplete gamma function

regularize: if true (the default), the regularized version of the incomplete gamma function

real: if true (the default), the real part of the result, otherwise the imaginary part

The regularized incomplete gamma function is the unregularized incomplete gamma function divided by GAMMA(a) This is a real valued function as long as neither a nor z are negative.

GAMMA, IMIGAMMA.

INT — largest integer not larger than x

INT(x)

x: number

This function is Excel compatible.

CEIL, CEILING, FLOOR, ABS, MOD.

LAMBERTW — the Lambert W function

LAMBERTW(x,k)

x: number

k: branch

k defaults to 0, the principal branch. k must be either 0 or -1.

EXP.

LCM — the least common multiple

LCM(n0,n1,…)

n0: positive integer

n1: positive integer

LCM calculates the least common multiple of the given numbers n0,n1,..., the smallest integer that is a multiple of each argument.

If any of the arguments is not an integer, it is truncated.

This function is Excel compatible.

GCD.

LINSOLVE — solve linear equation

LINSOLVE(A,B)

A: a matrix

B: a matrix

Solves the equation A*X=B and returns X.

If the matrix A is singular, #VALUE! is returned.

MINVERSE.

LN — the natural logarithm of x

LN(x)

x: positive number

If x ≤ 0, LN returns #NUM! error.

This function is Excel compatible.

EXP, LOG2, LOG10.

LN1P — LN(1+x)

LN1P(x)

x: positive number

LN1P calculates LN(1+x) but yielding a higher precision than evaluating LN(1+x).

If x ≤ -1, LN returns #NUM! error.

This function is Excel compatible.

EXP, LN, EXPM1.

LOG — logarithm of x with base base

LOG(x,base)

x: positive number

base: base of the logarithm, defaults to 10

base must be positive and not equal to 1. If x ≤ 0, LOG returns #NUM! error.

This function is Excel compatible.

LN, LOG2, LOG10.

LOG10 — the base-10 logarithm of x

LOG10(x)

x: positive number

If x ≤ 0, LOG10 returns #NUM!

EXP, LOG2, LOG.

LOG2 — the base-2 logarithm of x

LOG2(x)

x: positive number

If x ≤ 0, LOG2 returns #NUM!

EXP, LOG10, LOG.

MAXIFS — maximum of the cells in actual_range for which the corresponding cells in the range meet the given criteria

MAXIFS(actual_range,range1,criteria1,…)

actual_range: cell area

range1: cell area

criteria1: condition for a cell to be included

This function is Excel compatible.

MIN, MINIFS.

MDETERM — the determinant of the matrix matrix

MDETERM(matrix)

matrix: a square matrix

This function is Excel compatible.

MMULT, MINVERSE.

MINIFS — minimum of the cells in actual_range for which the corresponding cells in the range meet the given criteria

MINIFS(actual_range,range1,criteria1,…)

actual_range: cell area

range1: cell area

criteria1: condition for a cell to be included

This function is Excel compatible.

MIN, MAXIFS.

MINVERSE — the inverse matrix of matrix

MINVERSE(matrix)

matrix: a square matrix

If matrix is not invertible, MINVERSE returns #NUM! If matrix does not contain an equal number of columns and rows, MINVERSE returns #VALUE!

This function is Excel compatible.

MMULT, MDETERM, LINSOLVE.

MMULT — the matrix product of mat1 and mat2

MMULT(mat1,mat2)

mat1: a matrix

mat2: a matrix

The number of columns in mat1 must equal the number of rows in mat2; otherwise #VALUE! is returned. The result of MMULT is an array, in which the number of rows is the same as in mat1), and the number of columns is the same as in (mat2).

This function is Excel compatible.

TRANSPOSE, MINVERSE.

MOD — the remainder of x under division by n

MOD(x,n)

x: integer

n: integer

MOD function returns the remainder when x is divided by n.

If n is 0, MOD returns #DIV/0!

This function is Excel compatible.

CEIL, CEILING, FLOOR, ABS, INT, ABS.

MPSEUDOINVERSE — the pseudo-inverse matrix of matrix

MPSEUDOINVERSE(matrix,threshold)

matrix: a matrix

threshold: a relative size threshold for discarding eigenvalues

MINVERSE.

MROUND — x rounded to a multiple of m

MROUND(x,m)

x: number

m: number

If x and m have different sign, MROUND returns #NUM!

This function is Excel compatible.

ROUNDDOWN, ROUND, ROUNDUP.

MULTINOMIAL — multinomial coefficient (x1+⋯+xn) choose (x1,…,xn)

MULTINOMIAL(x1,x2,xn,…)

x1: first number

x2: second number

xn: nth number

This function is Excel compatible.

COMBIN, SUM.

MUNIT — the n by n identity matrix

MUNIT(n)

n: size of the matrix

This function is OpenFormula compatible.

MMULT, MDETERM, MINVERSE.

ODD — x rounded away from 0 to the next odd integer

ODD(x)

x: number

This function is Excel compatible.

EVEN.

ODF.SUMPRODUCT — multiplies components and adds the results

ODF.SUMPRODUCT(,…)

Multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.

If an entry is not numeric or logical, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. This function differs from SUMPRODUCT by considering booleans.

This function is not Excel compatible. Use SUMPRODUCT instead.

This function is OpenFormula compatible.

SUMPRODUCT, SUM, PRODUCT, G_PRODUCT.

PI — the constant 𝜋

PI()

This function is Excel compatible, but it returns 𝜋 with a better precision.

SQRTPI.

POCHHAMMER — the value of GAMMA(x+n)/GAMMA(x)

POCHHAMMER(x,n)

x: number

n: number

GAMMA.

POWER — the value of x raised to the power y raised to the power of 1/z

POWER(x,y,z)

x: number

y: number

z: number

If both x and y equal 0, POWER returns #NUM! If x = 0 and y < 0, POWER returns #DIV/0! If x < 0 and y is not an integer, POWER returns #NUM! z defaults to 1 If z is not a positive integer, POWER returns #NUM! If x < 0, y is odd, and z is even, POWER returns #NUM!

EXP.

PRODUCT — product of the given values

PRODUCT(values,…)

values: a list of values to multiply

PRODUCT computes the product of all the values and cells referenced in the argument list.

If all cells are empty, the result will be 0.

This function is Excel compatible.

This function is OpenFormula compatible.

SUM, COUNT, G_PRODUCT.

QUOTIENT — integer portion of a division

QUOTIENT(numerator,denominator)

numerator: integer

denominator: non-zero integer

QUOTIENT yields the integer portion of the division numerator/denominator.

QUOTIENT (numerator,denominator)⨉denominator+MOD(numerator,denominator)=numerator

This function is Excel compatible.

MOD.

RADIANS — the number of radians equivalent to x degrees

RADIANS(x)

x: angle in degrees

This function is Excel compatible.

PI, DEGREES.

REDUCEPI — reduce modulo Pi divided by a power of 2

REDUCEPI(x,e,q)

x: number

e: scale

q: get lower bits of quotient, defaults to FALSE

This function returns a value, xr, such that x=xr+j*Pi/2^e where j is an integer and the absolute value of xr does not exceed Pi/2^(e+1). If optional argument q is TRUE, returns instead the e+1 lower bits of j. The reduction is performed as-if using an exact value of Pi. The lowest valid e is -1 representing reduction modulo 2*Pi; the highest is 7 representing reduction modulo Pi/256.

PI.

ROMAN — n as a roman numeral text

ROMAN(n,type)

n: non-negative integer

type: 0,1,2,3,or 4, defaults to 0

ROMAN returns the arabic number n as a roman numeral text.

If type is 0 or it is omitted, ROMAN returns classic roman numbers.

Type 1 is more concise than classic type, type 2 is more concise than type 1, and type 3 is more concise than type 2. Type 4 is a simplified type.

This function is Excel compatible.

ROUND — rounded x

ROUND(x,d)

x: number

d: integer, defaults to 0

If d is greater than zero, x is rounded to the given number of digits.

If d is zero, x is rounded to the next integer.

If d is less than zero, x is rounded to the left of the decimal point

This function is Excel compatible.

ROUNDDOWN, ROUNDUP.

ROUNDDOWN — x rounded towards 0

ROUNDDOWN(x,d)

x: number

d: integer, defaults to 0

If d is greater than zero, x is rounded toward 0 to the given number of digits.

If d is zero, x is rounded toward 0 to the next integer.

If d is less than zero, x is rounded toward 0 to the left of the decimal point

This function is Excel compatible.

ROUND, ROUNDUP.

ROUNDUP — x rounded away from 0

ROUNDUP(x,d)

x: number

d: integer, defaults to 0

If d is greater than zero, x is rounded away from 0 to the given number of digits.

If d is zero, x is rounded away from 0 to the next integer.

If d is less than zero, x is rounded away from 0 to the left of the decimal point

This function is Excel compatible.

ROUND, ROUNDDOWN, INT.

SEC — Secant

SEC(x)

x: angle in radians

This function is not Excel compatible.

SEC(x) is exported to OpenFormula as 1/COS(x).

SIN, COS, TAN, CSC, SINH, COSH, TANH, RADIANS, DEGREES.

SECH — the hyperbolic secant of x

SECH(x)

x: number

This function is not Excel compatible.

SECH(x) is exported to OpenFormula as 1/COSH(x).

SIN, COS, TAN, CSC, SEC, SINH, COSH, TANH.

SERIESSUM — sum of a power series at x

SERIESSUM(x,n,m,coeff)

x: number where to evaluate the power series

n: non-negative integer, exponent of the lowest term of the series

m: increment to each exponent

coeff: coefficients of the power series

This function is Excel compatible.

COUNT, SUM.

SIGN — sign of x

SIGN(x)

x: number

SIGN returns 1 if the x is positive and it returns -1 if x is negative.

This function is Excel compatible.

ABS.

SIN — the sine of x

SIN(x)

x: angle in radians

This function is Excel compatible.

COS, TAN, CSC, SEC, SINH, COSH, TANH, RADIANS, DEGREES.

SINH — the hyperbolic sine of x

SINH(x)

x: number

This function is Excel compatible.

SIN, COSH, ASINH.

SINPI — the sine of Pi*x

SINPI(x)

x: number of half turns

SIN.

SQRT — square root of x

SQRT(x)

x: non-negative number

If x is negative, SQRT returns #NUM!

This function is Excel compatible.

POWER.

SQRTPI — the square root of x times 𝜋

SQRTPI(x)

x: non-negative number

This function is Excel compatible.

PI.

SUM — sum of the given values

SUM(values,…)

values: a list of values to add

SUM computes the sum of all the values and cells referenced in the argument list.

This function is Excel compatible.

This function is OpenFormula compatible.

AVERAGE, COUNT.

SUMA — sum of all values and cells referenced

SUMA(area0,area1,…)

area0: first cell area

area1: second cell area

Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1).

AVERAGE, SUM, COUNT.

SUMIF — sum of the cells in actual_range for which the corresponding cells in the range meet the given criteria

SUMIF(range,criteria,actual_range)

range: cell area

criteria: condition for a cell to be summed

actual_range: cell area, defaults to range

If the actual_range has a size that differs from the size of range, actual_range is resized (retaining the top-left corner) to match the size of range.

This function is Excel compatible.

SUM, SUMIFS, COUNTIF.

SUMIFS — sum of the cells in actual_range for which the corresponding cells in the range meet the given criteria

SUMIFS(actual_range,range1,criteria1,…)

actual_range: cell area

range1: cell area

criteria1: condition for a cell to be included

This function is Excel compatible.

SUM, SUMIF.

SUMPRODUCT — multiplies components and adds the results

SUMPRODUCT(,…)

Multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.

If an entry is not numeric, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. This function ignores logicals, so using SUMPRODUCT(A1:A5>0) will not work. Instead use SUMPRODUCT(--(A1:A5>0))

This function is Excel compatible.

This function is not OpenFormula compatible. Use ODF.SUMPRODUCT instead.

SUM, PRODUCT, G_PRODUCT, ODF.SUMPRODUCT.

SUMSQ — sum of the squares of all values and cells referenced

SUMSQ(area0,area1,…)

area0: first cell area

area1: second cell area

This function is Excel compatible.

SUM, COUNT.

SUMX2MY2 — sum of the difference of squares

SUMX2MY2(array0,array1)

array0: first cell area

array1: second cell area

SUMX2MY2 function returns the sum of the difference of squares of corresponding values in two arrays. The equation of SUMX2MY2 is SUM(x^2-y^2).

This function is Excel compatible.

SUMSQ, SUMX2PY2.

SUMX2PY2 — sum of the sum of squares

SUMX2PY2(array0,array1)

array0: first cell area

array1: second cell area

SUMX2PY2 function returns the sum of the sum of squares of corresponding values in two arrays. The equation of SUMX2PY2 is SUM(x^2+y^2).

If array0 and array1 have different number of data points, SUMX2PY2 returns #N/A.

Strings and empty cells are simply ignored.

This function is Excel compatible.

SUMSQ, SUMX2MY2.

SUMXMY2 — sum of the squares of differences

SUMXMY2(array0,array1)

array0: first cell area

array1: second cell area

SUMXMY2 function returns the sum of the squares of the differences of corresponding values in two arrays. The equation of SUMXMY2 is SUM((x-y)^2).

If array0 and array1 have different number of data points, SUMXMY2 returns #N/A.

Strings and empty cells are simply ignored.

This function is Excel compatible.

SUMSQ, SUMX2MY2, SUMX2PY2.

TAN — the tangent of x

TAN(x)

x: angle in radians

This function is Excel compatible.

TANH, COS, COSH, SIN, SINH, DEGREES, RADIANS.

TANH — the hyperbolic tangent of x

TANH(x)

x: number

This function is Excel compatible.

TAN, SIN, SINH, COS, COSH.

TANPI — the tangent of Pi*x

TANPI(x)

x: number of half turns

TAN.

TRUNC — x truncated to d digits

TRUNC(x,d)

x: number

d: non-negative integer, defaults to 0

If d is omitted or negative then it defaults to zero. If it is not an integer then it is truncated to an integer.

This function is Excel compatible.

INT.

Mathematics

ABS

Synopsis

Arguments

Description

Microsoft Excel Compatibility

See also

ACOS

Synopsis

Arguments

Microsoft Excel Compatibility

See also

ACOSH

Synopsis

Arguments

Microsoft Excel Compatibility

See also

ACOT

Synopsis

Arguments

See also

ACOTH

Synopsis

Arguments

See also

AGM

Synopsis

Arguments

Description

See also

ARABIC

Synopsis

Arguments

Description

OpenDocument Format (ODF) Compatibility

See also

ASIN

Synopsis

Arguments

Description

Note

Microsoft Excel Compatibility

See also

ASINH

Synopsis

Arguments

Description

Microsoft Excel Compatibility

See also

ATAN

Synopsis

Arguments

Description

Note

Microsoft Excel Compatibility

See also

ATAN2

Synopsis

Arguments

Description

Note

Microsoft Excel Compatibility

OpenDocument Format (ODF) Compatibility

See also

ATANH

Synopsis

Arguments

Description

Note

Microsoft Excel Compatibility

See also

AVERAGEIF

Synopsis

Arguments

Microsoft Excel Compatibility

See also

AVERAGEIFS

Synopsis

Arguments

Microsoft Excel Compatibility