Excel 2010 New Functions

Excel 2010 provides several new functions that are not available in earlier versions of Excel. Most of these are statistical functions, although many of these are simply updated versions of older Excel functions.

The new Excel 2010 functions are listed below, organised by category.

Date & Time Functions
WORKDAY.INTLReturns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date, using supplied parameters to specify weekend days.
NETWORKDAYS.INTLReturns the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days.
Math Functions
AGGREGATEPerforms a specified calculation (e.g. the sum, product, average, etc.) for a list or database, with the option to ignore hidden rows and error values.
CEILING.PRECISERounds a number up, regardless of the sign of the number, to a multiple of significance.
ISO.CEILINGRounds a number up, regardless of the sign of the number, to a multiple of significance.
FLOOR.PRECISERounds a number down, regardless of the sign of the number, to a multiple of significance.
Statistical Functions
PERCENTILE.INCReturns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (inclusive) (Replaces the old Percentile function).
PERCENTILE.EXCReturns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (exclusive).
QUARTILE.INCReturns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (Replaces the old Quartile function).
QUARTILE.EXCReturns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (exclusive).
RANK.EQReturns the Mode (the most frequently occurring value) of a list of supplied numbers (if more than one value has same rank, the top rank of that set is returned) (Replaces the old Rank function).
RANK.AVGReturns the statistical rank of a given value, within a supplied array of values (if more than one value has same rank, the average rank is returned).
PERCENTRANK.INCReturns the rank of a value in a data set, as a percentage (0 - 1 inclusive) (Replaces the old Percentrank function).
PERCENTRANK.EXCReturns the rank of a value in a data set, as a percentage (0 - 1 exclusive).
MODE.SNGLReturns the Mode (the most frequently occurring value) of a list of supplied numbers (Replaces the old Mode function).
MODE.MULTReturns a vertical array of the most frequently occurring values in an array or range of data.
STDEV.SReturns the standard deviation of a supplied set of values (which represent a sample of a population) (Replaces the old Stdev function).
STDEV.PReturns the standard deviation of a supplied set of values (which represent an entire population) (Replaces the old Stdevp function).
VAR.SReturns the variance of a supplied set of values (which represent a sample of a population) (Replaces the old Var function).
VAR.PReturns the variance of a supplied set of values (which represent an entire population) (Replaces the old Varp function).
COVARIANCE.PReturns population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (Replaces the old Covar function).
COVARIANCE.SReturns sample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets).
CONFIDENCE.NORMReturns the confidence interval for a population mean, using a normal distribution (Replaces the old Confidence function).
CONFIDENCE.TReturns the confidence interval for a population mean, using a Student's t distribution.
BETA.DISTReturns the cumulative beta distribution function or the beta probability density function (Replaces the old Betadist function).
BETA.INVReturns the inverse of the cumulative beta probability density function (Replaces the old Betainv function).
BINOM.DISTReturns the individual term binomial distribution probability (Replaces the old Binomdist function).
NEGBINOM.DISTReturns the negative binomial distribution (Replaces the old Negbinomdist function).
BINOM.INVReturns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (Replaces the old Critbinom function).
CHISQ.DIST.RTReturns the right-tailed probability of the chi-squared distribution (Replaces the old Chidist function).
CHISQ.DISTReturns the chi-squared distribution (probability density or cumulative distribution function).
CHISQ.INV.RTReturns the inverse of the right-tailed probability of the chi-squared distribution (Replaces the old Chiinv function).
CHISQ.INVReturns the inverse of the left-tailed probability of the chi-squared distribution.
CHISQ.TESTReturns the chi-squared statistical test for independence (Replaces the old Chitest function).
EXPON.DISTReturns the exponential distribution (Replaces the old Expondist function).
F.DISTReturns the F probability distribution (probability density or cumulative distribution function).
F.INV.RTReturns the inverse of the right-tailed F probability distribution for two data sets (Replaces the old Finv function).
F.INVReturns the inverse of the Cumulative F distribution.
F.TESTReturns the result of an F-Test for 2 supplied data sets (Replaces the old Ftest function).
GAMMA.DISTReturns the gamma distribution (Replaces the old Gammadist function).
GAMMA.INVReturns the inverse gamma cumulative distribution (Replaces the old Gammainv function).
GAMMALN.PRECISEReturns the natural logarithm of the gamma function for a supplied value.
HYPGEOM.DISTReturns the hypergeometric distribution (Replaces the old Hypgeomdist function).
LOGNORM.DISTReturns the log-normal probability density function or the cumulative log- normal distribution (Replaces the old Lognormdist function).
LOGNORM.INVReturns the inverse of the lognormal distribution (Replaces the old Loginv function).
NORM.DISTReturns the normal cumulative distribution (Replaces the old Normdist function).
NORM.INVReturns the inverse of the normal cumulative distribution (Replaces the old Norminv function).
NORM.S.DISTReturns the standard normal cumulative distribution (Replaces the old Normsdist function).
NORM.S.INVReturns the inverse of the standard normal cumulative distribution (Replaces the old Normsinv function).
POISSON.DISTReturns the Poisson distribution (Replaces the old Poisson function).
T.DIST.2TReturns the two-tailed Student's T-distribution (Replaces the old Tdist function).
T.DIST.RTReturns the right-tailed Student's T-distribution (Replaces the old Tdist function).
T.DISTReturns the Student's T-distribution (probability density or cumulative distribution function).
T.INV.2TReturns the two-tailed inverse of the Student's T-distribution (Replaces the old Tinv function).
T.INVReturns the left-tailed inverse of the Student's T-distribution.
T.TESTReturns the probability associated with a Student's T-Test (Replaces the old Ttest function).
WEIBULL.DISTReturns the Weibull distribution (Replaces the old Weibull function).
Z.TESTReturns the one-tailed probability value of a z-test (Replaces the old Ztest function).
Engineering Functions
ERF.PRECISEReturns the error function integrated between 0 and a supplied limit.
ERFC.PRECISEReturns the complementary error function integrated between a supplied lower limit and infinity.