# Functions and Formulas

Below is a full list of Excel functions as of 2019 sorted by category. For more information about a specific function, click on the corresponding name below.

Compatibility Functions

BETADIST function: to get the cumulative beta probability density

BETAINV function: to get the inverse of the cumulative beta probability density

BINOMDIST function: to get the individual term binomial distribution probability

CHIDIST function: to get the right-tailed probability of the chi-squared distribution

CHIINV function: to get the inverse of the right-tailed probability of the chi-squared distribution

CHITEST function: to check if hypothesized results are valid

CONCATENATE function: to combine text from different cells into one cell

CONFIDENCE function: to calculate the confidence interval for a population mean with a normal distribution

COVAR function: to calculate covariance, the average of the products of deviations for each data point pair in two data sets

CRITBINOM function: to calculate the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value

EXPONDIST function: to calculate the exponential distribution

FDIST function: to calculate the F probability distribution

FINV function: to calculate the inverse of the F probability distribution

FLOOR function: to round a number down, toward zero

FORECAST function: to calculate or predict a future value by using existing values

FTEST function: to calculate the result of an F-test

GAMMADIST function: to calculate the gamma distribution

GAMMAINV function: to calculate the inverse of the gamma cumulative distribution

HYPGEOMDIST function: the hypergeometric distribution

LOGINV function: to calculate the inverse of the lognormal cumulative distribution

LOGNORMDIST function: to calculate the cumulative lognormal distribution

MODE function: to calculate the most common value in a data set

NEGBINOMDIST function: to calculate the negative binomial distribution

NORMDIST function: to calculate the normal cumulative distribution

NORMINV function: to calculate the inverse of the normal cumulative distribution

NORMSDIST function: to calculate the standard normal cumulative distribution

NORMSINV function: to calculate the inverse of the standard normal cumulative distribution

PERCENTILE function: to calculate the k-th percentile of values in a range

PERCENTRANK function: to calculate the percentage rank of a value in a data set

POISSON function: to calculate the Poisson distribution

QUARTILE function: to calculate the quartile of a data set

RANK function: to calculate the rank of a number in a list of numbers

STDEV function: to estimate standard deviation based on a sample

STDEVP function: to calculate standard deviation based on the entire population

TDIST function: to calculate the Student’s t-distribution

TINV function: to calculate the inverse of the Student’s t-distribution

TTEST function: to calculate the probability associated with a Student’s t-test

VAR function: to estimate variance based on a sample

VARP function: to calculate variance based on the entire population

WEIBULL function: to calculate the Weibull distribution

ZTEST function: to get the one-tailed probability-value of a z-test

Cube Functions

CUBEKPIMEMBER function: to calculate a key performance indicator (KPI) property and displays the KPI name in the cell

CUBEMEMBER function: to calculate a member or tuple from the cube

CUBEMEMBERPROPERTY function: to calculate the value of a member property from the cube

CUBERANKEDMEMBER function: returns the nth, or ranked, member in a set

CUBESET function: to define a calculated set of members or tuples

CUBESETCOUNT function: to calculate the number of items in a set

CUBEVALUE function: to calculate an aggregated value from the cube

Database Functions

DAVERAGE function: to return the average of selected database entries

DCOUNT function: to count the cells that contain numbers in a database

DCOUNTA function: to count nonblank cells in a database

DGET function: to extract from a database a single record that matches the specified criteria

DMAX function: to return the maximum value from selected database entries

DMIN function: to return the minimum value from selected database entries

DPRODUCT function: to multiply the values in a particular field of records that match the criteria in a database

DSTDEV function: to estimate the standard deviation based on a sample of selected database entries

DSTDEVP function: to calculate the standard deviation based on the entire population of selected database entries

DSUM function: to add the numbers in the field column of records in the database that match the criteria

DVAR function: to estimate variance based on a sample from selected database entries

DVARP function: to calculate variance based on the entire population of selected database entries

Date and Time Functions

DATE function: to get the serial number of a particular date

DATEDIF function: to calculate the number of days, months, or years between two dates

DATEVALUE function: to converts a date in text form to a serial number

DAY function: to convert a serial number to a day of the month

DAYS function: to get the number of days between two dates

DAYS360 function: to calculate the number of days between two dates based on a 360-day year

EDATE function: to get the serial number of the date that is the indicated number of months before or after the start date

EOMONTH function: to get the serial number of the last day of the month before or after a specified number of months

HOUR function: to convert a serial number to an hour

ISOWEEKNUM function: to get the ISO week number in the year for a given date

MINUTE function: to convert a serial number to a minute

MONTH function: to convert a serial number to a month

NETWORKDAYS function: to get the number of whole workdays between two dates

NETWORKDAYS.INTL function:to get the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days

NOW function: to get the serial number of the current date and time

SECOND function: to convert a serial number to a second

TIME function: to get the serial number of a particular time

TIMEVALUE function: to convert a time in the form of text to a serial number

TODAY function: to get the serial number of today’s date

WEEKDAY function: to convert a serial number to a day of the week

WEEKNUM function: to convert a serial number to a number representing where the week falls numerically within a year

WORKDAY function: to get the serial number of the date before or after a specified number of workdays

WORKDAY.INTL function: to get 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

YEAR function: to convert a serial number to a year

YEARFRAC function: to get the year fraction representing the number of whole days between start_date and end_date

Engineering Functions

BESSELI function: to calculate the modified Bessel function

BESSELJ function: to calculate the Bessel function Jn(x)

BESSELK function: to calculate the modified Bessel function Kn(x)

BESSELY function: to calculate the Bessel function Yn(x)

BIN2DEC function: to convert a binary number to a decimal number

BIN2HEX function: to convert a binary number to a hexadecimal number

BIN2OCT function: to convert a binary number to an octal number

BITAND function: to get a ‘Bitwise And’ of two numbers

BITLSHIFT function: to get a value number shifted left by shift_amount bits

BITOR function: to get a bitwise OR of 2 numbers

BITRSHIFT function: to get a value number shifted right by shift_amount bits

BITXOR function: to get a a bitwise ‘Exclusive Or’ of two numbers

COMPLEX function: to convert real and imaginary coefficients into a complex number

CONVERT function: to convert a number from one measurement system to another

DEC2BIN function: to convert a decimal number to binary

DEC2HEX function: to convert a decimal number to hexadecimal

DEC2OCT function: to converts a decimal number to octal

DELTA function: to test whether two values are equal

ERF function: to get the error function

ERF.PRECISE function: to get the error function

ERFC function: to get the complementary error function

ERFC.PRECISE function: to get the complementary ERF function integrated between x and infinity

GESTEP function: to test whether a number is greater than a threshold value

HEX2BIN function: to convert a hexadecimal number to binary

HEX2DEC function: to convert a hexadecimal number to decimal

HEX2OCT function: to convert a hexadecimal number to octal

IMABS function: to get the absolute value (modulus) of a complex number

IMAGINARY function: to get the imaginary coefficient of a complex number

IMARGUMENT function: to get the argument theta, an angle expressed in radians

IMCONJUGATE function: to get the complex conjugate of a complex number

IMCOS function: to get the cosine of a complex number

IMCOSH function: to get the hyperbolic cosine of a complex number

IMCOT function: to get the cotangent of a complex number

IMCSC function: to get the cosecant of a complex number

IMCSCH function: to get the hyperbolic cosecant of a complex number

IMDIV function: to get the quotient of two complex numbers

IMEXP function: to get the exponential of a complex number

IMLN function: to get the natural logarithm of a complex number

IMLOG10 function: to get the base-10 logarithm of a complex number

IMLOG2 function: to get the base-2 logarithm of a complex number

IMPOWER function: to get a complex number raised to an integer power

IMPRODUCT function: to get the product of from 2 to 255 complex numbers

IMREAL function: to calculate the real coefficient of a complex number

IMSEC function: to get the secant of a complex number

IMSECH function: to get the hyperbolic secant of a complex number

IMSIN function: to calculate the sine of a complex number

IMSINH function: to calculate the hyperbolic sine of a complex number

IMSQRT function: to calculate the square root of a complex number

IMSUB function: to calculate the difference between two complex numbers

IMSUM function: to calculate the sum of complex numbers

IMTAN function: to get the tangent of a complex number

OCT2BIN function: to convert an octal number to binary

OCT2DEC function: to convert an octal number to decimal

OCT2HEX function: to convert an octal number to hexadecimal

Financial Functions

ACCRINT function: to calculate the accrued interest for a security that pays periodic interest

ACCRINTM function: to calculate the accrued interest for a security that pays interest at maturity

AMORDEGRC function: to calculate the depreciation for each accounting period by using a depreciation coefficient

AMORLINC function: to calculate the depreciation for each accounting period

COUPDAYBS function: to get the number of days from the beginning of the coupon period to the settlement date

COUPDAYS function: to get the number of days in the coupon period that contains the settlement date

COUPDAYSNC function: to get the number of days from the settlement date to the next coupon date

COUPNCD function: to get the next coupon date after the settlement date

COUPNUM function: to calculate the number of coupons payable between the settlement date and maturity date

COUPPCD function: to get the previous coupon date before the settlement date

CUMIPMT function: to calculate the cumulative interest paid between two periods

CUMPRINC function: to calculate the cumulative principal paid on a loan between two periods

DB function: to calculate the depreciation of an asset for a specified period by using the fixed-declining balance method

DDB function: to calculate the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify

DISC function: to get the discount rate for a security

DOLLARDE function: to convert a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number

DOLLARFR function: to convert a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction

DURATION function: to get the annual duration of a security with periodic interest payments

EFFECT function: to calculate the effective annual interest rate

FV function: to calculate the future value of an investment

FVSCHEDULE function: to calculate the future value of an initial principal after applying a series of compound interest rates

INTRATE function: to calculate the interest rate for a fully invested security

IPMT function: to calculate the interest payment for an investment for a given period

IRR function: to calculate the internal rate of return for a series of cash flows

ISPMT function: to calculate the interest paid during a specific period of an investment

MDURATION function: to get the Macauley modified duration for a security with an assumed par value of \$100

MIRR function: to get the internal rate of return where positive and negative cash flows are financed at different rates

NOMINAL function: to calculate the annual nominal interest rate

NPER function: to get the number of periods for an investment

NPV function: to calculate the net present value of an investment based on a series of periodic cash flows and a discount rate

ODDFPRICE function: to get the price per \$100 face value of a security with an odd first period

ODDFYIELD function: to get the yield of a security with an odd first period

ODDLPRICE function: to get the price per \$100 face value of a security with an odd last period

ODDLYIELD function: to get the yield of a security with an odd last period

PDURATION function: to calculate the number of periods required by an investment to reach a specified value

PMT function: to get the periodic payment for an annuity

PPMT function: to calculate the payment on the principal for an investment for a given period

PRICE function: to get the price per \$100 face value of a security that pays periodic interest

PRICEDISC function: to get the price per \$100 face value of a discounted security

PRICEMAT function: to get the price per \$100 face value of a security that pays interest at maturity

PV function: to calculate the present value of an investment

RATE function: to calculate the interest rate per period of an annuity

RECEIVED function: to calculate the amount received at maturity for a fully invested security

RRI function: to calculate an equivalent interest rate for the growth of an investment

SLN function: to calculate the straight-line depreciation of an asset for one period

SYD function: to calculate the sum-of-years’ digits depreciation of an asset for a specified period

TBILLEQ function: to get the bond-equivalent yield for a Treasury bill

TBILLPRICE function: to get the price per \$100 face value for a Treasury bill

TBILLYIELD function: to get the yield for a Treasury bill

VDB function: to calculate the depreciation of an asset for a specified or partial period by using a declining balance method

XIRR function: to calculate the internal rate of return for a schedule of cash flows that is not necessarily periodic

XNPV function: to get the net present value for a schedule of cash flows that is not necessarily periodic

YIELD function: to get the yield on a security that pays periodic interest

YIELDDISC function: to get the annual yield for a discounted security; for example, a Treasury bill

YIELDMAT function: to get the annual yield of a security that pays interest at maturity

Information Function

CELL function: to get information about the formatting, location, or contents of a cell

ERROR.TYPE function: returns a number corresponding to an error type

INFO function: to get information about the current operating environment

ISBLANK function: returns TRUE if the value is blank

ISERR function: returns TRUE if the value is any error value except #N/A

ISERROR function: returns TRUE if the value is any error value

ISEVEN function: returns TRUE if the number is even

ISFORMULA function: returns TRUE if there is a reference to a cell that contains a formula

ISLOGICAL function: returns TRUE if the value is a logical value

ISNA function: returns TRUE if the value is the #N/A error value

ISNONTEXT function: returns TRUE if the value is not text

ISNUMBER function: returns TRUE if the value is a number

ISODD function: returns TRUE if the number is odd

ISREF function: returns TRUE if the value is a reference

ISTEXT function: returns TRUE if the value is text

N function: returns a value converted to a number

NA function: returns the error value #N/A

SHEET function: returns the sheet number of the referenced sheet

SHEETS function: returns the number of sheets in a reference

TYPE function: returns a number indicating the data type of a value

Logical Functions

AND function: returns TRUE if all of its arguments are TRUE

FALSE function: returns the logical value FALSE

IF function: specifies a logical test to perform

IFERROR function: returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula

IFNA function: returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression

IFS function: checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

NOT function: to reverse the logic of its argument

OR function: returns TRUE if any argument is TRUE

SWITCH function: 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.

TRUE function: returns the logical value TRUE

XOR function: returns a logical exclusive OR of all arguments

Lookup and Reference Functions

ADDRESS function: returns a reference as text to a single cell in a worksheet

AREAS function: to get the number of areas in a reference

CHOOSE function: chooses a value from a list of values

COLUMN function: to get the column number of a reference

COLUMNS function: to get the number of columns in a reference

FILTER function: to filter a range of data based on criteria you define

FORMULATEXT function: returns the formula at the given reference as text

GETPIVOTDATA function: to get data stored in a PivotTable report

HLOOKUP function: looks in the top row of an array and returns the value of the indicated cell

HYPERLINK function: to create a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet

INDEX function: to use an index to choose a value from a reference or array

INDIRECT function: to get a reference indicated by a text value

LOOKUP function: to look up values in a vector or array

MATCH function: to look up values in a reference or array

OFFSET function: to get a reference offset from a given reference

ROW function: to get the row number of a reference

ROWS function: to get the number of rows in a reference

RTD function: to get real-time data from a program that supports COM automation

SINGLE function: to calculate a single value using logic known as implicit intersection. SINGLE may return a value, single cell range, or an error.

SORT function: to sort the contents of a range or array

SORTBY function: to sort the contents of a range or array based on the values in a corresponding range or array

TRANSPOSE function: to get the transpose of an array

UNIQUE function: to get a list of unique values in a list or range

VLOOKUP function: to look up in the first column of an array and move across the row to return the value of a cell

Math and trigonometry functions

ABS function: to get the absolute value of a number

ACOS function: to get the arccosine of a number

ACOSH function: to calculate the inverse hyperbolic cosine of a number

ACOT function: to calculate the arccotangent of a number

ACOTH function: to calculate the hyperbolic arccotangent of a number

AGGREGATE function: to get an aggregate in a list or database

ARABIC function: to convert a Roman number to Arabic, as a number

ASIN function: to calculate the arcsine of a number

ASINH function: to calculate the inverse hyperbolic sine of a number

ATAN function: to calculate the arctangent of a number

ATAN2 function: to calculate the arctangent from x- and y-coordinates

ATANH function: to calculate the inverse hyperbolic tangent of a number

BASE function: to convert a number into a text representation with the given radix (base)

CEILING function: to round a number to the nearest integer or to the nearest multiple of significance

CEILING.MATH function: to round a number up, to the nearest integer or to the nearest multiple of significance

CEILING.PRECISE function: to round a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.

COMBIN function: to calculate the number of combinations for a given number of objects

COMBINA function:to calculate the number of combinations with repetitions for a given number of items

COS function: to calculate the cosine of a number

COSH function: to calculate the hyperbolic cosine of a number

COT function: to get the cotangent of an angle

COTH function to get the hyperbolic cotangent of a number

CSC function: to calculate the cosecant of an angle

CSCH function: to calculate the hyperbolic cosecant of an angle

DECIMAL function: to convert a text representation of a number in a given base into a decimal number

DEGREES function: to convert radians to degrees

EVEN function: to round a number up to the nearest even integer

EXP function: to get e raised to the power of a given number

FACT function: to get the factorial of a number

FACTDOUBLE function: to get the double factorial of a number

FLOOR function: to round a number down, toward zero

FLOOR.MATH function: to round a number down, to the nearest integer or to the nearest multiple of significance

FLOOR.PRECISE function: to round a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.

GCD function: to get the greatest common divisor

INT function: to round a number down to the nearest integer

ISO.CEILING function: to get a number that is rounded up to the nearest integer or to the nearest multiple of significance

LCM function: to get the least common multiple

LN function: to calculate the natural logarithm of a number

LOG function: returns the logarithm of a number to a specified base

LOG10 function: to get the base-10 logarithm of a number

MDETERM function: to get the matrix determinant of an array

MINVERSE function: to get the matrix inverse of an array

MMULT function: to calculate the matrix product of two arrays

MOD function: to get the remainder from division

MROUND function: returns a number rounded to the desired multiple

MULTINOMIAL function: to get the multinomial of a set of numbers

MUNIT function: to get the unit matrix or the specified dimension

ODD function: to round a number up to the nearest odd integer

PI function: to get the value of pi

POWER function: to calculate the result of a number raised to a power

PRODUCT function: multiplies its arguments

QUOTIENT function: to get the integer portion of a division

RADIANS function: to converet degrees to radians

RAND function: to get a random number between 0 and 1

RANDARRAY function: to get an array of random numbers between 0 and 1

RANDBETWEEN function: to get a random number between the numbers you specify

ROMAN function: to convert an Arabic numeral to Roman, as text

ROUND function: to round a number to a specified number of digits

ROUNDDOWN function: to round a number down, toward zero

ROUNDUP function: to round a number up, away from zero

SEC function: to get the secant of an angle

SECH function: to get the hyperbolic secant of an angle

SERIESSUM function: to get the sum of a power series based on the formula

SEQUENCE function: to generate a list of sequential numbers in an array, such as 1, 2, 3, 4

SIGN function: to get the sign of a number

SIN function: to calculate the sine of the given angle

SINH function: to calculate the hyperbolic sine of a number

SQRT function: to get a positive square root

SQRTPI function: to calculate the square root of (number * pi)

SUBTOTAL function: to get a subtotal in a list or database

SUM function: adds its arguments

SUMIF function: to add the cells specified by a given criteria

SUMIFS function: to add the cells in a range that meet multiple criteria

SUMPRODUCT function: to get the sum of the products of corresponding array components

SUMSQ function: to calculate the sum of the squares of the arguments

SUMX2MY2 function: to calculate the sum of the difference of squares of corresponding values in two arrays

SUMX2PY2 function: to calculate the sum of the sum of squares of corresponding values in two arrays

SUMXMY2 function: to get the sum of squares of differences of corresponding values in two arrays

TAN function: to calculate the tangent of a number

TANH function: to calculate the hyperbolic tangent of a number

TRUNC function: to truncate a number to an integer

Statistical Functions

AVEDEV function: to calculate the average of the absolute deviations of data points from their mean

AVERAGE function: to calculate the average of its arguments

AVERAGEA function: to calculate the average of its arguments, including numbers, text, and logical values

AVERAGEIF function: to calculate the average (arithmetic mean) of all the cells in a range that meet a given criteria

AVERAGEIFS function: to calculate the average (arithmetic mean) of all cells that meet multiple criteria

BETA.DIST function: returns the beta cumulative distribution function

BETA.INV function: returns the inverse of the cumulative distribution function for a specified beta distribution

BINOM.DIST function: to calculate the individual term binomial distribution probability

BINOM.DIST.RANGE function: to calculate the probability of a trial result using a binomial distribution

BINOM.INV function: to get the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value

CHISQ.DIST function: returns the cumulative beta probability density function

CHISQ.DIST.RT function: to calculate the one-tailed probability of the chi-squared distribution

CHISQ.INV function: returns the cumulative beta probability density function

CHISQ.INV.RT function: to calculate the inverse of the one-tailed probability of the chi-squared distribution

CHISQ.TEST function: returns the test for independence

CONFIDENCE.NORM function: to get the confidence interval for a population mean

CONFIDENCE.T function: to get the confidence interval for a population mean, using a Student’s t distribution

CORREL function: to get the correlation coefficient between two data sets

COUNT function: to count how many numbers are in the list of arguments

COUNTA function: to count how many values are in the list of arguments

COUNTBLANK function: to count the number of blank cells within a range

COUNTIF function: to count the number of cells within a range that meet the given criteria

COUNTIFS function: to count the number of cells within a range that meet multiple criteria

COVARIANCE.P function: to calculate covariance, the average of the products of paired deviations

COVARIANCE.S function: to calculate the sample covariance, the average of the products deviations for each data point pair in two data sets

DEVSQ function: to get the sum of squares of deviations

EXPON.DIST function: returns the exponential distribution

F.DIST function: returns the F probability distribution

F.DIST.RT function: returns the F probability distribution

F.INV function: returns the inverse of the F probability distribution

F.INV.RT function: returns the inverse of the F probability distribution

F.TEST function: returns the result of an F-test

FISHER function: returns the Fisher transformation

FISHERINV function: returns the inverse of the Fisher transformation

FORECAST function: returns a value along a linear trend

FORECAST.ETS function: to calculate a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm

FORECAST.ETS.CONFINT function: returns a confidence interval for the forecast value at the specified target date

FORECAST.ETS.SEASONALITY function: to get the length of the repetitive pattern Excel detects for the specified time series

FORECAST.ETS.STAT function: returns a statistical value as a result of time series forecasting

FORECAST.LINEAR function: to get a future value based on existing values

FREQUENCY function: returns a frequency distribution as a vertical array

GAMMA function: to get the Gamma function value

GAMMA.DIST function: returns the gamma distribution

GAMMA.INV function: returns the inverse of the gamma cumulative distribution

GAMMALN function: to calculate the natural logarithm of the gamma function, Γ(x)

GAMMALN.PRECISE function: to calculate the natural logarithm of the gamma function, Γ(x)

GAUSS function: returns 0.5 less than the standard normal cumulative distribution

GEOMEAN function: to get the geometric mean

GROWTH function: returns values along an exponential trend

HARMEAN function: to get the harmonic mean

HYPGEOM.DIST function: returns the hypergeometric distribution

INTERCEPT function: to get the intercept of the linear regression line

KURT function: to get the kurtosis of a data set

LARGE function: to calculate the k-th largest value in a data set

LINEST function: to get the parameters of a linear trend

LOGEST function: to get the parameters of an exponential trend

LOGNORM.DIST function: returns the cumulative lognormal distribution

LOGNORM.INV function: returns the inverse of the lognormal cumulative distribution

MAX function: to get the maximum value in a list of arguments

MAXA function: to get the maximum value in a list of arguments, including numbers, text, and logical values

MAXIFS function: to get the maximum value among cells specified by a given set of conditions or criteria

MEDIAN function: to calculate the median of the given numbers

MIN function: to get the minimum value in a list of arguments

MINA function: to get the smallest value in a list of arguments, including numbers, text, and logical values

MINIFS function: to get the minimum value among cells specified by a given set of conditions or criteria.

MODE.MULT function: returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data

MODE.SNGL function: to get the most common value in a data set

NEGBINOM.DIST function: returns the negative binomial distribution

NORM.DIST function: returns the normal cumulative distribution

NORM.INV function: returns the inverse of the normal cumulative distribution

NORM.S.DIST function: returns the standard normal cumulative distribution

NORM.S.INV function: returns the inverse of the standard normal cumulative distribution

PEARSON function: to get the Pearson product moment correlation coefficient

PERCENTILE.EXC function: to calculate the k-th percentile of values in a range, where k is in the range 0..1, exclusive

PERCENTILE.INC function: to calculate the k-th percentile of values in a range

PERCENTRANK.EXC function: to get the rank of a value in a data set as a percentage (0..1, exclusive) of the data set

PERCENTRANK.INC function: to get the percentage rank of a value in a data set

PERMUT function: to get the number of permutations for a given number of objects

PERMUTATIONA function: to get the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects

PHI function: to calculate the value of the density function for a standard normal distribution

POISSON.DIST function: to get the Poisson distribution

PROB function: to calculate the probability that values in a range are between two limits

QUARTILE.EXC function: to get the quartile of the data set, based on percentile values from 0..1, exclusive

QUARTILE.INC function: to get the quartile of a data set

RANK.AVG function: to get the rank of a number in a list of numbers

RANK.EQ function: to get the rank of a number in a list of numbers

RSQ function: to calculate the square of the Pearson product moment correlation coefficient

SKEW function: returns the skewness of a distribution

SKEW.P function: returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean

SLOPE function: returns the slope of the linear regression line

SMALL function: to get the k-th smallest value in a data set

STANDARDIZE function: returns a normalized value

STDEV.P function: to calculate standard deviation based on the entire population

STDEV.S function: to estimate standard deviation based on a sample

STDEVA function: to estimate standard deviation based on a sample, including numbers, text, and logical values

STDEVPA function: to calculate standard deviation based on the entire population, including numbers, text, and logical values

STEYX function: returns the standard error of the predicted y-value for each x in the regression

T.DIST function: returns the Percentage Points (probability) for the Student t-distribution

T.DIST.2T function: returns the Percentage Points (probability) for the Student t-distribution

T.DIST.RT function: returns the Student’s t-distribution

T.INV function: returns the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom

T.INV.2T function: returns the inverse of the Student’s t-distribution

T.TEST function: returns the probability associated with a Student’s t-test

TREND function: returns values along a linear trend

TRIMMEAN function: returns the mean of the interior of a data set

VAR.P function: to calculate variance based on the entire population

VAR.S function: to estimate variance based on a sample

VARA function: to estimate variance based on a sample, including numbers, text, and logical values

VARPA function: to calculate variance based on the entire population, including numbers, text, and logical values

WEIBULL.DIST function: returns the Weibull distribution

Z.TEST function: returns the one-tailed probability-value of a z-test

Text Functions

ASC function: to change full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters

BAHTTEXT function: to convert a number to text, using the ß (baht) currency format

CHAR function: to get the character specified by the code number

CLEAN function: to remove all nonprintable characters from text

CODE function: returns a numeric code for the first character in a text string

CONCAT function: to combine the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments.

CONCATENATE function: to join several text items into one text item

DBCS function: to change half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters

DOLLAR function: to convert a number to text, using the \$ (dollar) currency format

EXACT function: to check to see if two text values are identical

FIND, FINDB functions: to find one text value within another (case-sensitive)

FIXED function: to format a number as text with a fixed number of decimals

LEFT, LEFTB functions: returns the leftmost characters from a text value

LEN, LENB functions: returns the number of characters in a text string

LOWER function: to convert text to lowercase

MID, MIDB functions: to get a specific number of characters from a text string starting at the position you specify

NUMBERVALUE function: to convert text to number in a locale-independent manner

PHONETIC function: to extract the phonetic (furigana) characters from a text string

PROPER function: to capitalize the first letter in each word of a text value

REPLACE, REPLACEB functions: to replace characters within text

REPT function: to repeat text a given number of times

RIGHT, RIGHTB functions: to return the rightmost characters from a text value

SEARCH, SEARCHB functions: to find one text value within another (not case-sensitive)

SUBSTITUTE function: to substitute new text for old text in a text string

T function: to convert its arguments to text

TEXT function: to format a number and converts it to text

TEXTJOIN function: to combine 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.

TRIM function: to remove spaces from text

UNICHAR function: returns the Unicode character that is references by the given numeric value

UNICODE function: return the number (code point) that corresponds to the first character of the text

UPPER function: to convert text to uppercase

VALUE function: to convert a text argument to a number

Web Functions

ENCODEURL function: returns a URL-encoded string

FILTERXML function: to get specific data from the XML content by using the specified XPath

WEBSERVICE function: to get data from a web service