ExcelFunctions.net

Search Site:

This page lists the current built-in Excel Functions, ordered alphabetically. Selecting a function will take to the function page, which contains a full description of the function, with examples of use and details of common errors.

A | B | C | D | E | F | G | H | I | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |

A | |

ABS | Returns the absolute value (ie. the modulus) of a supplied number |

ACOS | Returns the Arccosine of a number |

ACOSH | Returns the inverse hyperbolic cosine of a number |

ACOT | Returns the arccotangent of a number (New in Excel 2013) |

ACOTH | Returns the hyperbolic arccotangent of a number (New in Excel 2013) |

ACCRINT | Calculates the accrued interest for a security that pays periodic interest |

ACCRINTM | Calculates the accrued interest for a security that pays interest at maturity |

ADDRESS | Returns a reference, in text format, for a supplied row and column number |

AGGREGATE | Performs a specified calculation (eg. the sum, product, average, etc.) for a list or database, with the option to ignore hidden rows and error values (New in Excel 2010) |

AMORDEGRC | Calculates the prorated linear depreciation of an asset for each accounting period (with depreciation coefficient applied, depending on the life of the asset) |

AMORLINC | Calculates the prorated linear depreciation of an asset for each accounting period |

AND | Tests a number of user-defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise |

ARABIC | Converts a Roman numeral to an Arabic numeral (New in Excel 2013) |

AREAS | Returns the number of areas in a supplied range |

ASIN | Returns the Arcsine of a number |

ASINH | Returns the Inverse Hyperbolic Sine of a number |

ATAN | Returns the Arctangent of a given number |

ATAN2 | Returns the Arctangent of a given pair of x and y coordinates |

ATANH | Returns the Inverse Hyperbolic Tangent of a given number |

AVEDEV | Returns the average of the absolute deviations of data points from their mean |

AVERAGE | Returns the Average of a list of supplied numbers |

AVERAGEA | Returns 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 |

AVERAGEIF | Calculates the Average of the cells in a supplied range, that satisfy a given criteria (New in Excel 2007) |

AVERAGEIFS | Calculates the Average of the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007) |

B | |

BASE | Converts a number into a text representation, with the supplied base (New in Excel 2013) |

BAHTTEXT | Converts a number, plus the suffix "Baht" into Thai text |

BESSELI | Calculates the modified Bessel function In(x) |

BESSELJ | Calculates the Bessel function Jn(x) |

BESSELK | Calculates the modified Bessel function Kn(x) |

BESSELY | Calculates the modified Bessel function Yn(x) |

BETADIST | Returns the cumulative beta probability density function (Replaced by Beta.Dist function in Excel 2010) |

BETA.DIST | Returns the cumulative beta distribution function or the beta probability density function (New in Excel 2010 - replaces Betadist function) |

BETAINV | Returns the inverse of the cumulative beta probability density function (Replaced by Beta.Inv function in Excel 2010) |

BETA.INV | Returns the inverse of the cumulative beta probability density function (New in Excel 2010 - replaces Betainv function) |

BIN2DEC | Converts a binary number to a decimal |

BIN2HEX | Converts a binary number to hexadecimal |

BIN2OCT | Converts a binary number to octal |

BINOMDIST | Returns the individual term binomial distribution probability (Replaced by Binom.Dist function in Excel 2010) |

BINOM.DIST | Returns the individual term binomial distribution probability (New in Excel 2010 - replaces Binomdist function) |

BINOM.DIST.RANGE | Returns the probability of a trial result using a binomial distribution (New in Excel 2013) |

BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (New in Excel 2010 - replaces Critbinom function) |

BITAND | Returns a Bitwise 'And' of two numbers (New in Excel 2013) |

BITOR | Returns a Bitwise 'Or' of two numbers (New in Excel 2013) |

BITLSHIFT | Returns a number shifted left by a specified number of bits (New in Excel 2013) |

BITRSHIFT | Returns a number shifted right by a specified number of bits (New in Excel 2013) |

BITXOR | Returns a Bitwise 'Exclusive Or' of two numbers (New in Excel 2013) |

C | |

CEILING | Rounds a number away from zero (ie. rounds a positive number up and a negative number down), to a multiple of significance |

CEILING.MATH | Rounds a number up to the nearest integer or to the nearest multiple of significance (New in Excel 2013) |

CEILING.PRECISE | Rounds a number up, regardless of the sign of the number, to a multiple of significance (New in Excel 2010) |

CELL | Returns information about the contents, formatting or location of a given cell |

CHAR | Returns the character that corresponds to a supplied numeric value |

CHIDIST | Returns the right-tailed probability of the chi-squared distribution (Replaced by CHISQ.DIST.RT function in Excel 2010) |

CHISQ.DIST | Returns the chi-squared distribution (probability density or cumulative distribution function) (New in Excel 2010) |

CHISQ.DIST.RT | Returns the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces CHIDIST function) |

CHIINV | Returns the inverse of the right-tailed probability of the chi-squared distribution (Replaced by CHISQ.INV.RT function in Excel 2010) |

CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution (New in Excel 2010) |

CHI.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces CHIINV function) |

CHITEST | Returns the chi-squared statistical test for independence (Replaced by CHISQ.TEST function in Excel 2010) |

CHISQ.TEST | Returns the chi-squared statistical test for independence (New in Excel 2010 - replaces CHITEST function) |

CHOOSE | Returns one of a list of values, depending on the value of a supplied index number |

CLEAN | Removes all non-printable characters from a supplied text string |

CODE | Returns the numeric code for the first character of a supplied string |

COLUMN | Returns the column number of a supplied range, or of the current cell |

COLUMNS | Returns the number of columns in a supplied range |

COMBIN | Returns the number of combinations (without repetitions) for a given number of objects |

COMBINA | Returns the number of combinations (with repetitions) for a given number of items (New in Excel 2013) |

COMPLEX | Converts user-supplied real and imaginary coefficients into a complex number |

CONCATENATE | Joins together two or more text strings |

CONFIDENCE | Returns the confidence interval for a population mean, using a normal distribution (Replaced by CONFIDENCE.NORM function in Excel 2010) |

CONFIDENCE.NORM | Returns the confidence interval for a population mean, using a normal distribution (New in Excel 2010 - replaces CONFIDENCE function) |

CONFIDENCE.T | Returns the confidence interval for a population mean, using a Student's t distribution (New in Excel 2010) |

CONVERT | Converts a number from one measurement system to another |

CORREL | Returns the correlation coefficient between two sets of values |

COS | Returns the Cosine of a given angle |

COSH | Returns the hyperbolic cosine of a number |

COT | Returns the cotangent of an angle (New in Excel 2013) |

COTH | Returns the hyperbolic cotangent of an angle (New in Excel 2013) |

COUNT | Returns the number of numerical values in a supplied set of cells or values |

COUNTA | Returns the number of non-blanks in a supplied set of cells or values |

COUNTBLANK | Returns the number of blank cells in a supplied range |

COUNTIF | Returns the number of cells (of a supplied range), that satisfy a given criteria |

COUNTIFS | Returns the number of cells (of a supplied range), that satisfy a set of given criteria (New in Excel 2007) |

COUPDAYBS | Calculates the number of days from the beginning of the coupon period to the settlement date |

COUPDAYS | Calculates the number of days in the coupon period that contains the settlement date |

COUPDAYSNC | Calculates the number of days from the settlement date to the next coupon date |

COUPNCD | Returns the next coupon date after the settlement date |

COUPNUM | Returns the number of coupons payable between the settlement date and maturity date |

COUPPCD | Returns the previous coupon date, before the settlement date |

COVAR | Returns population covariance (ie. the average of the products of deviations for each pair within two supplied data sets) (Replaced by COVARIANCE.P function in Excel 2010) |

COVARIANCE.P | Returns population covariance (ie. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010 - replaces COVAR function) |

COVARIANCE.S | Returns sample covariance (ie. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010) |

CRITBINOM | Returns 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) |

CSC | Returns the cosecant of an angle (New in Excel 2013) |

CSCH | Returns the hyperbolic cosecant of an angle (New in Excel 2013) |

CUMIPMT | Calculates the cumulative interest paid between two specified periods |

CUMPRINC | Calculates the cumulative principal paid on a loan, between two specified periods |

D | |

DATE | Returns a date, from a user-supplied year, month and day |

DATEVALUE | Converts a text string showing a date, to an integer that represents the date in Excel's date-time code |

DAVERAGE | Calculates the average of values in a field of a list or database, that satisfy specified conditions |

DAY | Returns the day (of the month) from a user-supplied date |

DAYS | Returns the number of days between 2 dates (New in Excel 2013) |

DAYS360 | Calculates the number of days between 2 dates, based on a 360-day year (12 x 30 months) |

DB | Calculates the depreciation of an asset for a specified period, using the fixed-declining balance method |

DCOUNT | Returns the number of cells containing numbers in a field of a list or database that satisfy specified conditions |

DCOUNTA | Returns the number of non-blank cells in a field of a list or database, that satisfy specified conditions |

DDB | Calculates the depreciation of an asset for a specified period, using the double-declining balance method, or some other user-specified method |

DEC2BIN | Converts a decimal number to binary |

DEC2HEX | Converts a decimal number to hexadecimal |

DEC2OCT | Converts a decimal number to octal |

DECIMAL | Converts a text representation of a number in a specified base into a decimal number (New in Excel 2013) |

DEGREES | Converts Radians to Degrees |

DELTA | Tests whether two supplied numbers are equal |

DEVSQ | Returns the sum of the squares of the deviations of a set of data points from their sample mean |

DGET | Returns a single value from a field of a list or database, that satisfy specified conditions |

DISC | Calculates the discount rate for a security |

DMAX | Returns the maximum value from a field of a list or database, that satisfy specified conditions |

DMIN | Returns the minimum value from a field of a list or database, that satisfy specified conditions |

DOLLAR | Converts a supplied number into text, using a currency format |

DOLLARDE | Converts a dollar price expressed as a fraction, into a dollar price expressed as a decimal |

DOLLARFR | Converts a dollar price expressed as a decimal, into a dollar price expressed as a fraction |

DPRODUCT | Calculates the product of values in a field of a list or database, that satisfy specified conditions |

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 |

DSTDEVP | Calculates the standard deviation (based on an entire population), of values in a field of a list or database, that satisfy specified conditions |

DSUM | Calculates the sum of values in a field of a list or database, that satisfy specified conditions |

DURATION | Calculates the Macauley duration of a security with an assumed par value of $100 |

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 |

DVARP | Calculates the variance (based on an entire population), of values in a field of a list or database, that satisfy specified conditions |

E | |

EDATE | Returns a date that is the specified number of months before or after an initial supplied start date |

EFFECT | Calculates the effective annual interest rate |

ENCODEURL | Returns a URL-encoded string (New in Excel 2013) |

EOMONTH | Returns 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 |

ERF | Returns the error function integrated between two supplied limits |

ERF.PRECISE | Returns the error function integrated between 0 and a supplied limit (New in Excel 2010) |

ERFC | Returns the complementary error function integrated between a supplied lower limit and infinity |

ERFC.PRECISE | Returns the complementary error function integrated between a supplied lower limit and infinity (New in Excel 2010) |

ERROR.TYPE | Tests a supplied value and returns an integer relating to the supplied value's error type |

EVEN | Rounds a number away from zero (ie. rounds a positive number up and a negative number down), to the next even number |

EXACT | Tests if two supplied text strings are exactly the same and if so, returns TRUE; Otherwise, returns FALSE. (case-sensitive) |

EXP | Returns e raised to a given power |

EXPONDIST | Returns the exponential distribution (Replaced by EXPON.DIST function in Excel 2010) |

EXPON.DIST | Returns the exponential distribution (New in Excel 2010 - replaces EXPONDIST function) |

F | |

FACT | Returns the Factorial of a given number |

FACTDOUBLE | Returns the Double Factorial of a given number |

FALSE | Simply returns the logical value FALSE |

FDIST | Returns the right-tailed F probability distribution for two data sets (Replaced by F.DIST.RT function in Excel 2010) |

F.DIST | Returns the F probability distribution (probability density or cumulative distribution function) (New in Excel 2010) |

F.DIST.RT | Returns the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces FDIST function) |

FILTERXML | Returns data from XML content, using a specified XPath (New in Excel 2013) |

FIND | Returns the position of a supplied character or text string from within a supplied text string (case-sensitive) |

FINV | Returns the inverse of the right-tailed F probability distribution for two data sets (Replaced by F.INV.RT function in Excel 2010) |

F.INV | Returns the inverse of the Cumulative F distribution (New in Excel 2010) |

F.INV.RT | Returns the inverse of the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces FINV function) |

FISHER | Returns the Fisher transformation |

FISHERINV | Returns the inverse of the Fisher transformation |

FIXED | Rounds a supplied number to a specified number of decimal places, and then converts this into text |

FLOOR | Rounds a number towards zero, (ie. rounds a positive number down and a negative number up), to a multiple of significance |

FLOOR.MATH | Rounds a number down, to the nearest integer or to the nearest multiple of significance (New in Excel 2013) |

FLOOR.PRECISE | Rounds a number down, regardless of the sign of the number, to a multiple of significance (New in Excel 2010) |

FORECAST | Predicts a future point on a linear trend line fitted to a supplied set of x- and y- values |

FORMULATEXT | Returns a formula as a string (New in Excel 2013) |

FREQUENCY | Returns an array showing the number of values from a supplied array, which fall into specified ranges |

FTEST | Returns the result of an F-Test for 2 supplied data sets (Replaced by F.TEST function in Excel 2010) |

F.TEST | Returns the result of an F-Test for 2 supplied data sets (New in Excel 2010 - replaces FTEST function) |

FV | Calculates the future value of an investment with periodic constant payments and a constant interest rate |

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) |

GAMMADIST | Returns the gamma distribution (Replaced by GAMMA.DIST function in Excel 2010) |

GAMMA.DIST | Returns the gamma distribution (New in Excel 2010 - replaces GAMMADIST function) |

GAMMAINV | Returns the inverse gamma cumulative distribution (Replaced by GAMMA.INV function in Excel 2010) |

GAMMA.INV | Returns the inverse gamma cumulative distribution (New in Excel 2010 - replaces GAMMAINV function) |

GAMMALN | Calculates the natural logarithm of the gamma function for a supplied value |

GAMMALN.PRECISE | Returns the natural logarithm of the gamma function for a supplied value (New in Excel 2010) |

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) |

GCD | Returns the Greatest Common Divisor of two or more supplied numbers |

GEOMEAN | Returns the geometric mean of a set of supplied numbers |

GESTEP | Tests whether a number is greater than a supplied threshold value |

GETPIVOTDATA | Extracts data stored in a Pivot Table |

GROWTH | Returns numbers in a exponential growth trend, based on a set of supplied x- and y- values |

H | |

HARMEAN | Returns the harmonic mean of a set of supplied numbers |

HEX2BIN | Converts a hexadecimal number to binary |

HEX2DEC | Converts a hexadecimal number to a decimal |

HEX2OCT | Converts a hexadecimal number to octal |

HLOOKUP | Looks up a supplied value in the first row of a table, and returns the corresponding value from another row |

HOUR | Returns the hour part of a user-supplied time |

HYPERLINK | Creates a hyperlink to a document in a supplied location |

HYPGEOMDIST | Returns the hypergeometric distribution (Replaced by HYPGEOM.DIST function in Excel 2010) |

HYPGEOM.DIST | Returns the hypergeometric distribution (New in Excel 2010 - replaces HYPGEOMDIST function) |

I | |

IF | Tests a user-defined condition and returns one result if the condition is TRUE, and another result if the condition is FALSE |

IFERROR | Tests if an initial supplied value (or expression) returns an error, and if so the function returns a supplied value; Otherwise the function returns the initial value. (New in Excel 2007) |

IFNA | Tests if an expression returns the #N/A error and if so, returns an alternative specified value; Otherwise the function returns the value of the supplied expression (New in Excel 2013) |

IMABS | Returns the absolute value (the modulus) of a complex number |

IMAGINARY | Returns the imaginary coefficient of a complex number |

IMARGUMENT | Returns the argument Θ (an angle expressed in radians) of a complex number |

IMCONJUGATE | Returns the complex conjugate of a complex number |

IMCOS | Returns the cosine of a complex number |

IMCOSH | Returns the hyperbolic cosine of a complex number (New in Excel 2013) |

IMCOT | Returns the cotangent of a complex number (New in Excel 2013) |

IMCSC | Returns the cosecant of a complex number (New in Excel 2013) |

IMCSCH | Returns the hyperbolic cosecant of a complex number (New in Excel 2013) |

IMDIV | Returns the quotient of two supplied complex numbers |

IMEXP | Returns the exponential of a complex number |

IMLN | Returns the natural logarithm of a complex number |

IMLOG10 | Returns the base-10 logarithm of a complex number |

IMLOG2 | Returns the base-2 logarithm of a complex number |

IMPOWER | Calculates a complex number raised to a supplied power |

IMPRODUCT | Returns the product of up to 255 supplied complex numbers |

IMREAL | Returns the real coefficient of a complex number |

IMSEC | Returns the secant of a complex number (New in Excel 2013) |

IMSECH | Returns the hyperbolic secant of a complex number (New in Excel 2013) |

IMSIN | Returns the sine of a complex number |

IMSINH | Returns the hyperbolic sine of a complex number (New in Excel 2013) |

IMSQRT | Returns the square root of a complex number |

IMSUB | Subtracts two complex numbers |

IMSUM | Calculates the sum of two complex numbers |

IMTAN | Returns the tangent of a complex number (New in Excel 2013) |

INDEX | Returns a reference to a cell (or range of cells) for requested rows and columns within a supplied range |

INDIRECT | Returns a cell or range reference that is represented by a supplied text string |

INFO | Returns information about the the current operating environment |

INT | Rounds a number down to the next integer |

INTERCEPT | Calculates the best fit regression line, through a supplied series of x- and y- values and returns the value at which this line intercepts the y-axis |

INTRATE | Calculates the interest rate for a fully invested security |

IPMT | Calculates the interest payment for a given period of an investment, with periodic constant payments and a constant interest rate |

IRR | Calculates the internal rate of return for a series of cash flows |

ISBLANK | Tests if a supplied cell is blank (empty), and if so, returns TRUE; Otherwise, returns FALSE |

ISERR | Tests if an initial supplied value (or expression) returns an error (EXCEPT for the #N/A error) and if so, returns TRUE; Otherwise returns FALSE |

ISERROR | Tests if an initial supplied value (or expression) returns an error and if so, returns TRUE; Otherwise returns FALSE |

ISEVEN | Tests if a supplied number (or expression) is an even number, and if so, returns TRUE; Otherwise, returns FALSE. |

ISFORMULA | Tests if a supplied cell contains a formula and if so, returns TRUE; Otherwise, returns FALSE (New in Excel 2013) |

ISLOGICAL | Tests if a supplied value is a logical value, and if so, returns TRUE; Otherwise, returns FALSE |

ISNA | Tests if an initial supplied value (or expression) returns the Excel #N/A error and if so, returns TRUE; Otherwise returns FALSE |

ISNONTEXT | Tests if a supplied value is text, and if it is NOT, returns TRUE; Otherwise, returns FALSE |

ISNUMBER | Tests if a supplied value is a number, and if so, returns TRUE; Otherwise, returns FALSE |

ISO.CEILING | Rounds a number up, regardless of the sign of the number, to a multiple of significance. (New in Excel 2010) |

ISODD | Tests if a supplied number (or expression) is an odd number, and if so, returns TRUE; Otherwise, returns FALSE |

ISOWEEKNUM | Returns the ISO week number of the year for a given date (New in Excel 2013) |

ISPMT | Returns the interest paid during a specified period of an investment |

ISREF | Tests if a supplied value is a reference, and if so, returns TRUE; Otherwise, returns FALSE |

ISTEXT | Tests if a supplied value is text, and if so, returns TRUE; Otherwise, returns FALSE |

K | |

KURT | Returns the kurtosis of a data set |

L | |

LARGE | Returns the kth largest value from a list of supplied numbers, for a given value k |

LCM | Returns the Least Common Multiple of two or more supplied numbers |

LEFT | Returns a specified number of characters from the start of a supplied text string |

LEN | Returns the length of a supplied text string |

LINEST | Returns statistical information describing the trend of the line of best fit, through a supplied series of x- and y- values |

LN | Returns the natural logarithm of a given number |

LOG | Returns the logarithm of a given number, to a specified base |

LOG10 | Returns the base 10 logarithm of a given number |

LOGEST | Returns the parameters of an exponential trend for a supplied set of x- and y- values |

LOGNORMDIST | Returns the cumulative log-normal distribution (Replaced by LOGNORM.DIST function in Excel 2010) |

LOGNORM.DIST | Returns the log-normal probability density function or the cumulative log- normal distribution (New in Excel 2010 - replaces LOGNORMDIST function) |

LOGINV | Returns the inverse of the lognormal distribution (Replaced by LOGNORM.INV function in Excel 2010) |

LOGNORM.INV | Returns the inverse of the lognormal distribution (New in Excel 2010 - replaces LOGINV function) |

LOOKUP | Searches for a specific value in one data vector, and returns a value from the corresponding position of a second data vector |

LOWER | Converts all characters in a supplied text string to lower case |

M | |

MATCH | Finds the relative position of a value in a supplied array |

MAX | Returns the largest value from a list of supplied numbers |

MAXA | Returns 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 |

MDETERM | Returns the matrix determinant of a supplied array |

MDURATION | Calculates the Macauley modified duration for a security with an assumed par value of $100 |

MEDIAN | Returns the Median (the middle value) of a list of supplied numbers |

MID | Returns a specified number of characters from the middle of a supplied text string |

MIN | Returns the smallest value from a list of supplied numbers |

MINA | Returns 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 |

MINUTE | Returns the minute part of a user-supplied time |

MINVERSE | Returns the matrix inverse of a supplied array |

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 |

MMULT | Returns the matrix product of two supplied arrays |

MOD | Returns the remainder from a division between two supplied numbers |

MODE | Returns the Mode (the most frequently occurring value) of a list of supplied numbers (Replaced by MODE.SNGL function in Excel 2010) |

MODE.MULT | Returns a vertical array of the most frequently occurring values in an array or range of data (New in Excel 2010) |

MODE.SNGL | Returns the Mode (the most frequently occurring value) of a list of supplied numbers (New in Excel 2010 - replaces MODE function) |

MONTH | Returns the month from a user-supplied date |

MROUND | Rounds a number up or down, to the nearest multiple of significance |

MULTINOMIAL | Returns the Multinomial of a given set of numbers |

MUNIT | Returns the unit matrix for a specified dimension (New in Excel 2013) |

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 |

NA | Returns the Excel #N/A error |

NEGBINOMDIST | Returns the negative binomial distribution (Replaced by NEGBINOM.DIST function in Excel 2010) |

NEGBINOM.DIST | Returns the negative binomial distribution (New in Excel 2010 - replaces NEGBINOMDIST function) |

NETWORKDAYS | Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates |

NETWORKDAYS.INTL | Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days (New in Excel 2010) |

NOMINAL | Calculates the annual nominal interest rate |

NORMDIST | Returns the normal cumulative distribution (Replaced by NORM.DIST function in Excel 2010) |

NORM.DIST | Returns the normal cumulative distribution (New in Excel 2010 - replaces NORMDIST function) |

NORMINV | Returns the inverse of the normal cumulative distribution (Replaced by NORM.INV function in Excel 2010) |

NORM.INV | Returns the inverse of the normal cumulative distribution (New in Excel 2010 - replaces NORMINV function) |

NORMSDIST | Returns the standard normal cumulative distribution (Replaced by NORM.S.DIST function in Excel 2010) |

NORM.S.DIST | Returns the standard normal cumulative distribution (New in Excel 2010 - replaces NORMSDIST function) |

NORMSINV | Returns the inverse of the standard normal cumulative distribution (Replaced by NORM.S.INV function in Excel 2010) |

NORM.S.INV | Returns the inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces NORMSINV function) |

NOT | Returns a logical value that is the opposite of a user supplied logical value or expression (ie. returns FALSE is the supplied argument is TRUE and returns TRUE if the supplied argument is FALSE) |

NOW | Returns the current date & time |

NPER | Returns the number of periods for an investment with periodic constant payments and a constant interest rate |

NPV | Calculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and income |

NUMBERVALUE | Converts text to a number, in a locale-independent way (New in Excel 2013) |

O | |

OCT2BIN | Converts octal number to binary |

OCT2DEC | Converts octal number to a decimal |

OCT2HEX | Converts octal number to hexadecimal |

ODD | Rounds a number away from zero (ie. rounds a positive number up and a negative number down), to the next odd number |

ODDFPRICE | Calculates the price per $100 face value of a security with an odd first period |

ODDFYIELD | Calculates the yield of a security with an odd first period |

ODDLPRICE | Calculates the price per $100 face value of a security with an odd last period |

ODDLYIELD | Calculates the yield of a security with an odd last period |

OFFSET | Returns a reference to a range of cells that is a specified number of rows and columns from an initial supplied range |

OR | Tests a number of user-defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwise |

P | |

PDURATION | Calculates the number of periods required for an investment to reach a specified value (New in Excel 2013) |

PEARSON | Returns the Pearson product moment correlation coefficient |

PERCENTILE | Returns 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) |

PERCENTILE.EXC | Returns the k'th percentile of values in a supplied range, where k is in the range 0 - 1 (exclusive) (New in Excel 2010) |

PERCENTILE.INC | Returns the k'th percentile of values in a supplied range, where k is in the range 0 - 1 (inclusive) (New in Excel 2010 - replaces PERCENTILE function) |

PERCENTRANK | Returns the rank of a value in a data set, as a percentage (0 - 1 inclusive) (Replaced by PERCENTRANK.INC function in Excel 2010) |

PERCENTRANK.EXC | Returns the rank of a value in a data set, as a percentage (0 - 1 exclusive) (New in Excel 2010) |

PERCENTRANK.INC | Returns the rank of a value in a data set, as a percentage (0 - 1 inclusive) (New in Excel 2010 - replaces PERCENTRANK function) |

PERMUT | Returns the number of permutations for a given number of objects |

PERMUTATIONA | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (New in Excel 2013) |

PHI | Returns the value of the density function for a standard normal distribution, for a supplied number (New in Excel 2013) |

PI | Returns the constant value of pi |

PMT | Calculates the payments required to reduce a loan, from a supplied present value to a specified future value |

POISSON | Returns the Poisson distribution (Replaced by POISSON.DIST function in Excel 2010) |

POISSON.DIST | Returns the Poisson distribution (New in Excel 2010 - replaces POISSON function) |

POWER | Returns the result of a given number raised to a supplied power |

PPMT | Calculates the payment on the principal for a given investment, with periodic constant payments and a constant interest rate |

PRICE | Calculates the price per $100 face value of a security that pays periodic interest |

PRICEDISC | Calculates the price per $100 face value of a discounted security |

PRICEMAT | Calculates the price per $100 face value of a security that pays interest at maturity |

PROB | Returns the probablity that values in a supplied range are within given limits |

PRODUCT | Returns the product of a supplied list of numbers |

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) |

PV | Calculates the present value of an investment (ie. the total amount that a series of future payments is worth now) |

Q | |

QUARTILE | Returns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (Replaced by QUARTILE.INC function in Excel 2010) |

QUARTILE.EXC | Returns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (exclusive) (New in Excel 2010) |

QUARTILE.INC | Returns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (New in Excel 2010 - replaces QUARTILE function) |

QUOTIENT | Returns the integer portion of a division between two supplied numbers |

R | |

RADIANS | Converts Degrees to Radians |

RAND | Returns a random number between 0 and 1 |

RANDBETWEEN | Returns a random number between two given integers |

RANK | Returns the statistical rank of a given value, within a supplied array of values (Replaced by RANK.EQ function in Excel 2010) |

RANK.AVG | Returns the statistical rank of a given value, within a supplied array of values (if more than one value has same rank, the average rank is returned) (New in Excel 2010) |

RANK.EQ | Returns the Mode (the most frequently occurring value) of a list of supplied numbers (if more than one value has same rank, the top rank of that set is returned) (New in Excel 2010 - replaces RANK function) |

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 |

RECEIVED | Calculates the amount received at maturity for a fully invested Security |

REPLACE | Replaces all or part of a text string with another string (from a user supplied position) |

REPT | Returns a string consisting of a supplied text string, repeated a specified number of times |

RIGHT | Returns a specified number of characters from the end of a supplied text string |

ROMAN | Returns a text string depicting the roman numeral for a given number |

ROUND | Rounds a number up or down, to a given number of digits |

ROUNDDOWN | Rounds a number towards zero, (ie. rounds a positive number down and a negative number up), to a given number of digits |

ROUNDUP | Rounds a number away from zero (ie. rounds a positive number up and a negative number down), to a given number of digits |

ROW | Returns the row number of a supplied range, or of the current cell |

ROWS | Returns the number of rows in a supplied range |

RRI | Calculates an equivalent interest rate for the growth of an investment (New in Excel 2013) |

RSQ | Returns the square of the Pearson product moment correlation coefficient |

RTD | Retrieves real-time data from a program that supports COM automation |

S | |

SEARCH | Returns the position of a supplied character or text string from within a supplied text string (non-case-sensitive) |

SEC | Returns the secant of an angle (New in Excel 2013) |

SECH | Returns the hyperbolic secant of an angle (New in Excel 2013) |

SECOND | Returns the seconds part of a user-supplied time |

SERIESSUM | Returns the sum of a power series |

SHEET | Returns the sheet number relating to a supplied reference (New in Excel 2013) |

SHEETS | Returns the number of sheets in a reference (New in Excel 2013) |

SIGN | Returns the sign (+1, -1 or 0) of a supplied number |

SIN | Returns the Sine of a given angle |

SINH | Returns the Hyperbolic Sine of a number |

SKEW | Returns the skewness of a distribution |

SKEW.P | Returns the skewness of a distribution based on a population (New in Excel 2013) |

SLN | Returns the straight-line depreciation of an asset for one period |

SLOPE | Returns the slope of the linear regression line through a supplied series of x- and y- values |

SMALL | Returns the kth smallest value from a list of supplied numbers, for a given value k |

SQRT | Returns the positive square root of a given number |

SQRTPI | Returns the square root of a supplied number multiplied by pi |

STANDARDIZE | Returns a normalized value |

STDEV | Returns the standard deviation of a supplied set of values (which represent a sample of a population) (Replaced by STDEV.S function in Excel 2010) |

STDEVA | Returns the standard deviation of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |

STDEVP | Returns the standard deviation of a supplied set of values (which represent an entire population) (Replaced by STDEV.P function in Excel 2010) |

STDEVPA | Returns the standard deviation of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |

STDEV.P | Returns the standard deviation of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces STDEVP function) |

STDEV.S | Returns the standard deviation of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces STDEV function) |

STEYX | Returns the standard error of the predicted y-value for each x in the regression line for a set of supplied x- and y- values |

SUBSTITUTE | Substitutes all occurrences of a search text string, within an original text string, with the supplied replacement text |

SUBTOTAL | Performs a specified calculation (eg. the sum, product, average, etc.) for a supplied set of values |

SUM | Returns the sum of a supplied list of numbers |

SUMIF | Adds the cells in a supplied range, that satisfy a given criteria |

SUMIFS | Adds the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007) |

SUMPRODUCT | Returns the sum of the products of corresponding values in two or more supplied arrays |

SUMSQ | Returns the sum of the squares of a supplied list of numbers |

SUMX2MY2 | Returns the sum of the difference of squares of corresponding values in two supplied arrays |

SUMX2PY2 | Returns the sum of the sum of squares of corresponding values in two supplied arrays |

SUMXMY2 | Returns the sum of squares of differences of corresponding values in two supplied arrays |

SYD | Returns the sum-of-years' digits depreciation of an asset for a specified period |

T | |

T | Tests whether a supplied value is text and if so, returns the supplied text; If not, returns an empty text string |

TAN | Returns the Tangent of a given angle |

TANH | Returns the Hyperbolic Tangent of a given number |

TBILLEQ | Calculates the bond-equivalent yield for a treasury bill |

TBILLPRICE | Calculates the price per $100 face value for a treasury bill |

TBILLYIELD | Calculates the yield for a treasury bill |

TDIST | Returns the Student's T-distribution (Replaced by T.DIST.2T & T.DIST.RT functions in Excel 2010) |

T.DIST | Returns the Student's T-distribution (probability density or cumulative distribution function) (New in Excel 2010) |

T.DIST.2T | Returns the two-tailed Student's T-distribution (New in Excel 2010 - replaces TDIST function) |

T.DIST.RT | Returns the right-tailed Student's T-distribution (New in Excel 2010 - replaces TDIST function) |

TEXT | Converts a supplied value into text, using a user-specified format |

TIME | Returns a time, from a user-supplied hour, minute and second |

TIMEVALUE | Converts a text string showing a time, to a decimal that represents the time in Excel |

TINV | Returns the two-tailed inverse of the Student's T-distribution (Replaced by T.INV.2T function in Excel 2010) |

T.INV | Returns the left-tailed inverse of the Student's T-distribution (New in Excel 2010) |

T.INV.2T | Returns the two-tailed inverse of the Student's T-distribution (New in Excel 2010 - replaces TINV function) |

TODAY | Returns today's date |

TRANSPOSE | Performs a transpose transformation on a range of cells (ie. transforms a horizontal range of cells into a vertical range and vice versa) |

TREND | Calculates the trend line through a given set of y-values and returns additional y-values for a supplied set of new x-values |

TRIM | Removes duplicate spaces, and spaces at the start and end of a text string |

TRIMMEAN | Returns the mean of the interior of a supplied set of values |

TRUE | Simply returns the logical value TRUE |

TRUNC | Truncates a number towards zero (ie. rounds a positive number down and a negative number up), to the next integer. |

TTEST | Returns the probability associated with a Student's T-Test (Replaced by T.TEST function in Excel 2010) |

T.TEST | Returns the probability associated with a Student's T-Test (New in Excel 2010 - replaces TTEST function) |

TYPE | Returns information about the data type of a supplied value |

U | |

UNICHAR | Returns the Unicode character that is referenced by the given numeric value (New in Excel 2013) |

UNICODE | Returns the number (code point) corresponding to the first character of a supplied text string (New in Excel 2013) |

UPPER | Converts all characters in a supplied text string to upper case |

V | |

VALUE | Converts a text string into a numeric value |

VAR | Returns the variance of a supplied set of values (which represent a sample of a population) (Replaced by VAR.S function in Excel 2010) |

VARA | Returns the variance of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |

VARP | Returns the variance of a supplied set of values (which represent an entire population) (Replaced by VAR.P function in Excel 2010) |

VARPA | Returns the variance of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 |

VAR.P | Returns the variance of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces VARP function) |

VAR.S | Returns the variance of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces VAR function) |

VDB | Returns the depreciation of an asset for a specified period, (including partial periods), using the double-declining balance method or another user-specified method |

VLOOKUP | Looks up a supplied value in the first column of a table, and returns the corresponding value from another column |

W | |

WEBSERVICE | Returns data from a web service on the Internet or Intranet (New in Excel 2013) |

WEEKDAY | Returns an integer representing the day of the week for a supplied date |

WEEKNUM | Returns an integer representing the week number (from 1 to 53) of the year from a user-supplied date |

WEIBULL | Returns the Weibull distribution (Replaced by WEIBULL.DIST function in Excel 2010) |

WEIBULL.DIST | Returns the Weibull distribution (New in Excel 2010 - replaces WEIBULL function) |

WORKDAY | Returns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date |

WORKDAY.INTL | Returns 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) |

X | |

XIRR | Calculates the internal rate of return for a schedule of cash flows |

XNPV | Calculates the net present value for a schedule of cash flows |

XOR | Returns a logical Exclusive Or of all arguments (New in Excel 2013) |

Y | |

YEAR | Returns the year from a user-supplied date |

YEARFRAC | Calculates the fraction of the year represented by the number of whole days between two dates |

YIELD | Calculates the yield of a security that pays periodic interest |

YIELDDISC | Calculates the annual yield of a discounted security |

YIELDMAT | Calculates the annual yield of a security that pays interest at maturity |

Z | |

ZTEST | Returns the one-tailed probability value of a z-test (Replaced by Z.TEST function in Excel 2010) |

Z.TEST | Returns the one-tailed probability value of a z-test (New in Excel 2010 - replaces ZTEST function) |