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