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 value from the 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 result of an F-test. 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 associated with the F-Test. 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 two-tailed P-value of a z-test. Replaces ZTEST.

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