| A | | |
| Absolute value | Math Functions |
| Calculating accrued interest | Math Functions |
| ACCRINTM | accrued interest that's paid periodically | Financial Functions |
| ACOS | Arccosine of a number | Math Functions |
| ACOSH | Inverse hyperbolic cosine of a number | Math Functions |
| ACOT | The angle returned is in radians between 0 and PI. * If "number" is not numeric, then #VALUE | Math Functions |
| ACOTH | Operates element-wise on arrays | Math Functions |
| ADDRESS | a reference, in text format, for a supplied row and column number | Math Functions |
| AGGREGATE | Computes a single result from multiple input rows | Reference Functions |
| AMORDEGRC | Calculate the depreciation of an asset for each accounting period | Math Functions |
| AMORLINC | Calculates the prorated linear depreciation of an asset for each accounting period | Financial Functions |
| AND | Tests a number of user-defined conditions and TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise | Logical Functions |
| ARABIC | Converts a Roman numeral to an Arabic numeral (New in Excel 2013) | Miscellaneous |
| AREAS | the number of areas in a supplied range | Miscellaneous |
| ASIN | the Arcsine of a number | Reference Functions |
| ASINH | the Inverse Hyperbolic Sine of a number | Math Functions |
| ATAN | the Arctangent of a given number | Math Functions |
| ATAN2 | the Arctangent of a given pair of x and y coordinates | Math Functions |
| ATANH | the Inverse Hyperbolic Tangent of a given number | Math Functions |
| AVEDEV | the average of the absolute deviations of data points from their mean | Math Functions |
| AVERAGE | the Average of a list of supplied numbers | Statistical Functions |
| AVERAGEA | the Average of a list of supplied numbers, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 | Math Functions |
| AVERAGEIF | Calculates the Average of the cells in a supplied range, that satisfy a given criteria (New in Excel 2007) | Math Functions |
| AVERAGEIFS | Calculates the Average of the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007) | Math Functions |
| B | | |
| BAHTTEXT | Converts a number, plus the suffix "Baht" into Thai text | text Functions |
| BASE | Converts a number into a text representation, with the supplied base (New in Excel 2013) | Math Functions |
| BESSELI | Calculates the modified Bessel function In(x) | Miscellaneous |
| BESSELK | Calculates the modified Bessel function Kn(x) | Engineering Functions |
| BESSELY | Calculates the modified Bessel function Yn(x) | Engineering Functions |
| BETA.DIST | the cumulative beta distribution function or the beta probability density function (New in Excel 2010 - replaces the Betadist function) | Engineering Functions |
| BETA.INV | the inverse of the cumulative beta probability density function (New in Excel 2010 - replaces the Betainv function) | Statistical Functions |
| BETADIST | the cumulative beta probability density function (Replaced by Beta.Dist function in Excel 2010) | Statistical Functions |
| BETAINV | the inverse of the cumulative beta probability density function (Replaced by Beta.Inv function in Excel 2010) | Statistical Functions |
| BIN2DEC | Converts a binary number to a decimal | Statistical Functions |
| BIN2HEX | Converts a binary number to hexadecimal | Engineering Functions |
| BIN2OCT | Converts a binary number to octal | Engineering Functions |
| BINOM.DIST | the individual term binomial distribution probability (New in Excel 2010 - replaces the Binomdist function) | Engineering Functions |
| BINOM.DIST.RANGE | the probability of a trial result using a binomial distribution (New in Excel 2013) | Statistical Functions |
| BINOM.INV | the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (New in Excel 2010 - replaces the Critbinom function) | Statistical Functions |
| BINOMDIST | the individual term binomial distribution probability (Replaced by Binom.Dist function in Excel 2010) | Statistical Functions |
| BITAND | a Bitwise 'And' of two numbers (New in Excel 2013) | Statistical Functions |
| BITLSHIFT | a number shifted left by a specified number of bits (New in Excel 2013) | Engineering Functions |
| BITOR | a Bitwise 'Or' of two numbers (New in Excel 2013) | Engineering Functions |
| BITRSHIFT | a number shifted right by a specified number of bits (New in Excel 2013) | Engineering Functions |
| BITXOR | a Bitwise 'Exclusive Or' of two numbers (New in Excel 2013) | Engineering Functions |
| C | | |
| CEILING | Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a multiple of significance | Math Functions |
| CEILING.MATH | Rounds a number up to the nearest integer or to the nearest multiple of significance (New in Excel 2013) | Math Functions |
| CEILING.PRECISE | Rounds a number up, regardless of the sign of the number, to a multiple of significance (New in Excel 2010) | Math Functions |
| CELL | information about the contents, formatting or location of a given cell | Information Functions |
| CHAR | the character that corresponds to a supplied numeric value | text Functions |
| CHI.INV.RT | the inverse of the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chiinv function) | Statistical Functions |
| CHIDIST | the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Dist.Rt function in Excel 2010) | Statistical Functions |
| CHIINV | the inverse of the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Inv.Rt function in Excel 2010) | Statistical Functions |
| CHISQ.DIST | the chi-squared distribution (probability density or cumulative distribution function) (New in Excel 2010) | Statistical Functions |
| CHISQ.DIST.RT | the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chidist function) | Statistical Functions |
| CHISQ.INV | the inverse of the left-tailed probability of the chi-squared distribution (New in Excel 2010) | Statistical Functions |
| CHISQ.TEST | the chi-squared statistical test for independence (New in Excel 2010 - replaces the Chitest function) | Statistical Functions |
| CHITEST | the chi-squared statistical test for independence (Replaced by Chisq.Test function in Excel 2010) | Statistical Functions |
| CHOOSE | one of a list of values, depending on the value of a supplied index number | Statistical Functions |
| CLEAN | Removes all non-printable characters from a supplied text string | text Functions |
| CODE | the numeric code for the first character of a supplied string | text Functions |
| COLUMN | the column number of a supplied range, or of the current cell | Reference Functions |
| COLUMNS | the number of columns in a supplied range | Reference Functions |
| COMBIN | the number of combinations (without repetitions) for a given number of objects | Reference Functions |
| COMBINA | the number of combinations (with repetitions) for a given number of items (New in Excel 2013) | Miscellaneous |
| COMPLEX | Converts user-supplied real and imaginary coefficients into a complex number | Miscellaneous |
| CONCAT | Joins together two or more text strings (New in Excel 2016 (not Excel 2016 for Mac) - replaces the Concatenate function) | text Functions |
| CONCATENATE | Joins together two or more text strings (Replaced by the Concat function in Excel 2016) | text Functions |
| CONFIDENCE | the confidence interval for a population mean, using a normal distribution (Replaced by Confidence.Norm function in Excel 2010) | Statistical Functions |
| CONFIDENCE.NORM | the confidence interval for a population mean, using a normal distribution (New in Excel 2010 - replaces the Confidence function) | Statistical Functions |
| CONFIDENCE.T | the confidence interval for a population mean, using a Student's t distribution (New in Excel 2010) | Statistical Functions |
| CONVERT | Converts a number from one measurement system to another | Statistical Functions |
| CORREL | the correlation coefficient between two sets of values | Statistical Functions |
| COS | the Cosine of a given angle | Statistical Functions |
| COSH | the hyperbolic cosine of a number | Statistical Functions |
| COT | the cotangent of an angle (New in Excel 2013) | Math Functions |
| COTH | the hyperbolic cotangent of an angle (New in Excel 2013) | Math Functions |
| COUNT | the number of numerical values in a supplied set of cells or values | Math Functions |
| COUNTA | the number of non-blanks in a supplied set of cells or values | Math Functions |
| COUNTBLANK | the number of blank cells in a supplied range | Reference Functions |
| Count the number of cells (of a supplied range), that satisfy a given criteria | Math Functions |
| Multiple cells evaluation of range), that satisfy a set of given criteria (New in Excel 2007) | Math Functions |
| COUPDAYBS | Calculates the number of days from the beginning of the coupon period to the settlement date | Math Functions |
| COUPDAYS | Calculates the number of days in the coupon period that contains the settlement date | Financial Functions |
| COUPDAYSNC | Calculates the number of days from the settlement date to the next coupon date | Financial Functions |
| COUPNCD | the next coupon date after the settlement date | Financial Functions |
| COUPNUM | the number of coupons payable between the settlement date and maturity date | Financial Functions |
| COUPPCD | the previous coupon date, before the settlement date | Financial Functions |
| COVAR | population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (Replaced by Covariance.P function in Excel 2010) | Financial Functions |
| COVARIANCE.P | population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010 - replaces the Covar function) | Statistical Functions |
| COVARIANCE.S | sample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010) | Statistical Functions |
| CRITBINOM | the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (Replaced by Binom.Inv function in Excel 2010) | Statistical Functions |
| CSC | the cosecant of an angle (New in Excel 2013) | Statistical Functions |
| CSCH | the hyperbolic cosecant of an angle (New in Excel 2013) | Statistical Functions |
| CUBEKPIMEMBER | a Key Performance Indicator (KPI) property and displays the KPI name in the cell (New in Excel 2007) | Math Functions |
| CUBEMEMBER | a member or tuple from the cube (New in Excel 2007) | Cube Functions |
| CUBEMEMBERPROPERTY | the value of a member property from the cube (New in Excel 2007) | Cube Functions |
| CUBERANKEDMEMBER | the nth, or ranked, member in a set (New in Excel 2007) | Statistical Functions |
| CUBESET | 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 that set to Microsoft Office Excel (New in Excel 2007) | Cube Functions |
| CUBESETCOUNT | the number of items in a set (New in Excel 2007) | Cube Functions |
| CUBEVALUE | an aggregated value from the cube (New in Excel 2007) | Cube Functions |
| CUMIPMT | Calculates the cumulative interest paid between two specified periods | Cube Functions |
| CUMPRINC | Calculates the cumulative principal paid on a loan, between two specified periods | Financial Functions |
| D | | |
| DATE | Returns the current system date | Date and Time Functions |
| Hidden function DATEDIF is not available in either the Excel 2016 Ribbon or the function helper. This calculates the number of days, months, or years between two dates. | Date and Time Functions |
| DATEVALUE | Converts a text string showing a date, to an integer that represents the date in Excel's date-time code | Date and Time Functions |
| DAVERAGE | Calculates the average of values in a field of a list or database, that satisfy specified conditions | Date and Time Functions |
| DAY | the day (of the month) from a user-supplied date | Date and Time Functions |
| DAYS | the number of days between 2 dates (New in Excel 2013) | Date and Time Functions |
| DAYS360 | Calculates the number of days between 2 dates, based on a 360-day year (12 x 30 months) | Date and Time Functions |
| DB | Calculates the depreciation of an asset for a specified period, using the fixed-declining balance method | Date and Time Functions |
| DCOUNT | the number of cells containing numbers in a field of a list or database that satisfy specified conditions | Financial Functions |
| DCOUNTA | the number of non-blank cells in a field of a list or database, that satisfy specified conditions | Database Functions |
| DDB | Calculates the depreciation of an asset for a specified period, using the double-declining balance method, or some other user-specified method | Database Functions |
| DEC2BIN | Converts a decimal number to binary | Financial Functions |
| DEC2HEX | Converts a decimal number to hexadecimal | Math Functions |
| DEC2OCT | Converts a decimal number to octal | Math Functions |
| DECIMAL | Converts a text representation of a number in a specified base into a decimal number (New in Excel 2013) | Math Functions |
| DEGREES | Converts Radians to Degrees | Miscellaneous |
| DELTA | Tests whether two supplied numbers are equal | Statistical Functions |
| DEVSQ | the sum of the squares of the deviations of a set of data points from their sample mean | Statistical Functions |
| DGET | a single value from a field of a list or database, that satisfy specified conditions | Statistical Functions |
| DISC | Calculates the discount rate for a security | Database Functions |
| DMAX | the maximum value from a field of a list or database, that satisfy specified conditions | Financial Functions |
| DMIN | the minimum value from a field of a list or database, that satisfy specified conditions | Database Functions |
| DOLLAR | Converts a supplied number into text, using a currency format | text Functions |
| DOLLARDE | Converts a dollar price expressed as a fraction, into a dollar price expressed as a decimal | Financial Functions |
| DOLLARFR | Converts a dollar price expressed as a decimal, into a dollar price expressed as a fraction | Financial Functions |
| DPRODUCT | Calculates the product of values in a field of a list or database, that satisfy specified conditions | Financial Functions |
| DSTDEV | Calculates the standard deviation (based on a sample of a population), of values in a field of a list or database, that satisfy specified conditions | Database Functions |
| DSTDEVP | Calculates the standard deviation (based on an entire population), of values in a field of a list or database, that satisfy specified conditions | Database Functions |
| DSUM | Calculates the sum of values in a field of a list or database, that satisfy specified conditions | Database Functions |
| DURATION | Calculates the Macauley duration of a security with an assumed par value of $100 | Database Functions |
| DVAR | Calculates the variance (based on a sample of a population), of values in a field of a list or database, that satisfy specified conditions | Financial Functions |
| DVARP | Calculates the variance (based on an entire population), of values in a field of a list or database, that satisfy specified conditions | Database Functions |
| E | | |
| EDATE | a date that is the specified number of months before or after an initial supplied start date | Date and Time Functions |
| EFFECT | Calculates the effective annual interest rate | Date and Time Functions |
| ENCODEURL | a URL-encoded string (New in Excel 2013) | Financial Functions |
| EOMONTH | a date that is the last day of the month which is a specified number of months before or after an initial supplied start date | Date and Time Functions |
| ERF | the error function integrated between two supplied limits | Date and Time Functions |
| ERF.PRECISE | the error function integrated between 0 and a supplied limit (New in Excel 2010) | Statistical Functions |
| ERFC | the complementary error function integrated between a supplied lower limit and infinity | Statistical Functions |
| ERFC.PRECISE | the complementary error function integrated between a supplied lower limit and infinity (New in Excel 2010) | Statistical Functions |
| ERROR.TYPE | Tests a supplied value and an integer relating to the supplied value's error type | Information Functions |
| EVEN | Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next even number | Information Functions |
| EXACT | Tests if two supplied text strings are exactly the same and if so, TRUE; Otherwise, FALSE. (case-sensitive) | text Functions |
| EXP | e raised to a given power | Math Functions |
| EXPON.DIST | the exponential distribution (New in Excel 2010 - replaces the Expondist function) | Math Functions |
| EXPONDIST | the exponential distribution (Replaced by Expon.Dist function in Excel 2010) | Statistical Functions |
| F | | |
| F.DIST | the F probability distribution (probability density or cumulative distribution function) (New in Excel 2010) | Statistical Functions |
| F.DIST.RT | the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Fdist function) | Statistical Functions |
| F.INV | the inverse of the Cumulative F distribution (New in Excel 2010) | Statistical Functions |
| F.INV.RT | the inverse of the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Finv function) | Statistical Functions |
| F.TEST | the result of an F-Test for 2 supplied data sets (New in Excel 2010 - replaces the Ftest function) | Statistical Functions |
| FACT | the Factorial of a given number | Statistical Functions |
| FACTDOUBLE | the Double Factorial of a given number | Math Functions |
| FALSE | Simply the logical value FALSE | Logical Functions |
| FDIST | the right-tailed F probability distribution for two data sets (Replaced by F.Dist.Rt function in Excel 2010) | Statistical Functions |
| FILTERXML | data from XML content, using a specified XPath (New in Excel 2013) | Web Functions |
| FIND | the position of a supplied character or text string from within a supplied text string (case-sensitive) | text Functions |
| FINV | the inverse of the right-tailed F probability distribution for two data sets (Replaced by F.Inv.Rt function in Excel 2010) | Statistical Functions |
| FISHER | the Fisher transformation | Statistical Functions |
| FISHERINV | the inverse of the Fisher transformation | Statistical Functions |
| FIXED | Rounds a supplied number to a specified number of decimal places, and then converts this into text | text Functions |
| FLOOR | Rounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a multiple of significance | Math Functions |
| FLOOR.MATH | Rounds a number down, to the nearest integer or to the nearest multiple of significance (New in Excel 2013) | Math Functions |
| FLOOR.PRECISE | Rounds a number down, regardless of the sign of the number, to a multiple of significance (New in Excel 2010) | Math Functions |
| FORECAST | Predicts a future point on a linear trend line fitted to a supplied set of x- and y- values | Math Functions |
| FORECAST.ETS | Predicts a future value based based on historical values by using the AAA version of the Exponential Smoothing (ETS) algorithm (New in Excel 2016) | Statistical Functions |
| FORECAST.ETS.CONFINT | a confidence interval for a forecast value at a specified target date (New in Excel 2016) | Statistical Functions |
| FORECAST.ETS.SEASONALITY | the length of the repetitive pattern Excel detects for a specified time series (New in Excel 2016) | Statistical Functions |
| FORECAST.ETS.STAT | one or more statistical values as a result of time series forecasting (New in Excel 2016) | Statistical Functions |
| FORECAST.LINEAR | Predicts a future point on a linear trend line fitted to a supplied set of x- and y- values (New in Excel 2016) | Statistical Functions |
| FORMULATEXT | a formula as a string (New in Excel 2013) | Statistical Functions |
| FREQUENCY | an array showing the number of values from a supplied array, which fall into specified ranges | Reference Functions |
| FTEST | the result of an F-Test for 2 supplied data sets (Replaced by F.Test function in Excel 2010) | Statistical Functions |
| FV | Calculates the future value of an investment with periodic constant payments and a constant interest rate | Statistical Functions |
| FVSCHEDULE | Calculates the future value of an initial principal, after applying a series of compound interest rates | |
| G | | |
| GAMMA | Return the gamma function value for a supplied number (New in Excel 2013) | Statistical Functions |
| GAMMA.DIST | the gamma distribution (New in Excel 2010 - replaces the Gammadist function) | Statistical Functions |
| GAMMA.INV | the inverse gamma cumulative distribution (New in Excel 2010 - replaces the Gammainv function) | Statistical Functions |
| GAMMADIST | the gamma distribution (Replaced by Gamma.Dist function in Excel 2010) | Statistical Functions |
| GAMMAINV | the inverse gamma cumulative distribution (Replaced by Gamma.Inv function in Excel 2010) | Statistical Functions |
| GAMMALN | Calculates the natural logarithm of the gamma function for a supplied value | Statistical Functions |
| GAMMALN.PRECISE | the natural logarithm of the gamma function for a supplied value (New in Excel 2010) | Statistical Functions |
| GAUSS | 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 2013) | Statistical Functions |
| GCD | the Greatest Common Divisor of two or more supplied numbers | Statistical Functions |
| GEOMEAN | the geometric mean of a set of supplied numbers | Math Functions |
| GESTEP | Tests whether a number is greater than a supplied threshold value | Math Functions |
| GETPIVOTDATA | Extracts data stored in a Pivot Table | Logical Functions |
| GROWTH | numbers in a exponential growth trend, based on a set of supplied x- and y- values | Data Lookup Functions |
| H | | |
| HARMEAN | the harmonic mean of a set of supplied numbers | Statistical Functions |
| HEX2BIN | Converts a hexadecimal number to binary | Statistical Functions |
| HEX2DEC | Converts a hexadecimal number to a decimal | Statistical Functions |
| HEX2OCT | Converts a hexadecimal number to octal | Math Functions |
| HLOOKUP | Looks up a supplied value in the first row of a table, and the corresponding value from another row | Math Functions |
| HOUR | the hour part of a user-supplied time | Date and Time Functions |
| HYPERLINK | Creates a hyperlink to a document in a supplied location | Date and Time Functions |
| HYPGEOM.DIST | the hypergeometric distribution (New in Excel 2010 - replaces the Hypgeomdist function) | Reference Functions |
| HYPGEOMDIST | the hypergeometric distribution (Replaced by Hypgeom.Dist function in Excel 2010) | Statistical Functions |
| I | | |
| IF | Tests a user-defined condition and one result if the condition is TRUE, and another result if the condition is FALSE | Logical Functions |
| IFERROR | Tests if an initial supplied value (or expression) an error, and if so the function a supplied value; Otherwise the function the initial value. (New in Excel 2007) | Logical Functions |
| IFNA | Tests if an expression the #N/A error and if so, an alternative specified value; Otherwise the function the value of the supplied expression (New in Excel 2013) | Logical Functions |
| IFS | Tests a number of supplied conditions and a result corresponding to the first condition that evaluates to TRUE (New in Excel 2016 - not available in Excel 2016 for Mac) | Logical Functions |
| IMABS | the absolute value (the modulus) of a complex number | Math Functions |
| IMAGINARY | the imaginary coefficient of a complex number | Engineering Functions |
| IMARGUMENT | the argument ╬ÿ (an angle expressed in radians) of a complex number | Engineering Functions |
| IMCONJUGATE | the complex conjugate of a complex number | Engineering Functions |
| IMCOS | the cosine of a complex number | Engineering Functions |
| IMCOSH | the hyperbolic cosine of a complex number (New in Excel 2013) | Engineering Functions |
| IMCOT | the cotangent of a complex number (New in Excel 2013) | Engineering Functions |
| IMCSC | the cosecant of a complex number (New in Excel 2013) | Engineering Functions |
| IMCSCH | the hyperbolic cosecant of a complex number (New in Excel 2013) | Engineering Functions |
| IMDIV | the quotient of two supplied complex numbers | Engineering Functions |
| IMEXP | the exponential of a complex number | Engineering Functions |
| IMLN | the natural logarithm of a complex number | Engineering Functions |
| IMLOG10 | the base-10 logarithm of a complex number | Engineering Functions |
| IMLOG2 | the base-2 logarithm of a complex number | Engineering Functions |
| IMPOWER | Calculates a complex number raised to a supplied power | Engineering Functions |
| IMPRODUCT | the product of up to 255 supplied complex numbers | Engineering Functions |
| IMREAL | the real coefficient of a complex number | Engineering Functions |
| IMSEC | the secant of a complex number (New in Excel 2013) | Engineering Functions |
| IMSECH | the hyperbolic secant of a complex number (New in Excel 2013) | Engineering Functions |
| IMSIN | the sine of a complex number | Engineering Functions |
| IMSINH | the hyperbolic sine of a complex number (New in Excel 2013) | Engineering Functions |
| IMSQRT | the square root of a complex number | Engineering Functions |
| IMSUB | Subtracts two complex numbers | Engineering Functions |
| IMSUM | Calculates the sum of two complex numbers | Engineering Functions |
| IMTAN | the tangent of a complex number (New in Excel 2013) | Engineering Functions |
| INDEX | a reference to a cell (or range of cells) for requested rows and columns within a supplied range | Engineering Functions |
| INDIRECT | a cell or range reference that is represented by a supplied text string | Reference Functions |
| INFO | information about the current operating environment | Information Functions |
| INT | Rounds a number down to the next integer | Information Functions |
| INTERCEPT | Calculates the best fit regression line, through a supplied series of x- and y- values and the value at which this line intercepts the y-axis | Math Functions |
| INTRATE | Calculates the interest rate for a fully invested security | Financial Functions |
| IPMT | Calculates the interest payment for a given period of an investment, with periodic constant payments and a constant interest rate | Financial Functions |
| IRR | Calculates the internal rate of return for a series of cash flows | Statistical Functions |
| ISBLANK | Tests if a supplied cell is blank (empty), and if so, TRUE; Otherwise, FALSE | Information Functions |
| ISERR | Tests if an initial supplied value (or expression) an error (EXCEPT for the #N/A error) and if so, TRUE; Otherwise FALSE | Information Functions |
| ISERROR | Tests if an initial supplied value (or expression) an error and if so, TRUE; Otherwise FALSE | Information Functions |
| ISEVEN | Tests if a supplied number (or expression) is an even number, and if so, TRUE; Otherwise, FALSE. | Information Functions |
| ISFORMULA | Tests if a supplied cell contains a formula and if so, TRUE; Otherwise, FALSE (New in Excel 2013) | Information Functions |
| ISLOGICAL | Tests if a supplied value is a logical value, and if so, TRUE; Otherwise, FALSE | Information Functions |
| ISNA | Tests if an initial supplied value (or expression) the Excel #N/A error and if so, TRUE; Otherwise FALSE | Information Functions |
| ISNONTEXT | Tests if a supplied value is text, and if it is NOT, TRUE; Otherwise, FALSE | Information Functions |
| ISNUMBER | Tests if a supplied value is a number, and if so, TRUE; Otherwise, FALSE | Information Functions |
| ISO.CEILING | Rounds a number up, regardless of the sign of the number, to a multiple of significance. (New in Excel 2010) | Math Functions |
| ISODD | Tests if a supplied number (or expression) is an odd number, and if so, TRUE; Otherwise, FALSE | Information Functions |
| ISOWEEKNUM | the ISO week number of the year for a given date (New in Excel 2013) | Date and Time Functions |
| ISPMT | the interest paid during a specified period of an investment | Date and Time Functions |
| ISREF | Tests if a supplied value is a reference, and if so, TRUE; Otherwise, FALSE | Information Functions |
| ISTEXT | Tests if a supplied value is text, and if so, TRUE; Otherwise, FALSE | Information Functions |
| K | | |
| KURT | the kurtosis of a data set | Miscellaneous |
| L | | |
| LARGE | the kth largest value from a list of supplied numbers, for a given value k | Math Functions |
| LCM | the Least Common Multiple of two or more supplied numbers | Math Functions |
| LEFT | a specified number of characters from the start of a supplied text string | text Functions |
| LEN | the length of a supplied text string | text Functions |
| LINEST | statistical information describing the trend of the line of best fit, through a supplied series of x- and y- values | text Functions |
| LN | the natural logarithm of a given number | Statistical Functions |
| LOG | the logarithm of a given number, to a specified base | Math Functions |
| LOG10 | the base 10 logarithm of a given number | Math Functions |
| LOGEST | the parameters of an exponential trend for a supplied set of x- and y- values | Math Functions |
| LOGINV | the inverse of the lognormal distribution (Replaced by Lognorm.Inv function in Excel 2010) | Statistical Functions |
| LOGNORM.DIST | the log-normal probability density function or the cumulative log- normal distribution (New in Excel 2010 - replaces the Lognormdist function) | Statistical Functions |
| LOGNORM.INV | the inverse of the lognormal distribution (New in Excel 2010 - replaces the Loginv function) | Statistical Functions |
| LOGNORMDIST | the cumulative log-normal distribution (Replaced by Lognorm.Dist function in Excel 2010) | Statistical Functions |
| LOOKUP | Searches for a specific value in one data vector, and a value from the corresponding position of a second data vector | Statistical Functions |
| LOWER | Converts all characters in a supplied text string to lower case | text Functions |
| M | | |
| MATCH | Finds the relative position of a value in a supplied array | Reference Functions |
| MAX | the largest value from a list of supplied numbers | Math Functions |
| MAXA | the largest value from a list of supplied values, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 | Math Functions |
| MAXIFS | the largest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2016 - not available in Excel 2016 for Mac) | Math Functions |
| MDETERM | the matrix determinant of a supplied array | Math Functions |
| MDURATION | Calculates the Macauley modified duration for a security with an assumed par value of $100 | Statistical Functions |
| MEDIAN | the Median (the middle value) of a list of supplied numbers | Financial Functions |
| MID | a specified number of characters from the middle of a supplied text string | text Functions |
| MIN | the smallest value from a list of supplied numbers | text Functions |
| MINA | the smallest value from a list of supplied values, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 | Math Functions |
| MINIFS | the smallest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2016 - not available in Excel 2016 for Mac) | Math Functions |
| MINUTE | the minute part of a user-supplied time | Date and Time Functions |
| MINVERSE | the matrix inverse of a supplied array | Date and Time Functions |
| MIRR | Calculates the internal rate of return for a series of periodic cash flows, considering the cost of the investment and the interest on the reinvestment of cash | Statistical Functions |
| MMULT | the matrix product of two supplied arrays | Financial Functions |
| MOD | the remainder from a division between two supplied numbers | Math Functions |
| MODE | the Mode (the most frequently occurring value) of a list of supplied numbers (Replaced by Mode.Sngl function in Excel 2010) | Math Functions |
| MODE.MULT | a vertical array of the most frequently occurring values in an array or range of data (New in Excel 2010) | Math Functions |
| MODE.SNGL | the Mode (the most frequently occurring value) of a list of supplied numbers (New in Excel 2010 - replaces the Mode function) | Statistical Functions |
| MONTH | Returns the month (a number from 1 to 12) given a date value | Date and Time Functions |
| MROUND | Rounds a number up or down, to the nearest multiple of significance | Date and Time Functions |
| MULTINOMIAL | the Multinomial of a given set of numbers | Math Functions |
| MUNIT | the unit matrix for a specified dimension (New in Excel 2013) | Math Functions |
| N | | |
| N | Converts a non-number value to a number, a date to a serial number, the logical value TRUE to 1 and all other values to 0 | Information Functions |
| NA | the Excel #N/A error | Information Functions |
| NEGBINOM.DIST | the negative binomial distribution (New in Excel 2010 - replaces the Negbinomdist function) | Statistical Functions |
| NEGBINOMDIST | the negative binomial distribution (Replaced by Negbinom.Dist function in Excel 2010) | Statistical Functions |
| NETWORKDAYS | the number of whole networkdays (excluding weekends & holidays), between two supplied dates | Statistical Functions |
| NETWORKDAYS.INTL | the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days (New in Excel 2010) | Date and Time Functions |
| NOMINAL | Calculates the annual nominal interest rate | Date and Time Functions |
| NORM.DIST | the normal cumulative distribution (New in Excel 2010 - replaces the Normdist function) | Financial Functions |
| NORM.INV | the inverse of the normal cumulative distribution (New in Excel 2010 - replaces the Norminv function) | Statistical Functions |
| NORM.S.DIST | the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsdist function) | Statistical Functions |
| NORM.S.INV | the inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsinv function) | Statistical Functions |
| NORMDIST | the normal cumulative distribution (Replaced by Norm.Dist function in Excel 2010) | Statistical Functions |
| NORMINV | the inverse of the normal cumulative distribution (Replaced by Norm.Inv function in Excel 2010) | Statistical Functions |
| NORMSDIST | the standard normal cumulative distribution (Replaced by Norm.S.Dist function in Excel 2010) | Statistical Functions |
| NORMSINV | the inverse of the standard normal cumulative distribution (Replaced by Norm.S.Inv function in Excel 2010) | Statistical Functions |
| NOT | a logical value that is the opposite of a user supplied logical value or expression. (i.e. FALSE is the supplied argument is TRUE and TRUE if the supplied argument is FALSE) | Logical Functions |
| NOW | Returns the current system date and time | Date and Time Functions |
| NPER | the number of periods for an investment with periodic constant payments and a constant interest rate | Date and Time Functions |
| NPV | Calculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and income | Financial Functions |
| NUMBERVALUE | Converts text to a number, in a locale-independent way (New in Excel 2013) | text Functions |
| O | | |
| OCT2BIN | Converts octal number to binary | Statistical Functions |
| OCT2DEC | Converts octal number to a decimal | Math Functions |
| OCT2HEX | Converts octal number to hexadecimal | Math Functions |
| ODD | Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next odd number | Math Functions |
| ODDFPRICE | Calculates the price per $100 face value of a security with an odd first period | Math Functions |
| ODDFYIELD | Calculates the yield of a security with an odd first period | Financial Functions |
| ODDLPRICE | Calculates the price per $100 face value of a security with an odd last period | Financial Functions |
| ODDLYIELD | Calculates the yield of a security with an odd last period | Financial Functions |
| OFFSET | a reference to a range of cells that is a specified number of rows and columns from an initial supplied range | Financial Functions |
| OR | Tests a number of user-defined conditions and TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwise | Logical Functions |
| P | | |
| PDURATION | Calculates the number of periods required for an investment to reach a specified value (New in Excel 2013) | Financial Functions |
| PEARSON | the Pearson product moment correlation coefficient | Financial Functions |
| PERCENTILE | the k'th percentile of values in a supplied range, where k is in the range 0 - 1 (inclusive) (Replaced by Percentile.Inc function in Excel 2010) | Statistical Functions |
| PERCENTILE.EXC | the k'th percentile of values in a supplied range, where k is in the range 0 - 1 (exclusive) (New in Excel 2010) | Statistical Functions |
| PERCENTILE.INC | the k'th percentile of values in a supplied range, where k is in the range 0 - 1 (inclusive) (New in Excel 2010 - replaces the Percentile function) | Statistical Functions |
| PERCENTRANK | the rank of a value in a data set, as a percentage (0 - 1 inclusive) (Replaced by Percentrank.Inc function in Excel 2010) | Statistical Functions |
| PERCENTRANK.EXC | the rank of a value in a data set, as a percentage (0 - 1 exclusive) (New in Excel 2010) | Statistical Functions |
| PERCENTRANK.INC | the rank of a value in a data set, as a percentage (0 - 1 inclusive) (New in Excel 2010 - replaces the Percentrank function) | Statistical Functions |
| PERMUT | the number of permutations for a given number of objects | Statistical Functions |
| PERMUTATIONA | the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (New in Excel 2013) | Miscellaneous |
| PHI | the value of the density function for a standard normal distribution, for a supplied number (New in Excel 2013) | Statistical Functions |
| PI | the constant value of pi | Statistical Functions |
| PMT | Calculates the payments required to reduce a loan, from a supplied present value to a specified future value | Math Functions |
| POISSON | the Poisson distribution (Replaced by Poisson.Dist function in Excel 2010) | Statistical Functions |
| POISSON.DIST | the Poisson distribution (New in Excel 2010 - replaces the Poisson function) | Statistical Functions |
| POWER | the result of a given number raised to a supplied power | Statistical Functions |
| PPMT | Calculates the payment on the principal for a given investment, with periodic constant payments and a constant interest rate | Math Functions |
| PRICE | Calculates the price per $100 face value of a security that pays periodic interest | Financial Functions |
| PRICEDISC | Calculates the price per $100 face value of a discounted security | Financial Functions |
| PRICEMAT | Calculates the price per $100 face value of a security that pays interest at maturity | Financial Functions |
| PROB | the probablity that values in a supplied range are within given limits | Financial Functions |
| PRODUCT | the product of a supplied list of numbers | Math Functions |
| PROPER | Converts all characters in a supplied text string to proper case (i.e. letters that do not follow another letter are upper case and all other characters are lower case) | text Functions |
| PV | Calculates the present value of an investment (i.e. the total amount that a series of future payments is worth now) | Statistical Functions |
| Q | | |
| QUARTILE | the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (Replaced by Quartile.Inc function in Excel 2010) | Statistical Functions |
| QUARTILE.EXC | the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (exclusive) (New in Excel 2010) | Statistical Functions |
| QUARTILE.INC | the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (New in Excel 2010 - replaces the Quartile function) | Statistical Functions |
| QUOTIENT | the integer portion of a division between two supplied numbers | Statistical Functions |
| R | | |
| RADIANS | Converts Degrees to Radians | Statistical Functions |
| RAND | a random number between 0 and 1 | Math Functions |
| RANDBETWEEN | a random number between two given integers | Statistical Functions |
| RANK | the statistical rank of a given value, within a supplied array of values (Replaced by Rank.Eq function in Excel 2010) | Statistical Functions |
| RANK.AVG | 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 2010) | Statistical Functions |
| RANK.EQ | 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 2010 - replaces the Rank function) | Statistical Functions |
| RATE | Calculates the interest rate required to pay off a specified amount of a loan, or reach a target amount on an investment over a given period | Statistical Functions |
| RECEIVED | Calculates the amount received at maturity for a fully invested Security | Financial Functions |
| REPLACE | Replaces all or part of a text string with another string (from a user supplied position) | text Functions |
| REPT | a string consisting of a supplied text string, repeated a specified number of times | text Functions |
| RIGHT | a specified number of characters from the end of a supplied text string | text Functions |
| ROMAN | a text string depicting the roman numeral for a given number | Miscellaneous |
| ROUND | Rounds a number up or down, to a given number of digits | Miscellaneous |
| ROUNDDOWN | Rounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a given number of digits | Statistical Functions |
| ROUNDUP | Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a given number of digits | Math Functions |
| ROW | the row number of a supplied range, or of the current cell | Math Functions |
| ROWS | the number of rows in a supplied range | Reference Functions |
| RRI | Calculates an equivalent interest rate for the growth of an investment (New in Excel 2013) | Reference Functions |
| RSQ | the square of the Pearson product moment correlation coefficient | Financial Functions |
| RTD | Retrieves real-time data from a program that supports COM automation | Statistical Functions |
| S | | |
| SEARCH | the position of a supplied character or text string from within a supplied text string (non-case-sensitive) | text Functions |
| SEC | the secant of an angle (New in Excel 2013) | Statistical Functions |
| SECH | the hyperbolic secant of an angle (New in Excel 2013) | Math Functions |
| SECOND | the seconds part of a user-supplied time | Math Functions |
| SERIESSUM | the sum of a power series | Date and Time Functions |
| SHEET | the sheet number relating to a supplied reference (New in Excel 2013) | Information Functions |
| SHEETS | the number of sheets in a reference (New in Excel 2013) | Information Functions |
| SIGN | the sign (+1, -1 or 0) of a supplied number | Math Functions |
| SIN | the Sine of a given angle | Math Functions |
| SINH | the Hyperbolic Sine of a number | Math Functions |
| SKEW | the skewness of a distribution | Math Functions |
| SKEW.P | the skewness of a distribution based on a population (New in Excel 2013) | Statistical Functions |
| SLN | the straight-line depreciation of an asset for one period | Statistical Functions |
| SLOPE | the slope of the linear regression line through a supplied series of x- and y- values | Statistical Functions |
| SMALL | the kth smallest value from a list of supplied numbers, for a given value k | Statistical Functions |
| SQRT | the positive square root of a given number | Math Functions |
| SQRTPI | the square root of a supplied number multiplied by pi | Math Functions |
| STANDARDIZE | a normalized value | Math Functions |
| STDEV | the standard deviation of a supplied set of values (which represent a sample of a population) (Replaced by Stdev.S function in Excel 2010) | Statistical Functions |
| STDEV.P | the standard deviation of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces the Stdevp function) | Statistical Functions |
| STDEV.S | the standard deviation of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces the Stdev function) | Statistical Functions |
| STDEVA | 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 | Statistical Functions |
| STDEVP | the standard deviation of a supplied set of values (which represent an entire population) (Replaced by Stdev.P function in Excel 2010) | Statistical Functions |
| STDEVPA | 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 | Statistical Functions |
| STEYX | the standard error of the predicted y-value for each x in the regression line for a set of supplied x- and y- values | Statistical Functions |
| SUBSTITUTE | Substitutes all occurrences of a search text string, within an original text string, with the supplied replacement text | text Functions |
| SUBTOTAL | Performs a specified calculation (e.g. the sum, product, average, etc.) for a supplied set of values | Math Functions |
| SUM | the sum of a supplied list of numbers | Math Functions |
| SUMIF | Adds the cells in a supplied range, that satisfy a given criteria | Math Functions |
| SUMIFS | Adds the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007) | Math Functions |
| SUMPRODUCT | the sum of the products of corresponding values in two or more supplied arrays | Math Functions |
| SUMSQ | the sum of the squares of a supplied list of numbers | Math Functions |
| SUMX2MY2 | the sum of the difference of squares of corresponding values in two supplied arrays | Math Functions |
| SUMX2PY2 | the sum of the sum of squares of corresponding values in two supplied arrays | Math Functions |
| SUMXMY2 | the sum of squares of differences of corresponding values in two supplied arrays | Math Functions |
| SWITCH | Compares a number of supplied values to a supplied test expression and a result corresponding to the first value that matches the test expression (New in Excel 2016 - not available in Excel 2016 for Mac) | Logical Functions |
| SYD | the sum-of-years' digits depreciation of an asset for a specified period | Financial Functions |
| T | | |
| T | Tests whether a supplied value is text and if so, the supplied text; If not, an empty text string | text Functions |
| T.DIST | the Student's T-distribution (probability density or cumulative distribution function) (New in Excel 2010) | Statistical Functions |
| T.DIST.2T | the two-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function) | Statistical Functions |
| T.DIST.RT | the right-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function) | Statistical Functions |
| T.INV | the left-tailed inverse of the Student's T-distribution (New in Excel 2010) | Statistical Functions |
| T.INV.2T | the two-tailed inverse of the Student's T-distribution (New in Excel 2010 - replaces the Tinv function) | Statistical Functions |
| T.TEST | the probability associated with a Student's T-Test (New in Excel 2010 - replaces the Ttest function) | Statistical Functions |
| TAN | the Tangent of a given angle | Statistical Functions |
| TANH | the Hyperbolic Tangent of a given number | Math Functions |
| TBILLEQ | Calculates the bond-equivalent yield for a treasury bill | Math Functions |
| TBILLPRICE | Calculates the price per $100 face value for a treasury bill | Financial Functions |
| TBILLYIELD | Calculates the yield for a treasury bill | Financial Functions |
| TDIST | the Student's T-distribution (Replaced by T.Dist.2t & T.Dist.Rt functions in Excel 2010) | Financial Functions |
| TEXT | Converts a supplied value into text, using a user-specified format | text Functions |
| TEXTJOIN | Joins together two or more text strings, separated by a delimiter (New in Excel 2016 - not available in Excel 2016 for Mac) | text Functions |
| TIME | a time, from a user-supplied hour, minute and second | Date and Time Functions |
| TIMEVALUE | Converts a text string showing a time, to a decimal that represents the time in Excel | Date and Time Functions |
| TINV | the two-tailed inverse of the Student's T-distribution (Replaced by T.Inv.2t function in Excel 2010) | Date and Time Functions |
| TODAY | today's date | Statistical Functions |
| TRANSPOSE | Performs a transpose transformation on a range of cells (i.e. transforms a horizontal range of cells into a vertical range and vice versa) | Date and Time Functions |
| TREND | Calculates the trend line through a given set of y-values and additional y-values for a supplied set of new x-values | Reference Functions |
| TRIM | Removes all spaces from a test string except for single spaces between words. When TRIM does not remove Non-Breaking spaces, use this TRIM(SUBSTITUTE(D1,CHAR(160),CHAR(32))) | text Functions |
| TRIMMEAN | the mean of the interior of a supplied set of values | Statistical Functions |
| TRUE | Simply the logical value TRUE | Logical Functions |
| TRUNC | Truncates a number towards zero (i.e. rounds a positive number down and a negative number up), to the next integer. | text Functions |
| TTEST | the probability associated with a Student's T-Test (Replaced by T.Test function in Excel 2010) | Math Functions |
| TYPE | information about the data type of a supplied value | Information Functions |
| U | | |
| UNICHAR | the Unicode character that is referenced by the given numeric value (New in Excel 2013) | text Functions |
| UNICODE | the number (code point) corresponding to the first character of a supplied text string (New in Excel 2013) | text Functions |
| UPPER | Converts all characters in a supplied text string to upper case | text Functions |
| V | | |
| VALUE | Converts a text string into a numeric value | text Functions |
| VAR | the variance of a supplied set of values (which represent a sample of a population) (Replaced by Var.S function in Excel 2010) | Statistical Functions |
| VAR.P | the variance of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces the Varp function) | Statistical Functions |
| VAR.S | the variance of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces the Var function) | Statistical Functions |
| VARA | 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 | Statistical Functions |
| VARP | the variance of a supplied set of values (which represent an entire population) (Replaced by Var.P function in Excel 2010) | Statistical Functions |
| VARPA | 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 | Statistical Functions |
| VDB | the depreciation of an asset for a specified period, (including partial periods), using the double-declining balance method or another user-specified method | Statistical Functions |
| VLOOKUP | Looks up a supplied value in the first column of a table, and the corresponding value from another column | Data Lookup Functions |
| W | | |
| WEBSERVICE | data from a web service on the Internet or Intranet (New in Excel 2013) | Web Functions |
| WEEKDAY | Returns a number representing the day of the week, given a date value | Date and Time Functions |
| WEEKNUM | an integer representing the week number (from 1 to 53) of the year from a user-supplied date | Date and Time Functions |
| WEIBULL | the Weibull distribution (Replaced by Weibull.Dist function in Excel 2010) | Statistical Functions |
| WEIBULL.DIST | the Weibull distribution (New in Excel 2010 - replaces the Weibull function) | Statistical Functions |
| WORKDAY | a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date | Statistical Functions |
| WORKDAY.INTL | 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 (New in Excel 2010) | Date and Time Functions |
| X | | |
| XIRR | Calculates the internal rate of return for a schedule of cash flows | Financial Functions |
| XNPV | Calculates the net present value for a schedule of cash flows | Financial Functions |
| XOR | a logical Exclusive Or of all arguments (New in Excel 2013) | Logical Functions |
| Y | | |
| YEAR | Returns a four-digit year (a number from 1900 to 9999) given a date value | Date and Time Functions |
| YEARFRAC | Calculates the fraction of the year represented by the number of whole days between two dates | Date and Time Functions |
| YIELD | Calculates the yield of a security that pays periodic interest | Date and Time Functions |
| YIELDDISC | Calculates the annual yield of a discounted security | Financial Functions |
| YIELDMAT | Calculates the annual yield of a security that pays interest at maturity | Financial Functions |
| Z | | |
| Z.TEST | the one-tailed probability value of a z-test (New in Excel 2010 - replaces the Ztest function) | Statistical Functions |