How many functions does excel include

Statistical: Returns the maximum value among cells specified by a given set of conditions or criteria. Math and trigonometry: Returns the matrix determinant of an array. Statistical: Returns the median of the given numbers. Text: Returns a specific number of characters from a text string starting at the position you specify. MIN function. Statistical: Returns the minimum value in a list of arguments.

Statistical: Returns the minimum value among cells specified by a given set of conditions or criteria. MINA function. Statistical: Returns the smallest value in a list of arguments, including numbers, text, and logical values.

Date and time: Converts a serial number to a minute. Math and trigonometry: Returns the matrix inverse of an array. MIRR function. Financial: Returns the internal rate of return where positive and negative cash flows are financed at different rates.

MMULT function. Math and trigonometry: Returns the matrix product of two arrays. MOD function. Math and trigonometry: Returns the remainder from division. MODE function. Compatibility: Returns the most common value in a data set. MULT function.

Statistical: Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data. SNGL function. Statistical: Returns the most common value in a data set. MONTH function. Date and time: Converts a serial number to a month.

Math and trigonometry: Returns a number rounded to the desired multiple. Math and trigonometry: Returns the multinomial of a set of numbers. MUNIT function. Math and trigonometry: Returns the unit matrix or the specified dimension. N function. Information: Returns a value converted to a number. NA function.

Statistical: Returns the negative binomial distribution. Compatibility: Returns the negative binomial distribution. Date and time: Returns the number of whole workdays between two dates. INTL function.

Date and time: Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Financial: Returns the annual nominal interest rate. Statistical: Returns the normal cumulative distribution.

Compatibility: Returns the normal cumulative distribution. Statistical: Returns the inverse of the normal cumulative distribution. Compatibility: Returns the inverse of the normal cumulative distribution.

Statistical: Returns the standard normal cumulative distribution. Compatibility: Returns the standard normal cumulative distribution. Statistical: Returns the inverse of the standard normal cumulative distribution. Compatibility: Returns the inverse of the standard normal cumulative distribution. NOT function. NOW function.

Date and time: Returns the serial number of the current date and time. NPER function. Financial: Returns the number of periods for an investment.

NPV function. Financial: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate. Text: Converts text to number in a locale-independent manner. Engineering: Converts an octal number to binary. Engineering: Converts an octal number to decimal. Engineering: Converts an octal number to hexadecimal.

ODD function. Math and trigonometry: Rounds a number up to the nearest odd integer. Financial: Returns the yield of a security with an odd first period. Financial: Returns the yield of a security with an odd last period. Lookup and reference: Returns a reference offset from a given reference.

OR function. Financial: Returns the number of periods required by an investment to reach a specified value. Statistical: Returns the Pearson product moment correlation coefficient.

EXC function. Statistical: Returns the k-th percentile of values in a range, where k is in the range INC function. Statistical: Returns the k-th percentile of values in a range. Compatibility: Returns the k-th percentile of values in a range.

Statistical: Returns the rank of a value in a data set as a percentage Statistical: Returns the percentage rank of a value in a data set. Compatibility: Returns the percentage rank of a value in a data set. Statistical: Returns the number of permutations for a given number of objects. Statistical: Returns the number of permutations for a given number of objects with repetitions that can be selected from the total objects. PHI function. Statistical: Returns the value of the density function for a standard normal distribution.

Text: Extracts the phonetic furigana characters from a text string. PI function. Math and trigonometry: Returns the value of pi.

PMT function. Financial: Returns the periodic payment for an annuity. Compatibility: Returns the Poisson distribution. POWER function. Math and trigonometry: Returns the result of a number raised to a power. PPMT function. Financial: Returns the payment on the principal for an investment for a given period. PRICE function. PROB function. Statistical: Returns the probability that values in a range are between two limits. Math and trigonometry: Multiplies its arguments. Text: Capitalizes the first letter in each word of a text value.

PV function. Financial: Returns the present value of an investment. Compatibility: Returns the quartile of a data set. Statistical: Returns the quartile of the data set, based on percentile values from Statistical: Returns the quartile of a data set.

Math and trigonometry: Returns the integer portion of a division. Math and trigonometry: Converts degrees to radians. RAND function. Math and trigonometry: Returns a random number between 0 and 1. Math and trigonometry: Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.

Math and trigonometry: Returns a random number between the numbers you specify. AVG function. Statistical: Returns the rank of a number in a list of numbers. EQ function.

RANK function. Compatibility: Returns the rank of a number in a list of numbers. RATE function. Financial: Returns the interest rate per period of an annuity.

Financial: Returns the amount received at maturity for a fully invested security. ID function. Add-in and Automation: Returns the register ID of the specified dynamic link library DLL or code resource that has been previously registered.

REPT function. Text: Returns the rightmost characters from a text value. ROMAN function. Math and trigonometry: Converts an arabic numeral to roman, as text. ROUND function. Math and trigonometry: Rounds a number to a specified number of digits. Math and trigonometry: Rounds a number down, toward zero. Math and trigonometry: Rounds a number up, away from zero. ROW function. Lookup and reference: Returns the row number of a reference.

ROWS function. Lookup and reference: Returns the number of rows in a reference. RRI function. Financial: Returns an equivalent interest rate for the growth of an investment. RSQ function. Statistical: Returns the square of the Pearson product moment correlation coefficient. RTD function. Lookup and reference: Retrieves real-time data from a program that supports COM automation. Text: Finds one text value within another not case-sensitive.

SEC function. Math and trigonometry: Returns the secant of an angle. SECH function. Math and trigonometry: Returns the hyperbolic secant of an angle. Date and time: Converts a serial number to a second. Math and trigonometry: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4. Math and trigonometry: Returns the sum of a power series based on the formula.

SHEET function. Information: Returns the sheet number of the referenced sheet. Information: Returns the number of sheets in a reference. SIGN function. Math and trigonometry: Returns the sign of a number. SIN function. Math and trigonometry: Returns the sine of the given angle. SINH function. Math and trigonometry: Returns the hyperbolic sine of a number.

SKEW function. Statistical: Returns the skewness of a distribution. Statistical: Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean.

SLN function. Financial: Returns the straight-line depreciation of an asset for one period. SLOPE function. Statistical: Returns the slope of the linear regression line. SMALL function. Statistical: Returns the k-th smallest value in a data set.

SORT function. Lookup and reference: Sorts the contents of a range or array. Lookup and reference: Sorts the contents of a range or array based on the values in a corresponding range or array. SQRT function. Math and trigonometry: Returns a positive square root. STDEV function. Compatibility: Estimates standard deviation based on a sample. Statistical: Calculates standard deviation based on the entire population. Statistical: Estimates standard deviation based on a sample.

Statistical: Estimates standard deviation based on a sample, including numbers, text, and logical values. Compatibility: Calculates standard deviation based on the entire population.

Statistical: Calculates standard deviation based on the entire population, including numbers, text, and logical values. STEYX function. Statistical: Returns the standard error of the predicted y-value for each x in the regression.

Text: Substitutes new text for old text in a text string. Math and trigonometry: Returns a subtotal in a list or database. SUM function. SUMIF function. Math and trigonometry: Adds the cells specified by a given criteria.

Math and trigonometry: Adds the cells in a range that meet multiple criteria. Math and trigonometry: Returns the sum of the products of corresponding array components. SUMSQ function. Math and trigonometry: Returns the sum of the squares of the arguments.

Math and trigonometry: Returns the sum of the difference of squares of corresponding values in two arrays. Math and trigonometry: Returns the sum of the sum of squares of corresponding values in two arrays.

Math and trigonometry: Returns the sum of squares of differences of corresponding values in two arrays. Logical: Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. SYD function. Financial: Returns the sum-of-years' digits depreciation of an asset for a specified period.

TAN function. Math and trigonometry: Returns the tangent of a number. TANH function. Math and trigonometry: Returns the hyperbolic tangent of a number. Financial: Returns the bond-equivalent yield for a Treasury bill. Financial: Returns the yield for a Treasury bill. Statistical: Returns the Percentage Points probability for the Student t-distribution. Statistical: Returns the Student's t-distribution. TDIST function. Compatibility: Returns the Student's t-distribution. TEXT function.

Text: Formats a number and converts it to text. If the delimiter is an empty text string, this function will effectively concatenate the ranges. TIME function. Date and time: Returns the serial number of a particular time. Date and time: Converts a time in the form of text to a serial number. Statistical: Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. Statistical: Returns the inverse of the Student's t-distribution. TINV function.

Compatibility: Returns the inverse of the Student's t-distribution. TODAY function. Date and time: Returns the serial number of today's date. Lookup and reference: Returns the transpose of an array. TREND function. Statistical: Returns values along a linear trend. TRIM function. Statistical: Returns the mean of the interior of a data set.

TRUE function. TRUNC function. Math and trigonometry: Truncates a number to an integer. Statistical: Returns the probability associated with a Student's t-test.

TTEST function. Compatibility: Returns the probability associated with a Student's t-test. Information: Returns a number indicating the data type of a value. Text: Returns the Unicode character that is references by the given numeric value.

Text: Returns the number code point that corresponds to the first character of the text. Lookup and reference: Returns a list of unique values in a list or range.

UPPER function. VALUE function. VAR function. Compatibility: Estimates variance based on a sample. Statistical: Calculates variance based on the entire population. Statistical: Estimates variance based on a sample. VARA function.

Statistical: Estimates variance based on a sample, including numbers, text, and logical values. VARP function. Compatibility: Calculates variance based on the entire population. VARPA function. That's because the formula treats the entire function as a single value—before it can use that value in the formula, it needs to run the function. For example, in the formula below, the SUM function will be calculated before division:.

These are known as nested functions , since one function is placed, or nested , within the arguments of another. As a rule, the nested function is always calculated first , just like parentheses are performed first in the order of operations.

There are many other functions you can use to quickly calculate different things with your data. Learning how to use other functions will allow you to solve complex problems with your spreadsheets, and we'll be talking more about them throughout this tutorial.

You can also check out our articles below to learn about specific functions:. Inc function in Excel Returns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 inclusive New in Excel - replaces the Percentile function.

Returns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 exclusive New in Excel Returns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 inclusive Replaced by Quartile.

Returns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 inclusive New in Excel - replaces the Quartile function. Returns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 exclusive New in Excel Returns the statistical rank of a given value, within a supplied array of values Replaced by Rank. Eq function in Excel 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 New in Excel - replaces the Rank function.

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 New in Excel Returns the rank of a value in a data set, as a percentage 0 - 1 inclusive Replaced by Percentrank. Returns the rank of a value in a data set, as a percentage 0 - 1 inclusive New in Excel - replaces the Percentrank function. Returns the rank of a value in a data set, as a percentage 0 - 1 exclusive New in Excel Returns the average of the absolute deviations of data points from their mean.

Returns the sum of the squares of the deviations of a set of data points from their sample mean. Returns the standard deviation of a supplied set of values which represent a sample of a population Replaced by Stdev. S function in Excel Returns the standard deviation of a supplied set of values which represent a sample of a population New in Excel - replaces the Stdev function.

Returns the standard deviation of a supplied set of values which represent a sample of a population , counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1. Returns the standard deviation of a supplied set of values which represent an entire population Replaced by Stdev. P function in Excel Returns the standard deviation of a supplied set of values which represent an entire population New in Excel - replaces the Stdevp function. Returns the standard deviation of a supplied set of values which represent an entire population , counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1.

Returns the variance of a supplied set of values which represent a sample of a population Replaced by Var. Returns the variance of a supplied set of values which represent a sample of a population New in Excel - replaces the Var function. Returns the variance of a supplied set of values which represent a sample of a population , counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1.

Returns the variance of a supplied set of values which represent an entire population Replaced by Var. Returns the variance of a supplied set of values which represent an entire population New in Excel - replaces the Varp function.

Returns the variance of a supplied set of values which represent an entire population , counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1. Returns population covariance i. Returns sample covariance i. Predicts a future point on a linear trend line fitted to a supplied set of x- and y- values Replaced by Forecast. Linear function in Excel Uses an exponential smoothing algorithm to predict a future value on a timeline, based on a series of existing values New in Excel - not available in Excel for Mac.

Returns a confidence interval for a forecast value at a specified target date New in Excel - not available in Excel for Mac. Returns the length of the repetitive pattern Excel detects for a specified time series New in Excel - not available in Excel for Mac. Returns a statistical value relating to a time series forecasting New in Excel - not available in Excel for Mac.

Predicts a future point on a linear trend line fitted to a supplied set of x- and y- values New in Excel not Excel for Mac - replaces the Forecast function.

Calculates the best fit regression line, through a supplied series of x- and y- values and returns the value at which this line intercepts the y-axis. Returns statistical information describing the trend of the line of best fit, through a supplied series of x- and y- values. Returns the slope of the linear regression line through a supplied series of x- and y- values.

Calculates the trend line through a given set of y-values and returns additional y-values for a supplied set of new x-values. Returns numbers in a exponential growth trend, based on a set of supplied x- and y- values. Returns the parameters of an exponential trend for a supplied set of x- and y- values. Returns the standard error of the predicted y-value for each x in the regression line for a set of supplied x- and y- values.

Returns the largest value from a subset of values in a list that are specified according to one or more criteria. Returns the smallest value from a subset of values in a list that are specified according to one or more criteria. Calculates the Average of the cells in a supplied range, that satisfy a given criteria New in Excel Calculates the Average of the cells in a supplied range, that satisfy multiple criteria New in Excel Returns the Mode the most frequently occurring value of a list of supplied numbers Replaced by Mode.

Sngl function in Excel Returns the Mode the most frequently occurring value of a list of supplied numbers New in Excel - replaces the Mode function. Returns a vertical array of the most frequently occurring values in an array or range of data New in Excel Returns the cumulative beta probability density function Replaced by Beta. Dist function in Excel Returns the cumulative beta distribution function or the beta probability density function New in Excel - replaces the Betadist function.

Returns the inverse of the cumulative beta probability density function Replaced by Beta. Inv function in Excel Returns the inverse of the cumulative beta probability density function New in Excel - replaces the Betainv function.

Returns the individual term binomial distribution probability Replaced by Binom. Returns the individual term binomial distribution probability New in Excel - replaces the Binomdist function. Returns the probability of a trial result using a binomial distribution New in Excel Returns the negative binomial distribution Replaced by Negbinom. Returns the negative binomial distribution New in Excel - replaces the Negbinomdist function. Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value Replaced by Binom.

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value New in Excel - replaces the Critbinom function. Returns the right-tailed probability of the chi-squared distribution Replaced by Chisq.

Rt function in Excel Returns the right-tailed probability of the chi-squared distribution New in Excel - replaces the Chidist function. Returns the chi-squared distribution probability density or cumulative distribution function New in Excel Returns the inverse of the right-tailed probability of the chi-squared distribution Replaced by Chisq.

Returns the inverse of the right-tailed probability of the chi-squared distribution New in Excel - replaces the Chiinv function. Returns the inverse of the left-tailed probability of the chi-squared distribution New in Excel Returns the chi-squared statistical test for independence Replaced by Chisq. Test function in Excel Returns the chi-squared statistical test for independence New in Excel - replaces the Chitest function. Returns the exponential distribution Replaced by Expon.

Returns the exponential distribution New in Excel - replaces the Expondist function. Returns the right-tailed F probability distribution for two data sets Replaced by F. Returns the right-tailed F probability distribution for two data sets New in Excel - replaces the Fdist function.

Returns the F probability distribution probability density or cumulative distribution function New in Excel Returns the inverse of the right-tailed F probability distribution for two data sets Replaced by F.

Returns the inverse of the right-tailed F probability distribution for two data sets New in Excel - replaces the Finv function. Returns the inverse of the Cumulative F distribution New in Excel Returns the result of an F-Test for 2 supplied data sets Replaced by F.

Returns the result of an F-Test for 2 supplied data sets New in Excel - replaces the Ftest function. Returns the gamma distribution Replaced by Gamma. Returns the gamma distribution New in Excel - replaces the Gammadist function. Returns the inverse gamma cumulative distribution Replaced by Gamma. Returns the inverse gamma cumulative distribution New in Excel - replaces the Gammainv function.

Return the gamma function value for a supplied number New in Excel Calculates the natural logarithm of the gamma function for a supplied value. Returns the natural logarithm of the gamma function for a supplied value New in Excel Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean New in Excel Returns the hypergeometric distribution Replaced by Hypgeom. Returns the hypergeometric distribution New in Excel - replaces the Hypgeomdist function.

Returns the cumulative log-normal distribution Replaced by Lognorm. Returns the log-normal probability density function or the cumulative log- normal distribution New in Excel - replaces the Lognormdist function.

Returns the inverse of the lognormal distribution Replaced by Lognorm. Returns the inverse of the lognormal distribution New in Excel - replaces the Loginv function. Returns the normal cumulative distribution Replaced by Norm.