New Functions in 2010
Excel 2010 introducted 63 new worksheet functions.
| AGGREGATE | Returns an aggregate in a list or database. Replaces SUBTOTAL |
| ASC | Returns the text string converted from double byte to single byte characters. |
| 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 | Returns the number rounded up to the nearest integer or significant figure. Replaces CEILING |
| 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. |
| DBCS | Returns the text string converted from single byte to double byte characters. |
| 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. Replaces FDIST |
| F.DIST.RT | Returns the F probability distribution. Replaces FDIST |
| F.INV | Returns the inverse of the F probability distribution. Replaces FINV |
| 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 | Returns the number rounded down to the nearest integer or significant figure. Replaces FLOOR |
| 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). Replaces GAMMALN |
| 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 total number of working days between two dates excluding weekends and holidays. 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 value in a list, table or cell range (in descending order) (average ranking). |
| 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 |
| AGGREGATE Returns an aggregate in a list or database. Replaces SUBTOTAL |
| ASC Returns the text string converted from double byte to single byte characters. |
| 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 Returns the number rounded up to the nearest integer or significant figure. Replaces CEILING |
| 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. |
| DBCS Returns the text string converted from single byte to double byte characters. |
| 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. Replaces FDIST |
| F.DIST.RT Returns the F probability distribution. Replaces FDIST |
| F.INV Returns the inverse of the F probability distribution. Replaces FINV |
| 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 Returns the number rounded down to the nearest integer or significant figure. Replaces FLOOR |
| 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). Replaces GAMMALN |
| 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 total number of working days between two dates excluding weekends and holidays. 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 value in a list, table or cell range (in descending order) (average ranking). |
| 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 |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext