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.

Return to the list of All Excel Built-In Functions
Return to the ExcelFunctions.net Home Page