Math Formulas

SUM
Math

Adds up a range of cells

MDETERM
Math

Returns the matrix determinant of an array

MINVERSE
Math

Returns the matrix inverse of an array

MMULT
Math

Returns the matrix product of two arrays

SUMX2MY2
Math

Returns the sum of the difference of squares of corresponding values in two arrays

SUMX2PY2
Math

Returns the sum of the sum of squares of corresponding values in two arrays

SUMXMY2
Math

Returns the sum of squares of differences of corresponding values in two arrays

SERIESSUM
Math

Returns the sum of a power series based on the formula

GESTEP
Math

Tests whether a number is greater than a threshold value

DELTA
Math

Tests whether two numbers are equal

ERF
Math

Returns the error function integrated between two limits

ERFC
Math

Returns the complementary error function

BESSELI
Math

Returns the modified Bessel function In(x)

BESSELJ
Math

Returns the Bessel function Jn(x)

BESSELY
Math

Returns the Bessel function Yn(x)

BESSELK
Math

Returns the modified Bessel function Kn(x)

GAMMALN
Math

Returns the natural logarithm of the gamma function

GAMMA
Math

Returns the Gamma function value

RAND
Math

Returns a random number between 0 and 1

RANDBETWEEN
Math

Returns a random integer number between the numbers you specify