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