Excel Formulas

Showing page 14 of 21
MOD
Math

Returns the remainder after number is divided by divisor

QUOTIENT
Math

Returns the integer portion of a division

COMBIN
Math

Returns the number of combinations for a given number of objects

PERMUT
Math

Returns the number of permutations for a given number of objects

GCD
Math

Returns the greatest common divisor

LCM
Math

Returns the least common multiple

SUMIF
Math

Adds the cells specified by a given criteria

SUMIFS
Math

Adds the cells in a range that meet multiple criteria

SUMPRODUCT
Math

Returns the sum of the products of corresponding array components

SUMSQ
Math

Returns the sum of the squares of the arguments

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

PRODUCT
Math

Multiplies all the numbers given as arguments

HARMEAN
Statistical

Returns the harmonic mean of a data set

GEOMEAN
Statistical

Returns the geometric mean of a data set

TRIMMEAN
Statistical

Returns the mean of the interior of a data set

PERCENTILE
Statistical

Returns the k-th percentile of values in a range

QUARTILE
Statistical

Returns the quartile of a data set

MODE
Statistical

Returns the most common value in a data set

Page 14 of 21