New Functions in 2010

Excel 2010 introducted 61 new worksheet functions.

AGGREGATEReturns an aggregate in a list or database. Replaces SUBTOTAL
BETA.DISTReturns the cumulative beta probability density function. Replaces BETADIST
BETA.INVReturns the inverse of the cumulative beta probability density function. Replaces BETAINV
BINOM.DISTReturns the individual term binomial distribution probability. Replaces BINOMDIST
BINOM.INVReturns the smallest number which is the cumulative binomial distribution that is greater than a criterion value. Replaces CRITBINOM
CEILING.PRECISERounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
CHISQ.DISTReturns the cumulative beta probability density function.
CHISQ.DIST.RTReturns the one tailed probability of the chi-squared distribution. Replaces CHIDIST
CHISQ.INVReturns the random variable where the probability of getting 'less than' it is P.
CHISQ.INV.RTReturns the inverse of the one tailed probability of the chi-squared distribution. Replaces CHIINV
CHISQ.TESTReturns the probability value from a chi-squared distribution. Replaces CHITEST
CONFIDENCE.NORMReturns the confidence interval for a population mean. Replaces CONFIDENCE
CONFIDENCE.TReturns the confidence interval for a population mean, using a Student's t distribution.
COVARIANCE.PReturns the covariance of two lists of numbers. Replaces COVAR
COVARIANCE.SReturns the sample covariance, the average of the products deviations for each data point pair in two data sets.
ERF.PRECISEReturns the error function.
ERFC.PRECISEReturns the complementary ERF function integrated between x and infinity.
EXPON.DISTReturns the exponential distribution. Replaces EXPONDIST
F.DISTReturns the F probability distribution.
F.DIST.RTReturns the F probability distribution. Replaces FDIST
F.INVReturns the inverse of the F probability distribution.
F.INV.RTReturns the inverse of the F probability distribution. Replaces FINV
F.TESTReturns the probability value from an F distribution. Replaces FTEST
FLOOR.PRECISERounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
GAMMA.DISTReturns the gamma distribution. Replaces GAMMADIST
GAMMA.INVReturns the inverse of the gamma distribution. Replaces GAMMAINV
GAMMALN.PRECISEReturns the natural logarithm of the gamma function, G(x).
HYPGEOM.DISTReturns the hyper geometric distribution for a finite population. Replaces HYPGEOMDIST
ISO.CEILINGRounds a number up to the nearest integer or to the nearest multiple of significance.
LOGNORM.DISTReturns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Replaces LOGNORMDIST
LOGNORM.INVReturns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. Replaces LOGINV
MODE.MULTReturns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
MODE.SNGLReturns the number that occurs most frequently in a range. Replaces MODE
NEGBINOM.DISTReturns the negative binomial distribution. Replaces NEGBINOMDIST
NETWORKDAYS.INTLReturns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Replaces NETWORKDAYS
NORM.DISTReturns the normal cumulative distribution. Replaces NORMDIST
NORM.INVReturns the inverse of the normal cumulative distribution. Replaces NORMINV
NORM.S.DISTReturns the standard normal cumulative distribution. Replaces NORMSDIST
NORM.S.INVReturns the inverse of the standard normal cumulative distribution. Replaces NORMSINV
PERCENTILE.EXCReturns the Kth percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INCThe Kth percentile of values in an array of numbers. Replaces PERCENTILE
PERCENTRANK.EXCReturns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
PERCENTRANK.INCReturns the rank of a value in a data set as a percentage of the data set. Replaces PERCENTRANK
POISSON.DISTReturns the Poisson distribution. Replaces POISSON
QUARTILE.EXCReturns the quartile of the data set, based on percentile values from 0..1, exclusive.
QUARTILE.INCReturns the quartile of a data set. Replaces QUARTILE
RANK.AVGReturns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned.
RANK.EQReturns the rank of a number in a list of numbers. Replaces RANK
STDEV.PReturns the standard deviation based on the entire population. Replaces STDEVP
STDEV.SReturns the standard deviation based on a sample. Replaces STDEV
T.DISTReturns the Percentage Points (probability) for the Student's t-distribution.
T.DIST.2TReturns the two-tailed Student's t-distribution. Replaces TDIST
T.DIST.RTReturns the right-tailed Student's t-distribution. Replaces TDIST
T.INVReturns the T-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
T.INV.2TReturns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. Replaces TINV
T.TESTReturns the probability value from a T distribution. Replaces TTEST
VAR.PReturns the variance based on the entire population. Replaces VARP
VAR.SReturns the variance based on a sample. Replaces VAR
WEIBULL.DISTReturns the Weibull distribution. Replaces WEIBULL
WORKDAY.INTLReturns the serial number that is a given number of days before or after a date. Replaces WORKDAY
Z.TESTReturns the probability value from a Normal distribution. Replaces ZTEST
AGGREGATE
Returns an aggregate in a list or database. Replaces SUBTOTAL
BETA.DIST
Returns the cumulative beta probability density function. Replaces BETADIST
BETA.INV
Returns the inverse of the cumulative beta probability density function. Replaces BETAINV
BINOM.DIST
Returns the individual term binomial distribution probability. Replaces BINOMDIST
BINOM.INV
Returns the smallest number which is the cumulative binomial distribution that is greater than a criterion value. Replaces CRITBINOM
CEILING.PRECISE
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
CHISQ.DIST
Returns the cumulative beta probability density function.
CHISQ.DIST.RT
Returns the one tailed probability of the chi-squared distribution. Replaces CHIDIST
CHISQ.INV
Returns the random variable where the probability of getting 'less than' it is P.
CHISQ.INV.RT
Returns the inverse of the one tailed probability of the chi-squared distribution. Replaces CHIINV
CHISQ.TEST
Returns the probability value from a chi-squared distribution. Replaces CHITEST
CONFIDENCE.NORM
Returns the confidence interval for a population mean. Replaces CONFIDENCE
CONFIDENCE.T
Returns the confidence interval for a population mean, using a Student's t distribution.
COVARIANCE.P
Returns the covariance of two lists of numbers. Replaces COVAR
COVARIANCE.S
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets.
ERF.PRECISE
Returns the error function.
ERFC.PRECISE
Returns the complementary ERF function integrated between x and infinity.
EXPON.DIST
Returns the exponential distribution. Replaces EXPONDIST
F.DIST
Returns the F probability distribution.
F.DIST.RT
Returns the F probability distribution. Replaces FDIST
F.INV
Returns the inverse of the F probability distribution.
F.INV.RT
Returns the inverse of the F probability distribution. Replaces FINV
F.TEST
Returns the probability value from an F distribution. Replaces FTEST
FLOOR.PRECISE
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
GAMMA.DIST
Returns the gamma distribution. Replaces GAMMADIST
GAMMA.INV
Returns the inverse of the gamma distribution. Replaces GAMMAINV
GAMMALN.PRECISE
Returns the natural logarithm of the gamma function, G(x).
HYPGEOM.DIST
Returns the hyper geometric distribution for a finite population. Replaces HYPGEOMDIST
ISO.CEILING
Rounds a number up to the nearest integer or to the nearest multiple of significance.
LOGNORM.DIST
Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Replaces LOGNORMDIST
LOGNORM.INV
Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. Replaces LOGINV
MODE.MULT
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
MODE.SNGL
Returns the number that occurs most frequently in a range. Replaces MODE
NEGBINOM.DIST
Returns the negative binomial distribution. Replaces NEGBINOMDIST
NETWORKDAYS.INTL
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Replaces NETWORKDAYS
NORM.DIST
Returns the normal cumulative distribution. Replaces NORMDIST
NORM.INV
Returns the inverse of the normal cumulative distribution. Replaces NORMINV
NORM.S.DIST
Returns the standard normal cumulative distribution. Replaces NORMSDIST
NORM.S.INV
Returns the inverse of the standard normal cumulative distribution. Replaces NORMSINV
PERCENTILE.EXC
Returns the Kth percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INC
The Kth percentile of values in an array of numbers. Replaces PERCENTILE
PERCENTRANK.EXC
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
PERCENTRANK.INC
Returns the rank of a value in a data set as a percentage of the data set. Replaces PERCENTRANK
POISSON.DIST
Returns the Poisson distribution. Replaces POISSON
QUARTILE.EXC
Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
QUARTILE.INC
Returns the quartile of a data set. Replaces QUARTILE
RANK.AVG
Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned.
RANK.EQ
Returns the rank of a number in a list of numbers. Replaces RANK
STDEV.P
Returns the standard deviation based on the entire population. Replaces STDEVP
STDEV.S
Returns the standard deviation based on a sample. Replaces STDEV
T.DIST
Returns the Percentage Points (probability) for the Student's t-distribution.
T.DIST.2T
Returns the two-tailed Student's t-distribution. Replaces TDIST
T.DIST.RT
Returns the right-tailed Student's t-distribution. Replaces TDIST
T.INV
Returns the T-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
T.INV.2T
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. Replaces TINV
T.TEST
Returns the probability value from a T distribution. Replaces TTEST
VAR.P
Returns the variance based on the entire population. Replaces VARP
VAR.S
Returns the variance based on a sample. Replaces VAR
WEIBULL.DIST
Returns the Weibull distribution. Replaces WEIBULL
WORKDAY.INTL
Returns the serial number that is a given number of days before or after a date. Replaces WORKDAY
Z.TEST
Returns the probability value from a Normal distribution. Replaces ZTEST

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