Welcome to EverybodyWiki ! Nuvola apps kgpg.png Sign in or create an account to improve, watchlist or create an article like a company page or a bio (yours ?)...

List of Excel functions

From EverybodyWiki Bios & Wiki
Jump to navigation Jump to search






Excel 2016 has 484 functions. Of these, 360 existed prior to Excel 2010. Microsoft classifies these functions in 14 categories. Of the 484 functions, 386 may be called from VBA as methods of the object "WorksheetFunction" and 44 have the same names as VBA functions.

Table of Excel functions[edit]

The following table lists all functions in Excel, as of version 2016. The meanings of the columns are explained after the table.

The source of the data is, except for column "VBA", Microsoft's documentation on Excel.[1] The data in column "VBA" are from Microsoft's documentation on the VBA "WorksheetFunction" object[2] and VBA functions.[3] Documention on each of the functions and methods referred to in the table can be found at those references.

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

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

Explanation of the columns[edit]

The columns of the table have the following meanings:

  • Function(s): Name of the function. Where two functions are closely related and documented together, such as FIND and FINDB, they appear together.
  • #: Number of functions appearing together.
  • Version of Excel in which the function was introduced.
  • Type: Category to which the function(s) belong, abbreviated as follows:
Category Abbrev Count
Add-in and Automation Autom 3
Compatibility Compat 38
Cube Cube 7
Database Db 12
Date and time Time 25
Engineering Eng 54
Financial Fin 55
Information Info 20
Logical Logic 11
Lookup and reference Ref 24
Math and trigonometry Math 80
Statistical Stat 112
Text Text 33
Web Web 3
  • Description: Action performed by the function(s).
  • Note:
    1. In Excel 2007, these 32 functions were in the "Statistical" category (now "Compatibility").
    2. In Excel 2007 and Excel 2010, "FLOOR" was in the "Math and trigonometry" category (now "Compatibility").
    3. In Excel 2016, "FORECAST" was replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it's still available for compatibility with earlier versions.
    4. These five functions are not available in Excel Online.
  • VBA:
    1. M for method: Available as method of the VBA object "WorksheetFunction".
    2. F for function: VBA has its own function with the same name.

References[edit]

This article "List of Excel functions" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:List of Excel functions. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.

  1. "Excel functions (alphabetical)". Microsoft. Retrieved 4 November 2018.
  2. "WorksheetFunction Object (Excel)". Office VBA Reference. Microsoft. Retrieved 4 November 2018.
  3. "Functions (Visual Basic for Applications)". Office VBA Reference. Microsoft. Retrieved 4 November 2018.

Compte Twitter EverybodyWiki Follow us on https://twitter.com/EverybodyWiki !

Farm-Fresh comment add.png You have to Sign in or create an account to comment this article !