# 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.

© 2022 Better Solutions Limited