Compatibility
★ 15 · ◉ 33 · Excel 2007 (Compatibility)
=NORMSDIST()
Returns the standard normal cumulative distribution function.
=NORMSDIST(z)
Reporting
Statistical
★ 15 · ◉ 31 · Excel 2010
=MODE.MULT()
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
=MODE.MULT((number1,[number2],...)
Descriptive Statistics
Statistical
★ 15 · ◉ 31 · Excel 2010
=PERCENTILE.EXC()
The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
=PERCENTILE.EXC(array,k)
Ranking & Top N
Descriptive Statistics
Math & Trig
★ 15 · ◉ 30 · All versions
=LN()
Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).
=LN(number)
Scientific & Unit Conversion
Math & Trig
★ 15 · ◉ 30 · All versions
=ODD()
Returns number rounded up to the nearest odd integer.
=ODD(number)
Rounding & Numeric
Financial
★ 15 · ◉ 29 · Excel 2013
=PDURATION()
Returns the number of periods required by an investment to reach a specified value.
=PDURATION(rate, pv, fv)
Financial Calculations
Investment Appraisal
Information
★ 15 · ◉ 29 · Excel 2013
=STOCKHISTORY()
STOCKHISTORY function
=STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [property0], [property1], [property2], [property3], [property4], [property5])
Daily Tasks
Compatibility
★ 15 · ◉ 29 · All versions
=VAR()
Estimates variance based on a sample. VAR assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance by using VARP. Arguments can either be numbers or names, arrays, or references that contain numbers. This function has been replaced with one or more new functions. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
=VAR(number1,[number2],...)
Descriptive Statistics
Statistical
★ 15 · ◉ 28 · All versions
=GROWTH()
Calculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values. You can also use the GROWTH worksheet function to fit an exponential curve to existing x-values and y-values.
=GROWTH(known_y's, [known_x's], [new_x's], [const])
Forecasting & Trends
Compatibility
★ 15 · ◉ 28 · Excel 2007 (Compatibility)
=HYPGEOMDIST()
HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size. Use HYPGEOMDIST for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood.
=HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)
Reporting
Text
★ 15 · ◉ 28 · All versions
=BAHTTEXT()
Converts a number to Thai text and adds a suffix of "Baht." You can change the Baht format to a different style in the Excel desktop application by using Regional and Language Options (Windows Start menu, Control Panel).
=BAHTTEXT(number)
Text Manipulation
Engineering
★ 15 · ◉ 28 · All versions
=OCT2BIN()
Converts an octal number to binary.
=OCT2BIN(number, [places])
Scientific & Unit Conversion
Math & Trig
★ 15 · ◉ 26 · All versions
=EXP()
Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm.
=EXP(number)
Scientific & Unit Conversion
Financial
★ 15 · ◉ 24 · All versions
=PRICE()
Returns the price per $100 face value of a security that pays periodic interest.
=PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Text
★ 15 · ◉ 22 · All versions
=CALL()
value returned by a previously executed REGISTER or REGISTER.ID function.
=CALL(register_id,[argument1],...)
Advanced Formulas
Financial
★ 15 · ◉ 21 · All versions
=YIELD()
Returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield.
=YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Lookup & Reference
★ 15 · ◉ 20 · Excel for Microsoft 365
=FIELDVALUE()
The FIELDVALUE function can be used inside other formulas to extract field data from linked records. This article explains how.
=FIELDVALUE(value, field_name)
External Data, Web & Cube
Compatibility
★ 15 · ◉ 19 · Excel 2007 (Compatibility)
=BINOMDIST()
Returns the individual term binomial distribution probability.
=BINOMDIST(number_s,trials,probability_s,cumulative)
Reporting
Web
★ 15 · ◉ 19 · Microsoft 365
=IMPORTTEXT()
IMPORTTEXT function
=IMPORTTEXT(path, [delimiter], [skip_rows], [take_rows], [encoding], [locale])
External Data, Web & Cube
Compatibility
★ 14 · ◉ 38 · Excel 2007 (Compatibility)
=EXPONDIST()
Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPONDIST to determine the probability that the process takes at most 1 minute.
=EXPONDIST(x,lambda,cumulative)
Descriptive Statistics
Compatibility
★ 14 · ◉ 30 · Excel 2007 (Compatibility)
=NUMBERVALUE()
Converts text to a number, in a locale-independent way.
=NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])
Reporting
Compatibility
★ 13 · ◉ 35 · Excel 2007 (Compatibility)
=LOGINV()
Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x. Use the lognormal distribution to analyze logarithmically transformed data. For more information about the new function, see LOGNORM.INV function.
=LOGINV(probability, mean, standard_dev)
Reporting
Web
★ 12 · ◉ 63 · Excel 2013
=ENCODEURL()
The ENCODEURL function returns a URL-encoded string, replacing certain non-alphanumeric characters with the percentage symbol (%) and a hexadecimal number.
=ENCODEURL(text)
External Data, Web & Cube
Statistical
★ 12 · ◉ 49 · Excel 2010
=POISSON.DIST()
Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.
=POISSON.DIST(x,mean,cumulative)
Probability & Hypothesis Testing
Web
★ 12 · ◉ 42 · Excel 2013
=FILTERXML()
The FILTERXML function returns specific data from XML content by using the specified xpath.
=FILTERXML(xml, xpath)
Text Manipulation
External Data, Web & Cube
Logical
★ 12 · ◉ 37 · Excel 365
=MAKEARRAY()
Returns a calculated array of a specified row and column size, by applying a LAMBDA function
=MAKEARRAY(rows, cols, lambda(row, col))
Numbering & Sample Data
Advanced Formulas
Cube
★ 12 · ◉ 35 · Excel 2007
=CUBESETCOUNT()
Returns the number of items in a set.
=CUBESETCOUNT(set)
External Data, Web & Cube
Statistical
★ 12 · ◉ 35 · All versions
=STANDARDIZE()
Returns a normalized value from a distribution characterized by mean and standard_dev.
=STANDARDIZE(x, mean, standard_dev)
Descriptive Statistics
Probability & Hypothesis Testing
Compatibility
★ 12 · ◉ 34 · Excel 2007 (Compatibility)
=GAMMAINV()
Returns the inverse of the gamma cumulative distribution. If p = GAMMADIST(x,...), then GAMMAINV(p,...) = x. You can use this function to study a variable whose distribution may be skewed.
=GAMMAINV(probability,alpha,beta)
Reporting
Statistical
★ 12 · ◉ 33 · Excel 2010
=COVARIANCE.S()
Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.
=COVARIANCE.S(array1,array2)
Descriptive Statistics
Statistical
★ 12 · ◉ 32 · All versions
=MAXA()
Returns the largest value in a list of arguments. MAXA is similar to MINA. For more information, see the examples for the MINA function.
=MAXA(value1,[value2],...)
Descriptive Statistics
Compatibility
★ 12 · ◉ 32 · Excel 2007 (Compatibility)
=TDIST()
Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution. For more information about the new functions, see T.DIST.2T function and T.DIST.RT function.
=TDIST(x,deg_freedom,tails)
Reporting
Statistical
★ 12 · ◉ 31 · Excel 2010
=QUARTILE.EXC()
QUARTILE.EXC returns the quartile of the data set, based on percentile values from 0..1, exclusive.
=QUARTILE.EXC(array, quart)
Ranking & Top N
Descriptive Statistics
Math & Trig
★ 12 · ◉ 30 · All versions
=FACT()
Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number.
=FACT(number)
Scientific & Unit Conversion
Statistical
★ 12 · ◉ 29 · Excel 2010
=CONFIDENCE.T()
Returns the confidence interval for a population mean, using a Student's t distribution.
=CONFIDENCE.T(alpha,standard_dev,size)
Probability & Hypothesis Testing
Financial
★ 12 · ◉ 27 · Excel 2007 (Compatibility)
=EUROCONVERT()
Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation). The currencies available for conversion are those of European Union (EU) members that have adopted the euro. The function uses fixed conversion rates that are established by the EU. If this function is not available, and returns the #NAME? error, install and load the Euro Currency Tools Add-in. Install and load the Euro Currency Tools Add-in add-in
=EUROCONVERT(number,source,target,full_precision,triangulation_precision)
Reporting
Statistical
★ 12 · ◉ 26 · Excel 2010
=COVARIANCE.P()
Returns population covariance, the average of the products of deviations for each data point pair in two data sets. Use covariance to determine the relationship between two data sets.
=COVARIANCE.P(array1,array2)
Descriptive Statistics
Compatibility
★ 12 · ◉ 21 · Excel 2007 (Compatibility)
=REGISTER.ID()
Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered. If the DLL or code resource has not been registered, this function registers the DLL or code resource and then returns the register ID. REGISTER.ID can be used on worksheets (unlike REGISTER), but you cannot specify a function name and argument names with REGISTER.ID. For more information about DLLs and code resources and data types, see Using the CALL and REGISTER functions.
=REGISTER.ID(module_text,procedure,[type_text])
Reporting
Compatibility
★ 11 · ◉ 32 · Excel 2007 (Compatibility)
=TINV()
Returns the two-tailed inverse of the Student's t-distribution. This function is provided for backward compatibility; consider using the T.INV.2T function instead.
=TINV(probability,deg_freedom)
Reporting
Information
★ 10 · ◉ 68 · All versions
=ERROR.TYPE()
Returns a number corresponding to one of the error values in Microsoft Excel or returns the #N/A error if no error exists. You can use ERROR.TYPE in an IF function to test for an error value and return a text string, such as a message, instead of the error value.
=ERROR.TYPE(error_val)
Error Handling
Logical
★ 10 · ◉ 54 · All versions
=FALSE()
Returns the logical value FALSE.
=FALSE()
Conditional Logic
Text
★ 10 · ◉ 52 · Excel 2021
=ARRAYTOTEXT()
Accepts any array and returns the text representations of the array values.
=ARRAYTOTEXT(array, [format])
Text Manipulation
Math & Trig
★ 10 · ◉ 51 · All versions
=GCD()
Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
=GCD(number1, [number2], ...)
Rounding & Numeric
Scientific & Unit Conversion
Math & Trig
★ 10 · ◉ 51 · All versions
=RADIANS()
Converts degrees to radians.
=RADIANS(angle)
Scientific & Unit Conversion
Statistical
★ 10 · ◉ 47 · Excel 2010
=CHISQ.TEST()
The CHISQ.TEXT function returns the test for independence. It returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom. You can use χ2 tests to determine whether hypothesized results are verified by an experiment.
=CHISQ.TEST(actual_range,expected_range)
Probability & Hypothesis Testing
Text
★ 10 · ◉ 46 · All versions
=T()
Returns the text referred to by value.
=T(value)
Text Manipulation
Error Handling
Information
★ 10 · ◉ 44 · All versions
=N()
Returns a value converted to a number.
=N(value)
Error Handling
Statistical
★ 10 · ◉ 41 · Excel 2016
=FORECAST.ETS.CONFINT()
Returns a confidence interval for the forecast value at the specified target date.
=FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])
Forecasting & Trends
Math & Trig
★ 10 · ◉ 40 · All versions
=COS()
Returns the cosine of the given angle.
=COS(number)
Scientific & Unit Conversion
Math & Trig
★ 10 · ◉ 40 · All versions
=POWER()
(number, power)
=POWER(number, power)
Rounding & Numeric
Scientific & Unit Conversion
Math & Trig
★ 10 · ◉ 38 · All versions
=MMULT()
The MMULT function returns the matrix product or multiplication of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. The way you enter the formula depends on which version of Office 365 you are using.
=MMULT(array1, array2)
Advanced Formulas
Scientific & Unit Conversion
Compatibility
★ 10 · ◉ 38 · Excel 2007 (Compatibility)
=ZTEST()
Returns the one-tailed probability-value of a z-test. For a given hypothesized population mean, μ0, ZTEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.
=ZTEST(array,x,[sigma])
Reporting
Statistical
★ 10 · ◉ 36 · All versions
=AVERAGEA()
Calculates the average (arithmetic mean) of the values in the list of arguments.
=AVERAGEA(value1, [value2], ...)
Descriptive Statistics
Statistical
★ 10 · ◉ 36 · All versions
=PEARSON()
Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.
=PEARSON(array1, array2)
Descriptive Statistics
Lookup & Reference
★ 10 · ◉ 33 · Excel 365
=EXPAND()
EXPAND Function
=Expand(array, rows, [columns], [pad_with])
Reshape Tables
Math & Trig
★ 10 · ◉ 33 · All versions
=SIN()
Returns the sine of the given angle.
=SIN(number)
Scientific & Unit Conversion
Text
★ 10 · ◉ 32 · Excel 365
=DETECTLANGUAGE()
With the DETECTLANGUAGE() function, you can easily identify the language used in a specified text or range. This function uses Microsoft Translation Services.
=DETECTLANGUAGE(text)
Text Manipulation
Compatibility
★ 10 · ◉ 30 · Excel 2007 (Compatibility)
=COT()
Return the cotangent of an angle specified in radians.
=COT(number)
Reporting
Financial
★ 10 · ◉ 30 · All versions
=DURATION()
Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price's response to changes in yield.
=DURATION(settlement, maturity, coupon, yld, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 10 · ◉ 30 · All versions
=ISPMT()
Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments.
=ISPMT(rate, per, nper, pv)
Financial Calculations
Loans & Installments