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.INTL Returns 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.INTL Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days.
Math Functions
AGGREGATE Performs 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.PRECISE Rounds a number up, regardless of the sign of the number, to a multiple of significance.
ISO.CEILING Rounds a number up, regardless of the sign of the number, to a multiple of significance.
FLOOR.PRECISE Rounds a number down, regardless of the sign of the number, to a multiple of significance.
Statistical Functions
PERCENTILE.INC Returns 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.EXC Returns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (exclusive).
QUARTILE.INC Returns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (Replaces the old Quartile function).
QUARTILE.EXC Returns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (exclusive).
RANK.EQ Returns 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.AVG Returns 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.INC Returns the rank of a value in a data set, as a percentage (0 - 1 inclusive) (Replaces the old Percentrank function).
PERCENTRANK.EXC Returns the rank of a value in a data set, as a percentage (0 - 1 exclusive).
MODE.SNGL Returns the Mode (the most frequently occurring value) of a list of supplied numbers (Replaces the old Mode function).
MODE.MULT Returns a vertical array of the most frequently occurring values in an array or range of data.
STDEV.S Returns the standard deviation of a supplied set of values (which represent a sample of a population) (Replaces the old Stdev function).
STDEV.P Returns the standard deviation of a supplied set of values (which represent an entire population) (Replaces the old Stdevp function).
VAR.S Returns the variance of a supplied set of values (which represent a sample of a population) (Replaces the old Var function).
VAR.P Returns the variance of a supplied set of values (which represent an entire population) (Replaces the old Varp function).
COVARIANCE.P Returns 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.S Returns sample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets).
CONFIDENCE.NORM Returns the confidence interval for a population mean, using a normal distribution (Replaces the old Confidence function).
CONFIDENCE.T Returns the confidence interval for a population mean, using a Student's t distribution.
BETA.DIST Returns the cumulative beta distribution function or the beta probability density function (Replaces the old Betadist function).
BETA.INV Returns the inverse of the cumulative beta probability density function (Replaces the old Betainv function).
BINOM.DIST Returns the individual term binomial distribution probability (Replaces the old Binomdist function).
NEGBINOM.DIST Returns the negative binomial distribution (Replaces the old Negbinomdist function).
BINOM.INV Returns 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.RT Returns the right-tailed probability of the chi-squared distribution (Replaces the old Chidist function).
CHISQ.DIST Returns the chi-squared distribution (probability density or cumulative distribution function).
CHISQ.INV.RT Returns the inverse of the right-tailed probability of the chi-squared distribution (Replaces the old Chiinv function).
CHISQ.INV Returns the inverse of the left-tailed probability of the chi-squared distribution.
CHISQ.TEST Returns the chi-squared statistical test for independence (Replaces the old Chitest function).
EXPON.DIST Returns the exponential distribution (Replaces the old Expondist function).
F.DIST Returns the F probability distribution (probability density or cumulative distribution function).
F.INV.RT Returns the inverse of the right-tailed F probability distribution for two data sets (Replaces the old Finv function).
F.INV Returns the inverse of the Cumulative F distribution.
F.TEST Returns the result of an F-Test for 2 supplied data sets (Replaces the old Ftest function).
GAMMA.DIST Returns the gamma distribution (Replaces the old Gammadist function).
GAMMA.INV Returns the inverse gamma cumulative distribution (Replaces the old Gammainv function).
GAMMALN.PRECISE Returns the natural logarithm of the gamma function for a supplied value.
HYPGEOM.DIST Returns the hypergeometric distribution (Replaces the old Hypgeomdist function).
LOGNORM.DIST Returns the log-normal probability density function or the cumulative log- normal distribution (Replaces the old Lognormdist function).
LOGNORM.INV Returns the inverse of the lognormal distribution (Replaces the old Loginv function).
NORM.DIST Returns the normal cumulative distribution (Replaces the old Normdist function).
NORM.INV Returns the inverse of the normal cumulative distribution (Replaces the old Norminv function).
NORM.S.DIST Returns the standard normal cumulative distribution (Replaces the old Normsdist function).
NORM.S.INV Returns the inverse of the standard normal cumulative distribution (Replaces the old Normsinv function).
POISSON.DIST Returns the Poisson distribution (Replaces the old Poisson function).
T.DIST.2T Returns the two-tailed Student's T-distribution (Replaces the old Tdist function).
T.DIST.RT Returns the right-tailed Student's T-distribution (Replaces the old Tdist function).
T.DIST Returns the Student's T-distribution (probability density or cumulative distribution function).
T.INV.2T Returns the two-tailed inverse of the Student's T-distribution (Replaces the old Tinv function).
T.INV Returns the left-tailed inverse of the Student's T-distribution.
T.TEST Returns the probability associated with a Student's T-Test (Replaces the old Ttest function).
WEIBULL.DIST Returns the Weibull distribution (Replaces the old Weibull function).
Z.TEST Returns the one-tailed probability value of a z-test (Replaces the old Ztest function).
Engineering Functions
ERF.PRECISE Returns the error function integrated between 0 and a supplied limit.
ERFC.PRECISE Returns the complementary error function integrated between a supplied lower limit and infinity.