|
Description |
Function |
|
|
| Math and trigonometry |
| Returns the absolute value of a number | ABS | | |
| Returns the arccosine of a number | ACOS | | |
| Returns the inverse hyperbolic cosine of a number | ACOSH | | |
| Returns the arccotangent of a number | ACOT | | |
| Returns the hyperbolic arccotangent of a number | ACOTH | | |
| Returns an aggregate in a list or database | AGGREGATE | | |
| Converts a Roman number to Arabic, as a number | ARABIC | | |
| Returns the arcsine of a number | ASIN | | |
| Returns the inverse hyperbolic sine of a number | ASINH | | |
| Returns the arctangent of a number | ATAN | | |
| Returns the arctangent from x- and y-coordinates | ATAN2 | | |
| Returns the inverse hyperbolic tangent of a number | ATANH | | |
| Converts a number into a text representation with the given radix (base) | BASE | | |
| Rounds a number to the nearest integer or to the nearest multiple of significance | CEILING | | |
| Rounds a number up, to the nearest integer or to the nearest multiple of significance | CEILING.MATH | | |
| Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. | CEILING.PRECISE | | |
| Returns the number of combinations for a given number of objects | COMBIN | | |
| Returns the number of combinations with repetitions for a given number of items | COMBINA | | |
| Returns the cosine of a number | COS | | |
| Returns the hyperbolic cosine of a number | COSH | | |
| Returns the hyperbolic cosine of a number | COT | | |
| Returns the cotangent of an angle | COTH | | |
| Returns the cosecant of an angle | CSC | | |
| Returns the hyperbolic cosecant of an angle | CSCH | | |
| Converts a text representation of a number in a given base into a decimal number | DECIMAL | | |
| Converts radians to degrees | DEGREES | | |
| Rounds a number up to the nearest even integer | EVEN | | |
| Returns e raised to the power of a given number | EXP | | |
| Returns the factorial of a number | FACT | | |
| Returns the double factorial of a number | FACTDOUBLE | | |
| Rounds a number down, to the nearest integer or to the nearest multiple of significance | FLOOR.MATH | | |
| Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. | FLOOR.PRECISE | | |
| Returns the greatest common divisor | GCD | | |
| Rounds a number down to the nearest integer | INT | | |
| Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance | ISO.CEILING | | |
| Returns the least common multiple | LCM | | |
| Returns the natural logarithm of a number | LN | | |
| Returns the logarithm of a number to a specified base | LOG | | |
| Returns the base-10 logarithm of a number | LOG10 | | |
| Returns the matrix determinant of an array | MDETERM | | |
| Returns the matrix inverse of an array | MINVERSE | | |
| Returns the matrix product of two arrays | MMULT | | |
| Returns the remainder from division | MOD | | |
| Returns a number rounded to the desired multiple | MROUND | | |
| Returns the multinomial of a set of numbers | MULTINOMIAL | | |
| Returns the unit matrix or the specified dimension | MUNIT | | |
| Rounds a number up to the nearest odd integer | ODD | | |
| Returns the value of pi | PI | | |
| Returns the result of a number raised to a power | POWER | | |
| Multiplies its arguments | PRODUCT | | |
| Returns the integer portion of a division | QUOTIENT | | |
| Converts degrees to radians | RADIANS | | |
| Returns a random number between 0 and 1 | RAND | | |
| Returns a random number between the numbers you specify | RANDBETWEEN | | |
| Converts an arabic numeral to roman, as text | ROMAN | | |
| Rounds a number to a specified number of digits | ROUND | | |
| Rounds a number down, toward zero | ROUNDDOWN | | |
| Rounds a number up, away from zero | ROUNDUP | | |
| Returns the secant of an angle | SEC | | |
| Returns the hyperbolic secant of an angle | SECH | | |
| Returns the sum of a power series based on the formula | SERIESSUM | | |
| Returns the sign of a number | SIGN | | |
| Returns the sine of the given angle | SIN | | |
| Returns the hyperbolic sine of a number | SINH | | |
| Returns a positive square root | SQRT | | |
| Returns the square root of (number * pi) | SQRTPI | | |
| Returns a subtotal in a list or database | SUBTOTAL | | |
| Adds its arguments | SUM | | |
| Adds the cells specified by a given criteria | SUMIF | | |
| Adds the cells in a range that meet multiple criteria | SUMIFS | | |
| Returns the sum of the products of corresponding array components | SUMPRODUCT | | |
| Returns the sum of the squares of the arguments | SUMSQ | | |
| Returns the sum of the difference of squares of corresponding values in two arrays | SUMX2MY2 | | |
| Returns the sum of the sum of squares of corresponding values in two arrays | SUMX2PY2 | | |
| Returns the sum of squares of differences of corresponding values in two arrays | SUMXMY2 | | |
| Returns the tangent of a number | TAN | | |
| Returns the hyperbolic tangent of a number | TANH | | |
| Truncates a number to an integer | TRUNC | | |
| Text |
| Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters | ASC | | |
| Converts a number to text, using the ? (baht) currency format | BAHTTEXT | | |
| Returns the character specified by the code number | CHAR | | |
| Removes all nonprintable characters from text | CLEAN | | |
| Returns a numeric code for the first character in a text string | CODE | | |
| Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. Note:?This function isn't available in Excel 2016 for Mac. | CONCAT | | |
| Joins several text items into one text item | CONCATENATE | | |
| Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters | DBCS | | |
| Converts a number to text, using the $ (dollar) currency format | DOLLAR | | |
| Checks to see if two text values are identical | EXACT | | |
| Finds one text value within another (case-sensitive) | FIND, FINDB | | |
| Formats a number as text with a fixed number of decimals | FIXED | | |
| Changes half-width (single-byte) characters within a string to full-width (double-byte) characters | JIS | | |
| Returns the leftmost characters from a text value | LEFT, LEFTB | | |
| Returns the number of characters in a text string | LEN, LENB | | |
| Converts text to lowercase | LOWER | | |
| Returns a specific number of characters from a text string starting at the position you specify | MID, MIDB | | |
| Converts text to number in a locale-independent manner | NUMBERVALUE | | |
| Extracts the phonetic (furigana) characters from a text string | PHONETIC | | |
| Capitalizes the first letter in each word of a text value | PROPER | | |
| Replaces characters within text | REPLACE, REPLACEB | | |
| Repeats text a given number of times | REPT | | |
| Returns the rightmost characters from a text value | RIGHT, RIGHTB | | |
| Finds one text value within another (not case-sensitive) | SEARCH, SEARCHB | | |
| Substitutes new text for old text in a text string | SUBSTITUTE | | |
| Converts its arguments to text | T | | |
| Formats a number and converts it to text | TEXT | | |
| Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. Note:?This function isn't available in Excel 2016 for Mac. | TEXTJOIN | | |
| Removes spaces from text | TRIM | | |
| Returns the Unicode character that is references by the given numeric value | UNICHAR | | |
| Returns the number (code point) that corresponds to the first character of the text | UNICODE | | |
| Converts text to uppercase | UPPER | | |
| Converts a text argument to a number | VALUE | | |
| Logical |
| Returns TRUE if all of its arguments are TRUE | AND | | |
| Returns the logical value FALSE | FALSE | | |
| Specifies a logical test to perform | IF | | |
| Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula | IFERROR | | |
| Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression | IFNA | | |
| Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. Note:?This function isn't available in Excel 2016 for Mac. | IFS | | |
| Reverses the logic of its argument | NOT | | |
| Returns TRUE if any argument is TRUE | OR | | |
| 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. Note:?This function isn't available in Excel 2016 for Mac. | SWITCH | | |
| Returns the logical value TRUE | TRUE | | |
| Returns a logical exclusive OR of all arguments | XOR | | |
| Date and time |
| Returns the serial number of a particular date | DATE | | |
| Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. | DATEDIF | | |
| Converts a date in the form of text to a serial number | DATEVALUE | | |
| Converts a serial number to a day of the month | DAY | | |
| Returns the number of days between two dates | DAYS | | |
| Calculates the number of days between two dates based on a 360-day year | DAYS360 | | |
| Returns the serial number of the date that is the indicated number of months before or after the start date | EDATE | | |
| Returns the serial number of the last day of the month before or after a specified number of months | EOMONTH | | |
| Converts a serial number to an hour | HOUR | | |
| Returns the number of the ISO week number of the year for a given date | ISOWEEKNUM | | |
| Converts a serial number to a minute | MINUTE | | |
| Converts a serial number to a month | MONTH | | |
| Returns the number of whole workdays between two dates | NETWORKDAYS | | |
| Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days | NETWORKDAYS.INTL | | |
| Returns the serial number of the current date and time | NOW | | |
| Converts a serial number to a second | SECOND | | |
| Returns the serial number of a particular time | TIME | | |
| Converts a time in the form of text to a serial number | TIMEVALUE | | |
| Returns the serial number of today's date | TODAY | | |
| Converts a serial number to a day of the week | WEEKDAY | | |
| Converts a serial number to a number representing where the week falls numerically with a year | WEEKNUM | | |
| Returns the serial number of the date before or after a specified number of workdays | WORKDAY | | |
| Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days | WORKDAY.INTL | | |
| Converts a serial number to a year | YEAR | | |
| Returns the year fraction representing the number of whole days between start_date and end_date | YEARFRAC | | |
| Lookup and reference |
| Returns a reference as text to a single cell in a worksheet | ADDRESS | | |
| Returns the number of areas in a reference | AREAS | | |
| Chooses a value from a list of values | CHOOSE | | |
| Returns the column number of a reference | COLUMN | | |
| Returns the number of columns in a reference | COLUMNS | | |
| Returns the formula at the given reference as text | FORMULATEXT | | |
| Looks in the top row of an array and returns the value of the indicated cell | HLOOKUP | | |
| Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet | HYPERLINK | | |
| Uses an index to choose a value from a reference or array | INDEX | | |
| Returns a reference indicated by a text value | INDIRECT | | |
| Looks up values in a vector or array | LOOKUP | | |
| Looks up values in a reference or array | MATCH | | |
| Returns a reference offset from a given reference | OFFSET | | |
| Returns the row number of a reference | ROW | | |
| Returns the number of rows in a reference | ROWS | | |
| Retrieves real-time data from a program that supports COM automation | RTD | | |
| Returns the transpose of an array | TRANSPOSE | | |
| Looks in the first column of an array and moves across the row to return the value of a cell | VLOOKUP | | |
| Financial |
| Returns the accrued interest for a security that pays periodic interest | ACCRINT | | |
| Returns the accrued interest for a security that pays interest at maturity | ACCRINTM | | |
| Returns the depreciation for each accounting period by using a depreciation coefficient | AMORDEGRC | | |
| Returns the depreciation for each accounting period | AMORLINC | | |
| Returns the number of days from the beginning of the coupon period to the settlement date | COUPDAYBS | | |
| Returns the number of days in the coupon period that contains the settlement date | COUPDAYS | | |
| Returns the number of days from the settlement date to the next coupon date | COUPDAYSNC | | |
| Returns the next coupon date after the settlement date | COUPNCD | | |
| Returns the number of coupons payable between the settlement date and maturity date | COUPNUM | | |
| Returns the previous coupon date before the settlement date | COUPPCD | | |
| Returns the cumulative interest paid between two periods | CUMIPMT | | |
| Returns the cumulative principal paid on a loan between two periods | CUMPRINC | | |
| Returns the depreciation of an asset for a specified period by using the fixed-declining balance method | DB | | |
| Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify | DDB | | |
| Returns the discount rate for a security | DISC | | |
| Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number | DOLLARDE | | |
| Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction | DOLLARFR | | |
| Returns the annual duration of a security with periodic interest payments | DURATION | | |
| Returns the effective annual interest rate | EFFECT | | |
| Returns the future value of an investment | FV | | |
| Returns the future value of an initial principal after applying a series of compound interest rates | FVSCHEDULE | | |
| Returns the interest rate for a fully invested security | INTRATE | | |
| Returns the interest payment for an investment for a given period | IPMT | | |
| Returns the internal rate of return for a series of cash flows | IRR | | |
| Calculates the interest paid during a specific period of an investment | ISPMT | | |
| Returns the Macauley modified duration for a security with an assumed par value of $100 | MDURATION | | |
| Returns the internal rate of return where positive and negative cash flows are financed at different rates | MIRR | | |
| Returns the annual nominal interest rate | NOMINAL | | |
| Returns the number of periods for an investment | NPER | | |
| Returns the net present value of an investment based on a series of periodic cash flows and a discount rate | NPV | | |
| Returns the price per $100 face value of a security with an odd first period | ODDFPRICE | | |
| Returns the yield of a security with an odd first period | ODDFYIELD | | |
| Returns the price per $100 face value of a security with an odd last period | ODDLPRICE | | |
| Returns the yield of a security with an odd last period | ODDLYIELD | | |
| Returns the number of periods required by an investment to reach a specified value | PDURATION | | |
| Returns the periodic payment for an annuity | PMT | | |
| Returns the payment on the principal for an investment for a given period | PPMT | | |
| Returns the price per $100 face value of a security that pays periodic interest | PRICE | | |
| Returns the price per $100 face value of a discounted security | PRICEDISC | | |
| Returns the price per $100 face value of a security that pays interest at maturity | PRICEMAT | | |
| Returns the present value of an investment | PV | | |
| Returns the interest rate per period of an annuity | RATE | | |
| Returns the amount received at maturity for a fully invested security | RECEIVED | | |
| Returns an equivalent interest rate for the growth of an investment | RRI | | |
| Returns the straight-line depreciation of an asset for one period | SLN | | |
| Returns the sum-of-years' digits depreciation of an asset for a specified period | SYD | | |
| Returns the bond-equivalent yield for a Treasury bill | TBILLEQ | | |
| Returns the price per $100 face value for a Treasury bill | TBILLPRICE | | |
| Returns the yield for a Treasury bill | TBILLYIELD | | |
| Returns the depreciation of an asset for a specified or partial period by using a declining balance method | VDB | | |
| Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic | XIRR | | |
| Returns the net present value for a schedule of cash flows that is not necessarily periodic | XNPV | | |
| Returns the yield on a security that pays periodic interest | YIELD | | |
| Returns the annual yield for a discounted security; for example, a Treasury bill | YIELDDISC | | |
| Returns the annual yield of a security that pays interest at maturity | YIELDMAT | | |
| Information |
| Returns information about the formatting, location, or contents of a cell Note:? This function is not available in Excel Online. | CELL | | |
| Returns a number corresponding to an error type | ERROR.TYPE | | |
| Returns information about the current operating environment Note:? This function is not available in Excel Online. | INFO | | |
| Returns TRUE if the value is blank | ISBLANK | | |
| Returns TRUE if the value is any error value except #N/A | ISERR | | |
| Returns TRUE if the value is any error value | ISERROR | | |
| Returns TRUE if the number is even | ISEVEN | | |
| Returns TRUE if there is a reference to a cell that contains a formula | ISFORMULA | | |
| Returns TRUE if the value is a logical value | ISLOGICAL | | |
| Returns TRUE if the value is the #N/A error value | ISNA | | |
| Returns TRUE if the value is not text | ISNONTEXT | | |
| Returns TRUE if the value is a number | ISNUMBER | | |
| Returns TRUE if the number is odd | ISODD | | |
| Returns TRUE if the value is a reference | ISREF | | |
| Returns TRUE if the value is text | ISTEXT | | |
| Returns a value converted to a number | N | | |
| Returns the error value #N/A | NA | | |
| Returns the sheet number of the referenced sheet | SHEET | | |
| Returns the number of sheets in a reference | SHEETS | | |
| Returns a number indicating the data type of a value | TYPE | | |
| Statistical |
| Returns the average of the absolute deviations of data points from their mean | AVEDEV | | |
| Returns the average of its arguments | AVERAGE | | |
| Returns the average of its arguments, including numbers, text, and logical values | AVERAGEA | | |
| Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | AVERAGEIF | | |
| Returns the average (arithmetic mean) of all cells that meet multiple criteria. | AVERAGEIFS | | |
| Returns the beta cumulative distribution function | BETA.DIST | | |
| Returns the inverse of the cumulative distribution function for a specified beta distribution | BETA.INV | | |
| Returns the individual term binomial distribution probability | BINOM.DIST | | |
| Returns the probability of a trial result using a binomial distribution | BINOM.DIST.RANGE | | |
| Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value | BINOM.INV | | |
| Returns the cumulative beta probability density function | CHISQ.DIST | | |
| Returns the one-tailed probability of the chi-squared distribution | CHISQ.DIST.RT | | |
| Returns the cumulative beta probability density function | CHISQ.INV | | |
| Returns the inverse of the one-tailed probability of the chi-squared distribution | CHISQ.INV.RT | | |
| Returns the test for independence | CHISQ.TEST | | |
| Returns the confidence interval for a population mean | CONFIDENCE.NORM | | |
| Returns the confidence interval for a population mean, using a Student's t distribution | CONFIDENCE.T | | |
| Returns the correlation coefficient between two data sets | CORREL | | |
| Counts how many numbers are in the list of arguments | COUNT | | |
| Counts how many values are in the list of arguments | COUNTA | | |
| Counts the number of blank cells within a range | COUNTBLANK | | |
| Counts the number of cells within a range that meet the given criteria | COUNTIF | | |
| Counts the number of cells within a range that meet multiple criteria | COUNTIFS | | |
| Returns covariance, the average of the products of paired deviations | COVARIANCE.P | | |
| Returns the sample covariance, the average of the products deviations for each data point pair in two data sets | COVARIANCE.S | | |
| Returns the sum of squares of deviations | DEVSQ | | |
| Returns the exponential distribution | EXPON.DIST | | |
| Returns the F probability distribution | F.DIST | | |
| Returns the F probability distribution | F.DIST.RT | | |
| Returns the inverse of the F probability distribution | F.INV | | |
| Returns the inverse of the F probability distribution | F.INV.RT | | |
| Returns the result of an F-test | F.TEST | | |
| Returns the inverse of the F probability distribution | FINV | | |
| Returns the Fisher transformation | FISHER | | |
| Returns the inverse of the Fisher transformation | FISHERINV | | |
| Returns a value along a linear trend Note:?In Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it's still available for compatibility with earlier versions. | FORECAST | | |
| Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm Note:?This function isn't available in Excel 2016 for Mac. | FORECAST.ETS | | |
| Returns a confidence interval for the forecast value at the specified target date Note:?This function isn't available in Excel 2016 for Mac. | FORECAST.ETS.CONFINT | | |
| Returns the length of the repetitive pattern Excel detects for the specified time series Note:?This function isn't available in Excel 2016 for Mac. | FORECAST.ETS.SEASONALITY | | |
| Returns a statistical value as a result of time series forecasting Note:?This function isn't available in Excel 2016 for Mac. | FORECAST.ETS.STAT | | |
| Returns a future value based on existing values Note:?This function isn't available in Excel 2016 for Mac. | FORECAST.LINEAR | | |
| Returns a frequency distribution as a vertical array | FREQUENCY | | |
| Returns the Gamma function value | GAMMA | | |
| Returns the gamma distribution | GAMMA.DIST | | |
| Returns the inverse of the gamma cumulative distribution | GAMMA.INV | | |
| Returns the natural logarithm of the gamma function, _(x) | GAMMALN | | |
| Returns the natural logarithm of the gamma function, _(x) | GAMMALN.PRECISE | | |
| Returns 0.5 less than the standard normal cumulative distribution | GAUSS | | |
| Returns the geometric mean | GEOMEAN | | |
| Returns values along an exponential trend | GROWTH | | |
| Returns the harmonic mean | HARMEAN | | |
| Returns the hypergeometric distribution | HYPGEOM.DIST | | |
| Returns the intercept of the linear regression line | INTERCEPT | | |
| Returns the kurtosis of a data set | KURT | | |
| Returns the k-th largest value in a data set | LARGE | | |
| Returns the parameters of a linear trend | LINEST | | |
| Returns the parameters of an exponential trend | LOGEST | | |
| Returns the cumulative lognormal distribution | LOGNORM.DIST | | |
| Returns the inverse of the lognormal cumulative distribution | LOGNORM.INV | | |
| Returns the maximum value in a list of arguments | MAX | | |
| Returns the maximum value in a list of arguments, including numbers, text, and logical values | MAXA | | |
| Returns the maximum value among cells specified by a given set of conditions or criteria Note:?This function isn't available in Excel 2016 for Mac. | MAXIFS | | |
| Returns the median of the given numbers | MEDIAN | | |
| Returns the minimum value in a list of arguments | MIN | | |
| Returns the smallest value in a list of arguments, including numbers, text, and logical values | MINA | | |
| Returns the minimum value among cells specified by a given set of conditions or criteria. Note:?This function isn't available in Excel 2016 for Mac. | MINIFS | | |
| Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data | MODE.MULT | | |
| Returns the most common value in a data set | MODE.SNGL | | |
| Returns the negative binomial distribution | NEGBINOM.DIST | | |
| Returns the normal cumulative distribution | NORM.DIST | | |
| Returns the standard normal cumulative distribution | NORM.S.DIST | | |
| Returns the inverse of the standard normal cumulative distribution | NORM.S.INV | | |
| Returns the inverse of the normal cumulative distribution | NORMINV | | |
| Returns the Pearson product moment correlation coefficient | PEARSON | | |
| Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive | PERCENTILE.EXC | | |
| Returns the k-th percentile of values in a range | PERCENTILE.INC | | |
| Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set | PERCENTRANK.EXC | | |
| Returns the percentage rank of a value in a data set | PERCENTRANK.INC | | |
| Returns the number of permutations for a given number of objects | PERMUT | | |
| Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects | PERMUTATIONA | | |
| Returns the value of the density function for a standard normal distribution | PHI | | |
| Returns the Poisson distribution | POISSON.DIST | | |
| Returns the probability that values in a range are between two limits | PROB | | |
| Returns the quartile of the data set, based on percentile values from 0..1, exclusive | QUARTILE.EXC | | |
| Returns the quartile of a data set | QUARTILE.INC | | |
| Returns the rank of a number in a list of numbers | RANK.AVG | | |
| Returns the rank of a number in a list of numbers | RANK.EQ | | |
| Returns the square of the Pearson product moment correlation coefficient | RSQ | | |
| Returns the skewness of a distribution | SKEW | | |
| Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean | SKEW.P | | |
| Returns the slope of the linear regression line | SLOPE | | |
| Returns the k-th smallest value in a data set | SMALL | | |
| Returns a normalized value | STANDARDIZE | | |
| Calculates standard deviation based on the entire population | STDEV.P | | |
| Estimates standard deviation based on a sample | STDEV.S | | |
| Estimates standard deviation based on a sample, including numbers, text, and logical values | STDEVA | | |
| Calculates standard deviation based on the entire population, including numbers, text, and logical values | STDEVPA | | |
| Returns the standard error of the predicted y-value for each x in the regression | STEYX | | |
| Returns the Percentage Points (probability) for the Student t-distribution | T.DIST | | |
| Returns the Percentage Points (probability) for the Student t-distribution | T.DIST.2T | | |
| Returns the Student's t-distribution | T.DIST.RT | | |
| Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom | T.INV | | |
| Returns the inverse of the Student's t-distribution | T.INV.2T | | |
| Returns the probability associated with a Student's t-test | T.TEST | | |
| Returns values along a linear trend | TREND | | |
| Returns the mean of the interior of a data set | TRIMMEAN | | |
| Calculates variance based on the entire population | VAR.P | | |
| Estimates variance based on a sample | VAR.S | | |
| Estimates variance based on a sample, including numbers, text, and logical values | VARA | | |
| Calculates variance based on the entire population, including numbers, text, and logical values | VARPA | | |
| Returns the Weibull distribution | WEIBULL.DIST | | |
| Returns the one-tailed probability-value of a z-test | Z.TEST | | |
| Add-in and Automation |
| Calls a procedure in a dynamic link library or code resource | CALL | | |
| 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). | EUROCONVERT | | |
| Returns data stored in a PivotTable report | GETPIVOTDATA | | |
| Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered | REGISTER.ID | | |
| Connects with an external data source and runs a query from a worksheet, then returns the result as an array without the need for macro programming | SQL.REQUEST | | |
| Compatibility |
| Returns the beta cumulative distribution function Note:?In Excel 2007, this is a Statistical function. | BETADIST | | |
| Returns the inverse of the cumulative distribution function for a specified beta distribution Note:?In Excel 2007, this is a Statistical function. | BETAINV | | |
| Returns the individual term binomial distribution probability Note:?In Excel 2007, this is a Statistical function. | BINOMDIST | | |
| Returns the one-tailed probability of the chi-squared distribution Note:?In Excel 2007, this is a Statistical function. | CHIDIST | | |
| Returns the inverse of the one-tailed probability of the chi-squared distribution Note:?In Excel 2007, this is a Statistical function. | CHIINV | | |
| Returns the test for independence Note:?In Excel 2007, this is a Statistical function. | CHITEST | | |
| Returns the confidence interval for a population mean Note:?In Excel 2007, this is a Statistical function. | CONFIDENCE | | |
| Returns covariance, the average of the products of paired deviations Note:?In Excel 2007, this is a Statistical function. | COVAR | | |
| Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value Note:?In Excel 2007, this is a Statistical function. | CRITBINOM | | |
| Returns the exponential distribution Note:?In Excel 2007, this is a Statistical function. | EXPONDIST | | |
| Returns the F probability distribution Note:?In Excel 2007, this is a Statistical function. | FDIST | | |
| Rounds a number down, toward zero Note:?In Excel 2007 and Excel 2010, this is a Math and trigonometry function. | FLOOR | | |
| Returns the result of an F-test Note:?In Excel 2007, this is a Statistical function. | FTEST | | |
| Returns the gamma distribution Note:?In Excel 2007, this is a Statistical function. | GAMMADIST | | |
| Returns the inverse of the gamma cumulative distribution Note:?In Excel 2007, this is a Statistical function. | GAMMAINV | | |
| Returns the hypergeometric distribution Note:?In Excel 2007, this is a Statistical function. | HYPGEOMDIST | | |
| Returns the inverse of the lognormal cumulative distribution | LOGINV | | |
| Returns the cumulative lognormal distribution | LOGNORMDIST | | |
| Returns the most common value in a data set Note:?In Excel 2007, this is a Statistical function. | MODE | | |
| Returns the negative binomial distribution Note:?In Excel 2007, this is a Statistical function. | NEGBINOMDIST | | |
| Returns the inverse of the normal cumulative distribution Note:?In Excel 2007, this is a Statistical function. | NORM.INV | | |
| Returns the normal cumulative distribution Note:?In Excel 2007, this is a Statistical function. | NORMDIST | | |
| Returns the standard normal cumulative distribution Note:?In Excel 2007, this is a Statistical function. | NORMSDIST | | |
| Returns the inverse of the standard normal cumulative distribution Note:?In Excel 2007, this is a Statistical function. | NORMSINV | | |
| Returns the k-th percentile of values in a range Note:?In Excel 2007, this is a Statistical function. | PERCENTILE | | |
| Returns the percentage rank of a value in a data set Note:?In Excel 2007, this is a Statistical function. | PERCENTRANK | | |
| Returns the Poisson distribution Note:?In Excel 2007, this is a Statistical function. | POISSON | | |
| Returns the quartile of a data set Note:?In Excel 2007, this is a Statistical function. | QUARTILE | | |
| Returns the rank of a number in a list of numbers Note:?In Excel 2007, this is a Statistical function. | RANK | | |
| Estimates standard deviation based on a sample | STDEV | | |
| Calculates standard deviation based on the entire population Note:?In Excel 2007, this is a Statistical function. | STDEVP | | |
| Returns the Student's t-distribution | TDIST | | |
| Returns the inverse of the Student's t-distribution | TINV | | |
| Returns the probability associated with a Student's t-test Note:?In Excel 2007, this is a Statistical function. | TTEST | | |
| Estimates variance based on a sample Note:?In Excel 2007, this is a Statistical function. | VAR | | |
| Calculates variance based on the entire population Note:?In Excel 2007, this is a Statistical function. | VARP | | |
| Calculates variance based on the entire population, including numbers, text, and logical values Note:?In Excel 2007, this is a Statistical function. | WEIBULL | | |
| Returns the one-tailed probability-value of a z-test Note:?In Excel 2007, this is a Statistical function. | ZTEST | | |
| Engineering |
| Returns the modified Bessel function In(x) | BESSELI | | |
| Returns the Bessel function Jn(x) | BESSELJ | | |
| Returns the modified Bessel function Kn(x) | BESSELK | | |
| Returns the Bessel function Yn(x) | BESSELY | | |
| Converts a binary number to decimal | BIN2DEC | | |
| Converts a binary number to hexadecimal | BIN2HEX | | |
| Converts a binary number to octal | BIN2OCT | | |
| Returns a 'Bitwise And' of two numbers | BITAND | | |
| Returns a value number shifted left by shift_amount bits | BITLSHIFT | | |
| Returns a bitwise OR of 2 numbers | BITOR | | |
| Returns a value number shifted right by shift_amount bits | BITRSHIFT | | |
| Returns a bitwise 'Exclusive Or' of two numbers | BITXOR | | |
| Converts real and imaginary coefficients into a complex number | COMPLEX | | |
| Converts a number from one measurement system to another | CONVERT | | |
| Converts a decimal number to binary | DEC2BIN | | |
| Converts a decimal number to hexadecimal | DEC2HEX | | |
| Converts a decimal number to octal | DEC2OCT | | |
| Tests whether two values are equal | DELTA | | |
| Returns the error function | ERF | | |
| Returns the error function | ERF.PRECISE | | |
| Returns the complementary error function | ERFC | | |
| Returns the complementary ERF function integrated between x and infinity | ERFC.PRECISE | | |
| Tests whether a number is greater than a threshold value | GESTEP | | |
| Converts a hexadecimal number to binary | HEX2BIN | | |
| Converts a hexadecimal number to decimal | HEX2DEC | | |
| Converts a hexadecimal number to octal | HEX2OCT | | |
| Returns the absolute value (modulus) of a complex number | IMABS | | |
| Returns the imaginary coefficient of a complex number | IMAGINARY | | |
| Returns the argument theta, an angle expressed in radians | IMARGUMENT | | |
| Returns the complex conjugate of a complex number | IMCONJUGATE | | |
| Returns the cosine of a complex number | IMCOS | | |
| Returns the hyperbolic cosine of a complex number | IMCOSH | | |
| Returns the cotangent of a complex number | IMCOT | | |
| Returns the cosecant of a complex number | IMCSC | | |
| Returns the hyperbolic cosecant of a complex number | IMCSCH | | |
| Returns the quotient of two complex numbers | IMDIV | | |
| Returns the exponential of a complex number | IMEXP | | |
| Returns the natural logarithm of a complex number | IMLN | | |
| Returns the base-10 logarithm of a complex number | IMLOG10 | | |
| Returns the base-2 logarithm of a complex number | IMLOG2 | | |
| Returns a complex number raised to an integer power | IMPOWER | | |
| Returns the product of complex numbers | IMPRODUCT | | |
| Returns the real coefficient of a complex number | IMREAL | | |
| Returns the secant of a complex number | IMSEC | | |
| Returns the hyperbolic secant of a complex number | IMSECH | | |
| Returns the sine of a complex number | IMSIN | | |
| Returns the hyperbolic sine of a complex number | IMSINH | | |
| Returns the square root of a complex number | IMSQRT | | |
| Returns the difference between two complex numbers | IMSUB | | |
| Returns the sum of complex numbers | IMSUM | | |
| Returns the tangent of a complex number | IMTAN | | |
| Converts an octal number to binary | OCT2BIN | | |
| Converts an octal number to decimal | OCT2DEC | | |
| Converts an octal number to hexadecimal | OCT2HEX | | |
| Database |
| Returns the average of selected database entries | DAVERAGE | | |
| Counts the cells that contain numbers in a database | DCOUNT | | |
| Counts nonblank cells in a database | DCOUNTA | | |
| Extracts from a database a single record that matches the specified criteria | DGET | | |
| Returns the maximum value from selected database entries | DMAX | | |
| Returns the minimum value from selected database entries | DMIN | | |
| Multiplies the values in a particular field of records that match the criteria in a database | DPRODUCT | | |
| Estimates the standard deviation based on a sample of selected database entries | DSTDEV | | |
| Calculates the standard deviation based on the entire population of selected database entries | DSTDEVP | | |
| Adds the numbers in the field column of records in the database that match the criteria | DSUM | | |
| Estimates variance based on a sample from selected database entries | DVAR | | |
| Calculates variance based on the entire population of selected database entries | DVARP | | |
| Cube |
| Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance. | CUBEKPIMEMBER | | |
| Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube. | CUBEMEMBER | | |
| Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member. | CUBEMEMBERPROPERTY | | |
| Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students. | CUBERANKEDMEMBER | | |
| Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel. | CUBESET | | |
| Returns the number of items in a set. | CUBESETCOUNT | | |
| Returns an aggregated value from a cube. | CUBEVALUE | | |
| Web |
| Returns a URL-encoded string Note:? This function is not available in Excel Online. | ENCODEURL | | |
| Returns specific data from the XML content by using the specified XPath Note:? This function is not available in Excel Online. | FILTERXML | | |
| Returns data from a web service. Note:? This function is not available in Excel Online. | WEBSERVICE | | |