Excel函数大全

费了很大劲才整理、发表出来的，希望有参考价值。

Category

Subtype

Function

Usage

Excel Text Functions

Functions to Remove Extra Characters

CLEAN

Removes all non-printable characters from a supplied text string

Excel Text Functions

Functions to Remove Extra Characters

TRIM

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

Excel Text Functions

Functions to Convert Between Upper & Lower Case

LOWER

Converts all characters in a supplied text string to lower case

Excel Text Functions

Functions to Convert Between Upper & Lower Case

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)

Excel Text Functions

Functions to Convert Between Upper & Lower Case

UPPER

Converts all characters in a supplied text string to upper case

Excel Text Functions

Functions to Convert Excel Data Types

BAHTTEXT

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

Excel Text Functions

Functions to Convert Excel Data Types

DOLLAR

Converts a supplied number into text, using a currency format

Excel Text Functions

Functions to Convert Excel Data Types

FIXED

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

Excel Text Functions

Functions to Convert Excel Data Types

TEXT

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

Excel Text Functions

Functions to Convert Excel Data Types

VALUE

Converts a text string into a numeric value

Excel Text Functions

Functions to Convert Excel Data Types

NUMBERVALUE

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

Excel Text Functions

Converting Between Characters & Numeric Codes

CHAR

Returns the character that corresponds to a supplied numeric value

Excel Text Functions

Converting Between Characters & Numeric Codes

CODE

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

Excel Text Functions

Converting Between Characters & Numeric Codes

UNICHAR

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

Excel Text Functions

Converting Between Characters & Numeric Codes

UNICODE

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

Excel Text Functions

Functions to Convert Excel Data Types

CONCAT

Joins together two or more text strings (New in Excel 2016 (not Excel 2016 for Mac) - replaces the Concatenate function)

Excel Text Functions

Functions to Convert Excel Data Types

CONCATENATE

Joins together two or more text strings (Replaced by Concat function in Excel 2016)

Excel Text Functions

Functions to Convert Excel Data Types

LEFT

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

Excel Text Functions

Functions to Convert Excel Data Types

MID

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

Excel Text Functions

Functions to Convert Excel Data Types

RIGHT

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

Excel Text Functions

Functions to Convert Excel Data Types

REPT

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

Excel Text Functions

Functions to Convert Excel Data Types

TEXTJOIN

Joins together two or more text strings, separated by a delimiter (New in Excel 2016 - not available in Excel 2016 for Mac)

Excel Text Functions

Information Functions

LEN

Returns the length of a supplied text string

Excel Text Functions

Information Functions

FIND

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

Excel Text Functions

Information Functions

SEARCH

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

Excel Text Functions

Information Functions

EXACT

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

Excel Text Functions

Information Functions

T

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

Excel Text Functions

Replacing / Substituting Parts of a Text String

REPLACE

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

Excel Text Functions

Replacing / Substituting Parts of a Text String

SUBSTITUTE

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

Excel Logical Functions

Boolean Operator Functions

AND

Tests a number of user-defined conditions and returnsTRUE ifALL of the conditions evaluate to TRUE, orFALSE otherwise

Excel Logical Functions

Boolean Operator Functions

OR

Tests a number of user-defined conditions and returnsTRUE ifANY of the conditions evaluate to TRUE, orFALSE otherwise

Excel Logical Functions

Boolean Operator Functions

XOR

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

Excel Logical Functions

Boolean Operator Functions

NOT

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

Excel Logical Functions

Functions Returning Constant Values

TRUE

Returns the logical valueTRUE

Excel Logical Functions

Functions Returning Constant Values

FALSE

Returns the logical valueFALSE

Excel Logical Functions

Conditional Functions

IF

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

Excel Logical Functions

Conditional Functions

IFERROR

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

Excel Logical Functions

Conditional Functions

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)

Excel Logical Functions

Conditional Functions

IFS

Tests a number of supplied conditions and returns a result corresponding to the first condition that evaluates to TRUE. (New in Excel 2016 - not available in Excel 2016 for Mac)

Excel Logical Functions

Conditional Functions

SWITCH

Compares a number of supplied values to a supplied test expression and returns a result corresponding to the first value that matches the test expression. (New in Excel 2016 - not available in Excel 2016 for Mac)

Excel Information Functions

Error Information Functions

ISERROR

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

Excel Information Functions

Error Information Functions

ISERR

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

Excel Information Functions

Error Information Functions

ISNA

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

Excel Information Functions

Error Information Functions

ERROR.TYPE

Tests a supplied value and returns an integer relating to the supplied value's error type

Excel Information Functions

Numerical Information Functions

ISNUMBER

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

Excel Information Functions

Numerical Information Functions

ISEVEN

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

Excel Information Functions

Numerical Information Functions

ISODD

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

Excel Information Functions

Numerical Information Functions

N

Converts a non-number value to a number, a date to a serial number, the logical valueTRUE to 1 and all other values to 0

Excel Information Functions

Function Returning a Constant Value

NA

Returns the Excel #N/A error

Excel Information Functions

Other Data Type Functions

ISBLANK

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

Excel Information Functions

Other Data Type Functions

ISLOGICAL

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

Excel Information Functions

Other Data Type Functions

ISTEXT

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

Excel Information Functions

Other Data Type Functions

ISNONTEXT

Tests if a supplied value is text, and if it isNOT, returns TRUE; Otherwise, returns FALSE

Excel Information Functions

Other Data Type Functions

ISREF

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

Excel Information Functions

Other Data Type Functions

ISFORMULA

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

Excel Information Functions

Other Data Type Functions

TYPE

Returns information about the data type of a supplied value

Excel Information Functions

General Information Functions

CELL

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

Excel Information Functions

General Information Functions

SHEET

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

Excel Information Functions

General Information Functions

SHEETS

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

Excel Information Functions

General Information Functions

INFO

Returns information about the current operating environment

Excel Information Functions

Performing Calculations with Dates

EDATE

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

Excel Information Functions

Performing Calculations with Dates

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

Excel Information Functions

Performing Calculations with Dates

WORKDAY

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

Excel Information Functions

Performing Calculations with Dates

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)

Excel Information Functions

Performing Calculations with Dates

DAYS

Calculates the number of days between 2 dates (New in Excel 2013)

Excel Information Functions

Performing Calculations with Dates

DAYS360

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

Excel Information Functions

Performing Calculations with Dates

NETWORKDAYS

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

Excel Information Functions

Performing Calculations with 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)

Excel Information Functions

Performing Calculations with Dates

YEARFRAC

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

Excel Date and Time Functions

Creating Dates & Times

DATE

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

Excel Date and Time Functions

Creating Dates & Times

TIME

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

Excel Date and Time Functions

Creating Dates & Times

DATEVALUE

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

Excel Date and Time Functions

Creating Dates & Times

TIMEVALUE

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

Excel Date and Time Functions

Current Date & Time

NOW

Returns the current date & time

Excel Date and Time Functions

Current Date & Time

TODAY

Returns today's date

Excel Date and Time Functions

Extracting The Components of a Time

HOUR

Returns the hour part of a user-supplied time

Excel Date and Time Functions

Extracting The Components of a Time

MINUTE

Returns the minute part of a user-supplied time

Excel Date and Time Functions

Extracting The Components of a Time

SECOND

Returns the seconds part of a user-supplied time

Excel Date and Time Functions

Extracting The Components of a Date

DAY

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

Excel Date and Time Functions

Extracting The Components of a Date

MONTH

Returns the month from a user-supplied date

Excel Date and Time Functions

Extracting The Components of a Date

YEAR

Returns the year from a user-supplied date

Excel Date and Time Functions

Extracting The Components of a Date

WEEKNUM

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

Excel Date and Time Functions

Extracting The Components of a Date

ISOWEEKNUM

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

Excel Date and Time Functions

Extracting The Components of a Date

WEEKDAY

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

Excel Lookup and Reference Functions

Data Lookup Functions

HLOOKUP

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

Excel Lookup and Reference Functions

Data Lookup Functions

VLOOKUP

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

Excel Lookup and Reference Functions

Data Lookup Functions

LOOKUP

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

Excel Lookup and Reference Functions

Data Lookup Functions

GETPIVOTDATA

Extracts data stored in a Pivot Table

Excel Lookup and Reference Functions

Data Lookup Functions

CHOOSE

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

Excel Lookup and Reference Functions

Data Lookup Functions

MATCH

Finds the relative position of a value in a supplied array

Excel Lookup and Reference Functions

Row / Column / Area Information

ROW

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

Excel Lookup and Reference Functions

Row / Column / Area Information

COLUMN

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

Excel Lookup and Reference Functions

Row / Column / Area Information

ROWS

Returns the number of rows in a supplied range

Excel Lookup and Reference Functions

Row / Column / Area Information

COLUMNS

Returns the number of columns in a supplied range

Excel Lookup and Reference Functions

Row / Column / Area Information

AREAS

Returns the number of areas in a supplied range

Excel Lookup and Reference Functions

Functions To Return References to Cell Ranges

ADDRESS

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

Excel Lookup and Reference Functions

Functions To Return References to Cell Ranges

INDEX

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

Excel Lookup and Reference Functions

Functions To Return References to Cell Ranges

INDIRECT

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

Excel Lookup and Reference Functions

Functions To Return References to Cell Ranges

OFFSET

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

Excel Lookup and Reference Functions

Other

HYPERLINK

Creates a hyperlink to a document in a supplied location.

Excel Lookup and Reference Functions

Other

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)

Excel Lookup and Reference Functions

Other

RTD

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

Excel Lookup and Reference Functions

Other

FORMULATEXT

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

Excel Math and Trig Functions

Basic Numeric Information

ABS

Returns the absolute value (i.e. the modulus) of a supplied number

Excel Math and Trig Functions

Basic Numeric Information

SIGN

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

Excel Math and Trig Functions

Basic Numeric Information

GCD

Returns the Greatest Common Divisor of two or more supplied numbers

Excel Math and Trig Functions

Basic Numeric Information

LCM

Returns the Least Common Multiple of two or more supplied numbers

Excel Math and Trig Functions

Basic Mathematical Operations

SUM

Returns the sum of a supplied list of numbers

Excel Math and Trig Functions

Basic Mathematical Operations

PRODUCT

Returns the product of a supplied list of numbers

Excel Math and Trig Functions

Basic Mathematical Operations

POWER

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

Excel Math and Trig Functions

Basic Mathematical Operations

SQRT

Returns the positive square root of a given number

Excel Math and Trig Functions

Basic Mathematical Operations

QUOTIENT

Returns the integer portion of a division between two supplied numbers

Excel Math and Trig Functions

Basic Mathematical Operations

MOD

Returns the remainder from a division between two supplied numbers

Excel Math and Trig Functions

Basic Mathematical Operations

AGGREGATE

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

Excel Math and Trig Functions

Basic Mathematical Operations

SUBTOTAL

Performs a specified calculation (e.g. the sum, product, average, etc.) for a supplied set of values

Excel Math and Trig Functions

Rounding Functions

CEILING

Rounds a numberaway from zero (i.e. rounds a positive number up and a negative number down), to a multiple of significance

Excel Math and Trig Functions

Rounding Functions

CEILING.PRECISE

Rounds a numberup, regardless of the sign of the number, to a multiple of significance (New in Excel 2010)

Excel Math and Trig Functions

Rounding Functions

ISO.CEILING

Rounds a numberup, regardless of the sign of the number, to a multiple of significance. (New in Excel 2010)

Excel Math and Trig Functions

Rounding Functions

CEILING.MATH

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

Excel Math and Trig Functions

Rounding Functions

EVEN

Rounds a numberaway from zero (i.e. rounds a positive number up and a negative number down), to the next even number

Excel Math and Trig Functions

Rounding Functions

FLOOR

Rounds a numbertowards zero, (i.e. rounds a positive number down and a negative number up), to a multiple of significance

Excel Math and Trig Functions

Rounding Functions

FLOOR.PRECISE

Rounds a numberdown, regardless of the sign of the number, to a multiple of significance (New in Excel 2010)

Excel Math and Trig Functions

Rounding Functions

FLOOR.MATH

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

Excel Math and Trig Functions

Rounding Functions

INT

Rounds a numberdown to the next integer

Excel Math and Trig Functions

Rounding Functions

MROUND

Rounds a numberup or down, to the nearest multiple of significance

Excel Math and Trig Functions

Rounding Functions

ODD

Rounds a numberaway from zero (i.e. rounds a positive number up and a negative number down), to the next odd number

Excel Math and Trig Functions

Rounding Functions

ROUND

Rounds a numberup or down, to a given number of digits

Excel Math and Trig Functions

Rounding Functions

ROUNDDOWN

Rounds a numbertowards zero, (i.e. rounds a positive number down and a negative number up), to a given number of digits

Excel Math and Trig Functions

Rounding Functions

ROUNDUP

Rounds a numberaway from zero (i.e. rounds a positive number up and a negative number down), to a given number of digits

Excel Math and Trig Functions

Rounding Functions

TRUNC

Truncates a numbertowards zero (i.e. rounds a positive number down and a negative number up), to the next integer.

Excel Math and Trig Functions

Conditional Sums

SUMIF

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

Excel Math and Trig Functions

Conditional Sums

SUMIFS

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

Excel Math and Trig Functions

Advanced Mathematical Operations

SUMPRODUCT

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

Excel Math and Trig Functions

Advanced Mathematical Operations

SUMSQ

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

Excel Math and Trig Functions

Advanced Mathematical Operations

SUMX2MY2

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

Excel Math and Trig Functions

Advanced Mathematical Operations

SUMX2PY2

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

Excel Math and Trig Functions

Advanced Mathematical Operations

SUMXMY2

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

Excel Math and Trig Functions

Advanced Mathematical Operations

SERIESSUM

Returns the sum of a power series

Excel Math and Trig Functions

Trigonometry Functions

PI

Returns the constant value of pi

Excel Math and Trig Functions

Trigonometry Functions

SQRTPI

Returns the square root of a supplied number multiplied by pi

Excel Math and Trig Functions

Trigonometry Functions

DEGREES

Converts Radians to Degrees

Excel Math and Trig Functions

Trigonometry Functions

RADIANS

Converts Degrees to Radians

Excel Math and Trig Functions

Trigonometry Functions

COS

Returns the Cosine of a given angle

Excel Math and Trig Functions

Trigonometry Functions

ACOS

Returns the Arccosine of a number

Excel Math and Trig Functions

Trigonometry Functions

COSH

Returns the hyperbolic cosine of a number

Excel Math and Trig Functions

Trigonometry Functions

ACOSH

Returns the inverse hyperbolic cosine of a number

Excel Math and Trig Functions

Trigonometry Functions

SEC

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

Excel Math and Trig Functions

Trigonometry Functions

SECH

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

Excel Math and Trig Functions

Trigonometry Functions

SIN

Returns the Sine of a given angle

Excel Math and Trig Functions

Trigonometry Functions

ASIN

Returns the Arcsine of a number

Excel Math and Trig Functions

Trigonometry Functions

SINH

Returns the Hyperbolic Sine of a number

Excel Math and Trig Functions

Trigonometry Functions

ASINH

Returns the Inverse Hyperbolic Sine of a number

Excel Math and Trig Functions

Trigonometry Functions

CSC

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

Excel Math and Trig Functions

Trigonometry Functions

CSCH

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

Excel Math and Trig Functions

Trigonometry Functions

TAN

Returns the Tangent of a given angle

Excel Math and Trig Functions

Trigonometry Functions

ATAN

Returns the Arctangent of a given number

Excel Math and Trig Functions

Trigonometry Functions

ATAN2

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

Excel Math and Trig Functions

Trigonometry Functions

TANH

Returns the Hyperbolic Tangent of a given number

Excel Math and Trig Functions

Trigonometry Functions

ATANH

Returns the Inverse Hyperbolic Tangent of a given number

Excel Math and Trig Functions

Trigonometry Functions

COT

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

Excel Math and Trig Functions

Trigonometry Functions

COTH

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

Excel Math and Trig Functions

Trigonometry Functions

ACOT

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

Excel Math and Trig Functions

Trigonometry Functions

ACOTH

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

Excel Math and Trig Functions

Exponents & Logarithms

EXP

Returnse raised to a given power

Excel Math and Trig Functions

Exponents & Logarithms

LN

Returns the natural logarithm of a given number

Excel Math and Trig Functions

Exponents & Logarithms

LOG

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

Excel Math and Trig Functions

Exponents & Logarithms

LOG10

Returns the base 10 logarithm of a given number

Excel Math and Trig Functions

Matrix Functions

MDETERM

Returns the matrix determinant of a supplied array

Excel Math and Trig Functions

Matrix Functions

MINVERSE

Returns the matrix inverse of a supplied array

Excel Math and Trig Functions

Matrix Functions

MMULT

Returns the matrix product of two supplied arrays

Excel Math and Trig Functions

Matrix Functions

MUNIT

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

Excel Math and Trig Functions

Random Numbers

RAND

Returns a random number between 0 and 1

Excel Math and Trig Functions

Random Numbers

RANDBETWEEN

Returns a random number between two given integers

Excel Math and Trig Functions

Factorials

FACT

Returns the Factorial of a given number

Excel Math and Trig Functions

Factorials

FACTDOUBLE

Returns the Double Factorial of a given number

Excel Math and Trig Functions

Factorials

MULTINOMIAL

Returns the Multinomial of a given set of numbers

Excel Math and Trig Functions

Miscellaneous

BASE

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

Excel Math and Trig Functions

Miscellaneous

DECIMAL

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

Excel Math and Trig Functions

Miscellaneous

COMBIN

Returns the number of combinations (without repititions) for a given number of objects

Excel Math and Trig Functions

Miscellaneous

COMBINA

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

Excel Math and Trig Functions

Miscellaneous

ARABIC

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

Excel Math and Trig Functions

Miscellaneous

ROMAN

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

Excel Statistical Functions

Count & Frequency

COUNT

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

Excel Statistical Functions

Count & Frequency

COUNTA

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

Excel Statistical Functions

Count & Frequency

COUNTBLANK

Returns the number of blank cells in a supplied range

Excel Statistical Functions

Count & Frequency

COUNTIF

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

Excel Statistical Functions

Count & Frequency

COUNTIFS

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

Excel Statistical Functions

Count & Frequency

FREQUENCY

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

Excel Statistical Functions

Permutations

PERMUT

Returns the number of permutations for a given number of objects

Excel Statistical Functions

Permutations

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)

Excel Statistical Functions

Percentiles, Quartiles & Rank

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)

Excel Statistical Functions

Percentiles, Quartiles & Rank

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 the Percentile function)

Excel Statistical Functions

Percentiles, Quartiles & Rank

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)

Excel Statistical Functions

Percentiles, Quartiles & Rank

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)

Excel Statistical Functions

Percentiles, Quartiles & Rank

QUARTILE.INC

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

Excel Statistical Functions

Percentiles, Quartiles & Rank

QUARTILE.EXC

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

Excel Statistical Functions

Percentiles, Quartiles & Rank

RANK

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

Excel Statistical Functions

Percentiles, Quartiles & Rank

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 the Rank function)

Excel Statistical Functions

Percentiles, Quartiles & Rank

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)

Excel Statistical Functions

Percentiles, Quartiles & Rank

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)

Excel Statistical Functions

Percentiles, Quartiles & Rank

PERCENTRANK.INC

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

Excel Statistical Functions

Percentiles, Quartiles & Rank

PERCENTRANK.EXC

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

Excel Statistical Functions

Averages

AVERAGE

Returns the Average of a list of supplied numbers

Excel Statistical Functions

Averages

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

Excel Statistical Functions

Averages

AVERAGEIF

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

Excel Statistical Functions

Averages

AVERAGEIFS

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

Excel Statistical Functions

Averages

MEDIAN

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

Excel Statistical Functions

Averages

MODE

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

Excel Statistical Functions

Averages

MODE.SNGL

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

Excel Statistical Functions

Averages

MODE.MULT

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

Excel Statistical Functions

Averages

GEOMEAN

Returns the geometric mean of a set of supplied numbers

Excel Statistical Functions

Averages

HARMEAN

Returns the harmonic mean of a set of supplied numbers

Excel Statistical Functions

Averages

TRIMMEAN

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

Excel Statistical Functions

Deviation & Variance

AVEDEV

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

Excel Statistical Functions

Deviation & Variance

DEVSQ

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

Excel Statistical Functions

Deviation & Variance

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)

Excel Statistical Functions

Deviation & Variance

STDEV.S

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

Excel Statistical Functions

Deviation & Variance

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

Excel Statistical Functions

Deviation & Variance

STDEVP

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

Excel Statistical Functions

Deviation & Variance

STDEV.P

Returns the standard deviation of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces the Stdevp function)

Excel Statistical Functions

Deviation & Variance

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

Excel Statistical Functions

Deviation & Variance

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)

Excel Statistical Functions

Deviation & Variance

VAR.S

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

Excel Statistical Functions

Deviation & Variance

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

Excel Statistical Functions

Deviation & Variance

VARP

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

Excel Statistical Functions

Deviation & Variance

VAR.P

Returns the variance of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces the Varp function)

Excel Statistical Functions

Deviation & Variance

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

Excel Statistical Functions

Deviation & Variance

COVAR

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

Excel Statistical Functions

Deviation & Variance

COVARIANCE.P

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

Excel Statistical Functions

Deviation & Variance

COVARIANCE.S

Returns sample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010)

Excel Statistical Functions

Trend Line Functions

FORECAST

Predicts a future point on a linear trend line fitted to a supplied set of x- and y- values (Replaced by Forecast.Linear function in Excel 2016)

Excel Statistical Functions

Trend Line Functions

FORECAST.ETS

Uses an exponential smoothing algorithm to predict a future value on a timeline, based on a series of existing values (New in Excel 2016 - not available in Excel 2016 for Mac)

Excel Statistical Functions

Trend Line Functions

FORECAST.ETS.CONFINT

Returns a confidence interval for a forecast value at a specified target date (New in Excel 2016 - not available in Excel 2016 for Mac)

Excel Statistical Functions

Trend Line Functions

FORECAST.ETS.SEASONALITY

Returns the length of the repetitive pattern Excel detects for a specified time series (New in Excel 2016 - not available in Excel 2016 for Mac)

Excel Statistical Functions

Trend Line Functions

FORECAST.ETS.STAT

Returns a statistical value relating to a time series forecasting (New in Excel 2016 - not available in Excel 2016 for Mac)

Excel Statistical Functions

Trend Line 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 (not Excel 2016 for Mac) - replaces the Forecast function)

Excel Statistical Functions

Trend Line Functions

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

Excel Statistical Functions

Trend Line Functions

LINEST

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

Excel Statistical Functions

Trend Line Functions

SLOPE

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

Excel Statistical Functions

Trend Line Functions

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

Excel Statistical Functions

Trend Line Functions

GROWTH

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

Excel Statistical Functions

Trend Line Functions

LOGEST

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

Excel Statistical Functions

Trend Line Functions

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

Excel Statistical Functions

Finding the Largest & Smallest Values

MAX

Returns the largest value from a list of supplied numbers

Excel Statistical Functions

Finding the Largest & Smallest Values

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

Excel Statistical Functions

Finding the Largest & Smallest Values

MAXIFS

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

Excel Statistical Functions

Finding the Largest & Smallest Values

MIN

Returns the smallest value from a list of supplied numbers

Excel Statistical Functions

Finding the Largest & Smallest Values

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

Excel Statistical Functions

Finding the Largest & Smallest Values

MINIFS

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

Excel Statistical Functions

Finding the Largest & Smallest Values

LARGE

Returns the Kth LARGEST value from a list of supplied numbers, for a given value K

Excel Statistical Functions

Finding the Largest & Smallest Values

SMALL

Returns the Kth SMALLEST value from a list of supplied numbers, for a given value K

Excel Statistical Functions

Confidence Intervals

CONFIDENCE

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

Excel Statistical Functions

Confidence Intervals

CONFIDENCE.NORM

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

Excel Statistical Functions

Confidence Intervals

CONFIDENCE.T

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

Excel Statistical Functions

Distribution & Tests of Probability

BETADIST

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

Excel Statistical Functions

Distribution & Tests of Probability

BETA.DIST

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

Excel Statistical Functions

Distribution & Tests of Probability

BETAINV

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

Excel Statistical Functions

Distribution & Tests of Probability

BETA.INV

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

Excel Statistical Functions

Distribution & Tests of Probability

BINOMDIST

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

Excel Statistical Functions

Distribution & Tests of Probability

BINOM.DIST

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

Excel Statistical Functions

Distribution & Tests of Probability

BINOM.DIST.RANGE

Returns the probability of a trial result using a binomial distribution (New in Excel 2013)

Excel Statistical Functions

Distribution & Tests of Probability

NEGBINOMDIST

Returns the negative binomial distribution (Replaced by Negbinom.Dist function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

NEGBINOM.DIST

Returns the negative binomial distribution (New in Excel 2010 - replaces the Negbinomdist function)

Excel Statistical Functions

Distribution & Tests of Probability

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)

Excel Statistical Functions

Distribution & Tests of Probability

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 the Critbinom function)

Excel Statistical Functions

Distribution & Tests of Probability

CHIDIST

Returns the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Dist.Rt function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

CHISQ.DIST.RT

Returns the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chidist function)

Excel Statistical Functions

Distribution & Tests of Probability

CHISQ.DIST

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

Excel Statistical Functions

Distribution & Tests of Probability

CHIINV

Returns the inverse of the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Inv.Rt function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

CHISQ.INV.RT

Returns the inverse of the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chiinv function)

Excel Statistical Functions

Distribution & Tests of Probability

CHISQ.INV

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

Excel Statistical Functions

Distribution & Tests of Probability

CHITEST

Returns the chi-squared statistical test for independence (Replaced by Chisq.Test function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

CHISQ.TEST

Returns the chi-squared statistical test for independence (New in Excel 2010 - replaces the Chitest function)

Excel Statistical Functions

Distribution & Tests of Probability

CORREL

Returns the correlation coefficient between two sets of values

Excel Statistical Functions

Distribution & Tests of Probability

EXPONDIST

Returns the exponential distribution (Replaced by Expon.Dist function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

EXPON.DIST

Returns the exponential distribution (New in Excel 2010 - replaces the Expondist function)

Excel Statistical Functions

Distribution & Tests of Probability

FDIST

Returns the right-tailed F probability distribution for two data sets (Replaced by F.Dist.Rt function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

F.DIST.RT

Returns the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Fdist function)

Excel Statistical Functions

Distribution & Tests of Probability

F.DIST

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

Excel Statistical Functions

Distribution & Tests of Probability

FINV

Returns the inverse of the right-tailed F probability distribution for two data sets (Replaced by F.Inv.Rt function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

F.INV.RT

Returns the inverse of the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Finv function)

Excel Statistical Functions

Distribution & Tests of Probability

F.INV

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

Excel Statistical Functions

Distribution & Tests of Probability

FISHER

Returns the Fisher transformation

Excel Statistical Functions

Distribution & Tests of Probability

FISHERINV

Returns the inverse of the Fisher transformation

Excel Statistical Functions

Distribution & Tests of Probability

FTEST

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

Excel Statistical Functions

Distribution & Tests of Probability

F.TEST

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

Excel Statistical Functions

Distribution & Tests of Probability

GAMMADIST

Returns the gamma distribution (Replaced by Gamma.Dist function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

GAMMA.DIST

Returns the gamma distribution (New in Excel 2010 - replaces the Gammadist function)

Excel Statistical Functions

Distribution & Tests of Probability

GAMMAINV

Returns the inverse gamma cumulative distribution (Replaced by Gamma.Inv function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

GAMMA.INV

Returns the inverse gamma cumulative distribution (New in Excel 2010 - replaces the Gammainv function)

Excel Statistical Functions

Distribution & Tests of Probability

GAMMA

Return the gamma function value for a supplied number (New in Excel 2013)

Excel Statistical Functions

Distribution & Tests of Probability

GAMMALN

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

Excel Statistical Functions

Distribution & Tests of Probability

GAMMALN.PRECISE

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

Excel Statistical Functions

Distribution & Tests of Probability

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)

Excel Statistical Functions

Distribution & Tests of Probability

HYPGEOMDIST

Returns the hypergeometric distribution (Replaced by Hypgeom.Dist function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

HYPGEOM.DIST

Returns the hypergeometric distribution (New in Excel 2010 - replaces the Hypgeomdist function)

Excel Statistical Functions

Distribution & Tests of Probability

KURT

Returns the kurtosis of a data set

Excel Statistical Functions

Distribution & Tests of Probability

LOGNORMDIST

Returns the cumulative log-normal distribution (Replaced by Lognorm.Dist function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

LOGNORM.DIST

Returns the log-normal probability density function or the cumulative log- normal distribution (New in Excel 2010 - replaces the Lognormdist function)

Excel Statistical Functions

Distribution & Tests of Probability

LOGINV

Returns the inverse of the lognormal distribution (Replaced by Lognorm.Inv function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

LOGNORM.INV

Returns the inverse of the lognormal distribution (New in Excel 2010 - replaces the Loginv function)

Excel Statistical Functions

Distribution & Tests of Probability

NORMDIST

Returns the normal cumulative distribution (Replaced by Norm.Dist function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

NORM.DIST

Returns the normal cumulative distribution (New in Excel 2010 - replaces the Normdist function)

Excel Statistical Functions

Distribution & Tests of Probability

NORMINV

Returns the inverse of the normal cumulative distribution (Replaced by Norm.Inv function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

NORM.INV

Returns the inverse of the normal cumulative distribution (New in Excel 2010 - replaces the Norminv function)

Excel Statistical Functions

Distribution & Tests of Probability

NORMSDIST

Returns the standard normal cumulative distribution (Replaced by Norm.S.Dist function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

NORM.S.DIST

Returns the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsdist function)

Excel Statistical Functions

Distribution & Tests of Probability

NORMSINV

Returns the inverse of the standard normal cumulative distribution (Replaced by Norm.S.Inv function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

NORM.S.INV

Returns the inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsinv function)

Excel Statistical Functions

Distribution & Tests of Probability

PEARSON

Returns the Pearson product moment correlation coefficient

Excel Statistical Functions

Distribution & Tests of Probability

RSQ

Returns the square of the Pearson product moment correlation coefficient

Excel Statistical Functions

Distribution & Tests of Probability

PHI

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

Excel Statistical Functions

Distribution & Tests of Probability

POISSON

Returns the Poisson distribution (Replaced by Poisson.Dist function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

POISSON.DIST

Returns the Poisson distribution (New in Excel 2010 - replaces the Poisson function)

Excel Statistical Functions

Distribution & Tests of Probability

PROB

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

Excel Statistical Functions

Distribution & Tests of Probability

SKEW

Returns the skewness of a distribution

Excel Statistical Functions

Distribution & Tests of Probability

SKEW.P

Returns the skewness of a distribution based on a population (New in Excel 2013)

Excel Statistical Functions

Distribution & Tests of Probability

STANDARDIZE

Returns a normalized value

Excel Statistical Functions

Distribution & Tests of Probability

TDIST

Returns the Student's T-distribution (Replaced by T.Dist.2t & T.Dist.Rt functions in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

T.DIST.2T

Returns the two-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function)

Excel Statistical Functions

Distribution & Tests of Probability

T.DIST.RT

Returns the right-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function)

Excel Statistical Functions

Distribution & Tests of Probability

T.DIST

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

Excel Statistical Functions

Distribution & Tests of Probability

TINV

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

Excel Statistical Functions

Distribution & Tests of Probability

T.INV.2T

Returns the two-tailed inverse of the Student's T-distribution (New in Excel 2010 - replaces the Tinv function)

Excel Statistical Functions

Distribution & Tests of Probability

T.INV

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

Excel Statistical Functions

Distribution & Tests of Probability

TTEST

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

Excel Statistical Functions

Distribution & Tests of Probability

T.TEST

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

Excel Statistical Functions

Distribution & Tests of Probability

WEIBULL

Returns the Weibull distribution (Replaced by Weibull.Dist function in Excel 2010)

Excel Statistical Functions

Distribution & Tests of Probability

WEIBULL.DIST

Returns the Weibull distribution (New in Excel 2010 - replaces the Weibull function)

Excel Statistical Functions

Distribution & Tests of Probability

ZTEST

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

Excel Statistical Functions

Distribution & Tests of Probability

Z.TEST

Returns the one-tailed probability value of a z-test (New in Excel 2010 - replaces the Ztest function)

Excel Database Functions

Database Functions

DAVERAGE

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

Excel Database Functions

Database Functions

DCOUNT

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

Excel Database Functions

Database Functions

DCOUNTA

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

Excel Database Functions

Database Functions

DGET

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

Excel Database Functions

Database Functions

DMAX

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

Excel Database Functions

Database Functions

DMIN

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

Excel Database Functions

Database Functions

DPRODUCT

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

Excel Database Functions

Database 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

Excel Database Functions

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

Excel Database Functions

Database Functions

DSUM

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

Excel Database Functions

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

Excel Database Functions

Database Functions

DVARP

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

Excel Financial Functions

Investment Value Functions

FV

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

Excel Financial Functions

Investment Value Functions

FVSCHEDULE

Calculates the future value of an initial principal, after applying a series of compound interest rates

Excel Financial Functions

Investment Value Functions

NPV

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

Excel Financial Functions

Investment Value Functions

PV

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

Excel Financial Functions

Investment Value Functions

RECEIVED

Calculates the amount received at maturity for a fully invested Security

Excel Financial Functions

Investment Value Functions

XNPV

Calculates the net present value for a schedule of cash flows

Excel Financial Functions

Price Functions

DISC

Calculates the discount rate for a security

Excel Financial Functions

Price Functions

PRICE

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

Excel Financial Functions

Price Functions

PRICEDISC

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

Excel Financial Functions

Price Functions

PRICEMAT

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

Excel Financial Functions

Price Functions

ODDFPRICE

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

Excel Financial Functions

Price Functions

ODDLPRICE

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

Excel Financial Functions

Price Functions

TBILLPRICE

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

Excel Financial Functions

Internal Rate of Return Functions

IRR

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

Excel Financial Functions

Internal Rate of Return 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

Excel Financial Functions

Internal Rate of Return Functions

XIRR

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

Excel Financial Functions

Asset Depreciation Functions

AMORDEGRC

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

Excel Financial Functions

Asset Depreciation Functions

AMORLINC

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

Excel Financial Functions

Asset Depreciation Functions

DB

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

Excel Financial Functions

Asset Depreciation Functions

DDB

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

Excel Financial Functions

Asset Depreciation Functions

SLN

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

Excel Financial Functions

Asset Depreciation Functions

SYD

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

Excel Financial Functions

Asset Depreciation Functions

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

Excel Financial Functions

Dollar Conversion

DOLLARDE

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

Excel Financial Functions

Dollar Conversion

DOLLARFR

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

Excel Financial Functions

Payment Functions

CUMIPMT

Calculates the cumulative interest paid between two specified periods

Excel Financial Functions

Payment Functions

CUMPRINC

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

Excel Financial Functions

Payment Functions

IPMT

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

Excel Financial Functions

Payment Functions

ISPMT

Returns the interest paid during a specified period of an investment

Excel Financial Functions

Payment Functions

PMT

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

Excel Financial Functions

Payment Functions

PPMT

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

Excel Financial Functions

Interest Rate Functions

ACCRINT

Calculates the accrued interest for a security that pays periodic interest

Excel Financial Functions

Interest Rate Functions

ACCRINTM

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

Excel Financial Functions

Interest Rate Functions

EFFECT

Calculates the effective annual interest rate

Excel Financial Functions

Interest Rate Functions

INTRATE

Calculates the interest rate for a fully invested security

Excel Financial Functions

Interest Rate Functions

NOMINAL

Calculates the annual nominal interest rate

Excel Financial Functions

Interest Rate 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

Excel Financial Functions

Interest Rate Functions

RRI

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

Excel Financial Functions

Yield Functions

YIELD

Calculates the yield of a security that pays periodic interest

Excel Financial Functions

Yield Functions

YIELDDISC

Calculates the annual yield of a discounted security

Excel Financial Functions

Yield Functions

YIELDMAT

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

Excel Financial Functions

Yield Functions

ODDFYIELD

Calculates the yield of a security with an odd first period

Excel Financial Functions

Yield Functions

ODDLYIELD

Calculates the yield of a security with an odd last period

Excel Financial Functions

Yield Functions

TBILLEQ

Calculates the bond-equivalent yield for a treasury bill

Excel Financial Functions

Yield Functions

TBILLYIELD

Calculates the yield for a treasury bill

Excel Financial Functions

Duration Functions

COUPDAYBS

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

Excel Financial Functions

Duration Functions

COUPDAYS

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

Excel Financial Functions

Duration Functions

COUPDAYSNC

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

Excel Financial Functions

Duration Functions

COUPNCD

Returns the next coupon date after the settlement date

Excel Financial Functions

Duration Functions

COUPNUM

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

Excel Financial Functions

Duration Functions

COUPPCD

Returns the previous coupon date, before the settlement date

Excel Financial Functions

Duration Functions

DURATION

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

Excel Financial Functions

Duration Functions

MDURATION

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

Excel Financial Functions

Duration Functions

NPER

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

Excel Financial Functions

Duration Functions

PDURATION

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

Excel Engineering Functions

Converting Between Units of Measurement

CONVERT

Converts a number from one measurement system to another

Excel Engineering Functions

Bessel Functions

BESSELI

Calculates the modified Bessel function In(x)

Excel Engineering Functions

Bessel Functions

BESSELJ

Calculates the Bessel function Jn(x)

Excel Engineering Functions

Bessel Functions

BESSELK

Calculates the modified Bessel function Kn(x)

Excel Engineering Functions

Bessel Functions

BESSELY

Calculates the modified Bessel function Yn(x)

Excel Engineering Functions

Converting Between Bases

BIN2DEC

Converts a binary number to a decimal

Excel Engineering Functions

Converting Between Bases

BIN2HEX

Converts a binary number to hexadecimal

Excel Engineering Functions

Converting Between Bases

BIN2OCT

Converts a binary number to octal

Excel Engineering Functions

Converting Between Bases

DEC2BIN

Converts a decimal number to binary

Excel Engineering Functions

Converting Between Bases

DEC2HEX

Converts a decimal number to hexadecimal

Excel Engineering Functions

Converting Between Bases

DEC2OCT

Converts a decimal number to octal

Excel Engineering Functions

Converting Between Bases

HEX2BIN

Converts a hexadecimal number to binary

Excel Engineering Functions

Converting Between Bases

HEX2DEC

Converts a hexadecimal number to a decimal

Excel Engineering Functions

Converting Between Bases

HEX2OCT

Converts a hexadecimal number to octal

Excel Engineering Functions

Converting Between Bases

OCT2BIN

Converts octal number to binary

Excel Engineering Functions

Converting Between Bases

OCT2DEC

Converts octal number to a decimal

Excel Engineering Functions

Converting Between Bases

OCT2HEX

Converts octal number to hexadecimal

Excel Engineering Functions

The Error Function

ERF

Returns the error function integrated between two supplied limits

Excel Engineering Functions

The Error Function

ERF.PRECISE

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

Excel Engineering Functions

The Error Function

ERFC

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

Excel Engineering Functions

The Error Function

ERFC.PRECISE

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

Excel Engineering Functions

Bitwise Functions

BITAND

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

Excel Engineering Functions

Bitwise Functions

BITOR

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

Excel Engineering Functions

Bitwise Functions

BITXOR

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

Excel Engineering Functions

Bitwise Functions

BITLSHIFT

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

Excel Engineering Functions

Bitwise Functions

BITRSHIFT

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

Excel Engineering Functions

Testing Numeric Values

DELTA

Tests whether two supplied numbers are equal

Excel Engineering Functions

Testing Numeric Values

GESTEP

Tests whether a number is greater than a supplied threshold value

Excel Engineering Functions

Complex Numbers

COMPLEX

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

Excel Engineering Functions

Complex Numbers

IMABS

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

Excel Engineering Functions

Complex Numbers

IMAGINARY

Returns the imaginary coefficient of a complex number

Excel Engineering Functions

Complex Numbers

IMARGUMENT

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

Excel Engineering Functions

Complex Numbers

IMCONJUGATE

Returns the complex conjugate of a complex number

Excel Engineering Functions

Complex Numbers

IMCOS

Returns the cosine of a complex number

Excel Engineering Functions

Complex Numbers

IMCOSH

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

Excel Engineering Functions

Complex Numbers

IMCOT

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

Excel Engineering Functions

Complex Numbers

IMCSC

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

Excel Engineering Functions

Complex Numbers

IMCSCH

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

Excel Engineering Functions

Complex Numbers

IMDIV

Returns the quotient of two supplied complex numbers

Excel Engineering Functions

Complex Numbers

IMEXP

Returns the exponential of a complex number

Excel Engineering Functions

Complex Numbers

IMLN

Returns the natural logarithm of a complex number

Excel Engineering Functions

Complex Numbers

IMLOG10

Returns the base-10 logarithm of a complex number

Excel Engineering Functions

Complex Numbers

IMLOG2

Returns the base-2 logarithm of a complex number

Excel Engineering Functions

Complex Numbers

IMPOWER

Calculates a complex number raised to a supplied power

Excel Engineering Functions

Complex Numbers

IMPRODUCT

Returns the product of up to 255 supplied complex numbers

Excel Engineering Functions

Complex Numbers

IMREAL

Returns the real coefficient of a complex number

Excel Engineering Functions

Complex Numbers

IMSEC

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

Excel Engineering Functions

Complex Numbers

IMSECH

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

Excel Engineering Functions

Complex Numbers

IMSIN

Returns the sine of a complex number

Excel Engineering Functions

Complex Numbers

IMSINH

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

Excel Engineering Functions

Complex Numbers

IMSQRT

Returns the square root of a complex number

Excel Engineering Functions

Complex Numbers

IMSUB

Subtracts two complex numbers

Excel Engineering Functions

Complex Numbers

IMSUM

Calculates the sum of two complex numbers

Excel Engineering Functions

Complex Numbers

IMTAN

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

Excel Cube Functions

Cube Functions

CUBEKPIMEMBER

Returns a Key Performance Indicator (KPI) property and displays the KPI name in the cell (New in Excel 2007)

Excel Cube Functions

Cube Functions

CUBEMEMBER

Returns a member or tuple from the cube (New in Excel 2007)

Excel Cube Functions

Cube Functions

CUBEMEMBERPROPERTY

Returns the value of a member property from the cube (New in Excel 2007)

Excel Cube Functions

Cube Functions

CUBERANKEDMEMBER

Returns the nth, or ranked, member in a set (New in Excel 2007)

Excel Cube Functions

Cube 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 returns that set to Microsoft Office Excel (New in Excel 2007)

Excel Cube Functions

Cube Functions

CUBESETCOUNT

Returns the number of items in a set (New in Excel 2007)

Excel Cube Functions

Cube Functions

CUBEVALUE

Returns an aggregated value from the cube (New in Excel 2007)

Excel Web Functions

Web Functions

ENCODEURL

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

Excel Web Functions

Web Functions

FILTERXML

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

Excel Web Functions

Web Functions

WEBSERVICE

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