Compatibility Functions

These functions should only be used if you need compatibility with Excel 2007.

BETADIST(BETA.DIST) The probability of getting less than or equal to a particular value in a beta distribution.
BETAINV(BETA.INV) The probability of getting greater than a particular value in a beta distribution.
BINOMDIST(BINOM.DIST) The probability of getting less than or equal to a particular value in a binomial distribution.
CEILING(CEILING.MATH) The number rounded up to the nearest integer or significant figure.
CHIDIST(CHISQ.DIST.RT) The one tailed probability of the chi-squared distribution.
CHIINV(CHISQ.INV.RT) The inverse of the one tailed probability of the chi-squared distribution.
CHITEST(CHISQ.TEST) The value from the chi-squared distribution.
CONCATENATE(CONCAT) The text string that is a concatenation of several strings.
CONFIDENCE(CONFIDENCE.NORM) The confidence interval for a population mean.
COVAR(COVARIANCE.P) The average of the products of deviations for each data point pair.
CRITBINOM(BINOM.INV) The probability of getting greater than a particular value in a binomial distribution.
DATEDIFThe number of days, months or years between two dates.
EXPONDIST(EXPON.DIST) The exponential distribution.
FDIST(F.DIST.RT) The probability of getting less than or equal to a particular value in an f distribution.
FINV(F.INV.RT) The probability of getting greater than a particular value in an f distribution.
FLOOR(FLOOR.MATH) The number rounded down to the nearest integer or significant figure.
FORECAST(FORECAST.LINEAR) The future y-value along a linear trend using existing values.
FTEST(F.TEST) The value from the f test.
GAMMADIST(GAMMA.DIST) The probability of getting less than or equal to a particular value in a gamma distribution.
GAMMAINV(GAMMA.INV) The probability of getting greater than a particular value in a gamma distribution.
HYPGEOMDIST(HYPGEOM.DIST) The probability of getting less than or equal to a particular value in a hyper geometric distribution (finite population).
LOGINV(LOGNORMAL.INV) The probability of getting greater than a particular value in a lognormal distribution.
LOGNORMDIST(LOGNORMAL.DIST) The probability of getting less than or equal to a particular value in a lognormal distribution.
MODE(MODE.SNGL) The value that occurs most frequently in a list or array of numbers.
NEGBINOMDIST(NEGBINOM.DIST) The probability of getting less than or equal to a particular value in a negative binomial distribution.
NORMDIST(NORM.DIST) The probability of getting less than or equal to a particular value in a normal distribution.
NORMINV(NORM.INV) The probability of getting greater than a particular value in a normal distribution.
NORMSDIST(NORM.S.DIST) The probability of getting less than or equal to a particular value in a normal distribution (mean 0, standard deviation 1).
NORMSINV(NORM.S.INV) The probability of getting greater than a particular value in a normal distribution (mean 0, standard deviation 1).
PERCENTILE(PERCENTILE.INC) The number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTRANK(PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive).
POISSON(POISSON.DIST) The probability of getting less than or equal to a particular value in a poisson distribution.
QUARTILE(QUARTILE.INC) The quartile of a data set.
RANK(RANK.EQ) The rank of a value in a list of array (in descending order).
STDEV(STDEV.S) The standard deviation based on a sample.
STDEVP(STDEV.P) The standard deviation based on an entire population.
TDIST(T.DIST.2T) The percentage points probability for the students t distribution.
TINV(T.INV.2T) The t-value of the students distribution as a function of the probability and the degrees of freedom.
TTEST(T.TEST) The probability associated with a students t test.
VAR(VAR.S) The variance based on a sample.
VARP(VAR.P) The variance based on an entire population.
WEIBULL(WEIBULL.DIST) The probability of getting less than or equal to a particular value in a weibull distribution.
ZTEST(Z.TEST) The two-tailed P-value of a z-test.
BETADIST
(BETA.DIST) The probability of getting less than or equal to a particular value in a beta distribution.
BETAINV
(BETA.INV) The probability of getting greater than a particular value in a beta distribution.
BINOMDIST
(BINOM.DIST) The probability of getting less than or equal to a particular value in a binomial distribution.
CEILING
(CEILING.MATH) The number rounded up to the nearest integer or significant figure.
CHIDIST
(CHISQ.DIST.RT) The one tailed probability of the chi-squared distribution.
CHIINV
(CHISQ.INV.RT) The inverse of the one tailed probability of the chi-squared distribution.
CHITEST
(CHISQ.TEST) The value from the chi-squared distribution.
CONCATENATE
(CONCAT) The text string that is a concatenation of several strings.
CONFIDENCE
(CONFIDENCE.NORM) The confidence interval for a population mean.
COVAR
(COVARIANCE.P) The average of the products of deviations for each data point pair.
CRITBINOM
(BINOM.INV) The probability of getting greater than a particular value in a binomial distribution.
DATEDIF
The number of days, months or years between two dates.
EXPONDIST
(EXPON.DIST) The exponential distribution.
FDIST
(F.DIST.RT) The probability of getting less than or equal to a particular value in an f distribution.
FINV
(F.INV.RT) The probability of getting greater than a particular value in an f distribution.
FLOOR
(FLOOR.MATH) The number rounded down to the nearest integer or significant figure.
FORECAST
(FORECAST.LINEAR) The future y-value along a linear trend using existing values.
FTEST
(F.TEST) The value from the f test.
GAMMADIST
(GAMMA.DIST) The probability of getting less than or equal to a particular value in a gamma distribution.
GAMMAINV
(GAMMA.INV) The probability of getting greater than a particular value in a gamma distribution.
HYPGEOMDIST
(HYPGEOM.DIST) The probability of getting less than or equal to a particular value in a hyper geometric distribution (finite population).
LOGINV
(LOGNORMAL.INV) The probability of getting greater than a particular value in a lognormal distribution.
LOGNORMDIST
(LOGNORMAL.DIST) The probability of getting less than or equal to a particular value in a lognormal distribution.
MODE
(MODE.SNGL) The value that occurs most frequently in a list or array of numbers.
NEGBINOMDIST
(NEGBINOM.DIST) The probability of getting less than or equal to a particular value in a negative binomial distribution.
NORMDIST
(NORM.DIST) The probability of getting less than or equal to a particular value in a normal distribution.
NORMINV
(NORM.INV) The probability of getting greater than a particular value in a normal distribution.
NORMSDIST
(NORM.S.DIST) The probability of getting less than or equal to a particular value in a normal distribution (mean 0, standard deviation 1).
NORMSINV
(NORM.S.INV) The probability of getting greater than a particular value in a normal distribution (mean 0, standard deviation 1).
PERCENTILE
(PERCENTILE.INC) The number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTRANK
(PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive).
POISSON
(POISSON.DIST) The probability of getting less than or equal to a particular value in a poisson distribution.
QUARTILE
(QUARTILE.INC) The quartile of a data set.
RANK
(RANK.EQ) The rank of a value in a list of array (in descending order).
STDEV
(STDEV.S) The standard deviation based on a sample.
STDEVP
(STDEV.P) The standard deviation based on an entire population.
TDIST
(T.DIST.2T) The percentage points probability for the students t distribution.
TINV
(T.INV.2T) The t-value of the students distribution as a function of the probability and the degrees of freedom.
TTEST
(T.TEST) The probability associated with a students t test.
VAR
(VAR.S) The variance based on a sample.
VARP
(VAR.P) The variance based on an entire population.
WEIBULL
(WEIBULL.DIST) The probability of getting less than or equal to a particular value in a weibull distribution.
ZTEST
(Z.TEST) The two-tailed P-value of a z-test.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext