Skip to Content
 BETADIST
BETADIST(x, alpha, beta, [A], [B])
 BETAINV
BETAINV(probability, alpha, beta, [A], [B])
 BINOMDIST
BINOMDIST(number_s, trials, probability_s, cumulative)
 CEILING
CEILING(number, significance)
 CHIDIST
CHIDIST(x, degrees_freedom)
 CHIINV
CHIINV(probability, degrees_freedom)
 CHITEST
CHITEST(actual_range, expected_range)
 CONFIDENCE
CONFIDENCE(alpha, standard_dev, size)
 COVAR
COVAR(array1, array2)
 CRITBINOM
CRITBINOM(trials, probability_s, alpha)
 EXPONDIST
EXPONDIST(x, lambda, cumulative)
 FDIST
FDIST(x, degrees_freedom1, degrees_freedom2)
 FINV
FINV(probability, degrees_freedom1, degrees_freedom2)
 FLOOR
FLOOR(number, significance)
 FTEST
FTEST(array1, array2)
 GAMMADIST
GAMMADIST(x, alpha, beta, cumulative)
 GAMMAINV
GAMMAINV(probability, alpha, beta)
 HYPGEOMDIST
HYPGEOMDIST(sample_s, number_sample, ...)
 LOGINV
LOGINV(probability, mean, standard_dev)
 LOGNORMDIST
LOGNORMDIST(x, mean, standard_dev)
 MODE
MODE(number1, [number2], ...)
 NEGBINOMDIST
NEGBINOMDIST(number_f, number_s, probability_s)
 NORMDIST
NORMDIST(x, mean, standard_dev, cumulative)
 NORM.INV
NORM.INV(probability, mean, standard_dev)
 NORMSDIST
NORMSDIST(z)
 NORMSINV
NORMSINV(probability)
 PERCENTILE
PERCENTILE(array, k)
 PERCENTRANK
PERCENTRANK(array, x, [significance])
 POISSON
POISSON(x, mean, cumulative)
 QUARTILE
QUARTILE(array, quart)
 RANK
RANK(number, ref, [order])
 STDEV
STDEV(number1, [number2], ...)
 STDEVP
STDEVP(number1, [number2], ...)
 TDIST
TDIST(x, degrees_freedom, tails)
 TINV
TINV(probability, degrees_freedom)
 TTEST
TTEST(array1, array2, tails, type)
 VAR
VAR(number1, [number2], ...)
 VARP
VARP(number1, [number2], ...)
 WEIBULL
WEIBULL(x, alpha, beta, cumulative)
 ZTEST
ZTEST(array, x, [sigma])

Compatibility

Compatibility functions which exist only to support old Excel versions. Look for their replacement instead.