Excel because that chathamtownfc.net 365 Excel for chathamtownfc.net 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 because that Mac Excel 2016 Excel 2016 because that Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less

Worksheet attributes are categorized by your functionality. Click a category to browser its functions. Or push Ctrl+F to discover a duty by inputting the first few letters or a descriptive word. Come get detailed information around a function, click its surname in the an initial column.

You are watching: Excel functions are organized into ____ categories.


Here are the 10 attributes that world read about most.

Function

Description

SUM function

Use this duty to add the values in cells.

IF function

Use this function to return one value if a condition is true and also another value if it"s false. Here"s a video clip about making use of the IF function.

LOOKUP role

Use this duty when you have to look in a single row or column and also find a value from the same place in a 2nd row or column.

VLOOKUP function

Use this function when you need to uncover things in a table or a variety by row. For example, look increase an employee"s last surname by her employee number, or find her call number by looking up she last surname (just prefer a phone call book). Examine out this video clip about making use of VLOOKUP.

MATCH role

Use this role to find for things in a selection of cells, and also then return the relative position of that item in the range. Because that example, if the selection A1:A3 consists of the values 5, 7, and 38, then the formula =MATCH(7,A1:A3,0) return the number 2, due to the fact that 7 is the second item in the range.

CHOOSE duty

Use this role to choose one of approximately 254 values based upon the index number. Because that example, if value1 through value7 room the days of the week, choose returns among the days as soon as a number in between 1 and also 7 is supplied as index_num.

DATE duty

Use this role to return the sequential serial number the represents a certain date. This role is most useful in situations where the year, month, and also day are provided by recipe or cell references. Because that example, you could have a worksheet that consists of dates in a format that Excel does not recognize, such as YYYYMMDD.

Use the DATEDIF duty to calculate the number of days, months, or years in between two dates.

DAYS role

Use this function to return the number of days between two dates.

FIND, FINDB features

FIND and also FINDB locate one message string in ~ a 2nd text string. They return the variety of the beginning position of the very first text string from the an initial character the the 2nd text string.

INDEX function

Use this function to return a value or the referral to a worth from within a table or range.


In Excel 2010 or later, these attributes were replaced with brand-new functions that carry out improved accuracy and also have surname that better reflect their usage. You deserve to still usage them for compatibility with previously versions of Excel, yet if backward compatibility isn"t required, you have to start making use of the brand-new functions instead. For more information about the new functions, view Statistical features (reference) and also Math and also trigonometry functions (reference) .

If you"re utilizing Excel 2007, you"ll discover these functions in the Statistical or Math & Trig categories on the Formulas tab.

Function

Description

BETADIST duty

Returns the beta cumulative circulation function

BETAINV role

Returns the train station of the accumulation distribution duty for a stated beta distribution

BINOMDIST function

Returns the separation, personal, instance term binomial circulation probability

CHIDIST function

Returns the one-tailed probability of the chi-squared distribution

CHIINV role

Returns the train station of the one-tailed probability that the chi-squared distribution

CHITEST function

Returns the test because that independence

CONCATENATE role

Joins 2 or more text strings right into one string

CONFIDENCE role

Returns the confidence interval because that a populace mean

COVAR role

Returns covariance, the average of the commodities of combine deviations

CRITBINOM duty

Returns the smallest worth for i m sorry the cumulative binomial distribution is much less than or equal to a standard value

EXPONDIST function

Returns the exponential distribution

FDIST duty

Returns the F probability distribution

FINV role

Returns the station of the F probability distribution

FLOOR duty

Rounds a number down, toward zero

FORECAST role

Calculates, or predicts, a future worth by utilizing existing values.

FTEST role

Returns the result of one F-test

GAMMADIST role

Returns the gamma distribution

GAMMAINV duty

Returns the inverse of the gamma cumulative distribution

HYPGEOMDIST duty

Returns the hypergeometric distribution

LOGINV role

Returns the inverse of the lognormal cumulative circulation function

LOGNORMDIST duty

Returns the cumulative lognormal distribution

MODE role

Returns the most usual value in a data set

NEGBINOMDIST duty

Returns the an adverse binomial distribution

NORMDIST function

Returns the common cumulative distribution

NORMINV function

Returns the train station of the regular cumulative distribution

NORMSDIST role

Returns the typical normal accumulation distribution

NORMSINV duty

Returns the station of the typical normal cumulative distribution

PERCENTILE role

Returns the k-th percentile of worths in a range

PERCENTRANK duty

Returns the percent rank that a worth in a data set

POISSON role

Returns the Poisson distribution

QUARTILE role

Returns the quartile that a data set

RANK function

Returns the rank of a number in a perform of numbers

STDEV role

Estimates conventional deviation based on a sample

STDEVP duty

Calculates conventional deviation based on the whole population

TDIST function

Returns the Student"s t-distribution

TINV duty

Returns the station of the Student"s t-distribution

TTEST duty

Returns the probability associated with a Student"s t-test

VAR duty

Estimates variance based on a sample

VARP duty

Calculates variance based upon the entire population

WEIBULL duty

Returns the Weibull distribution

ZTEST function

Returns the one-tailed probability-value that a z-test


Function

Description

CUBEKPIMEMBER role

Returns a an essential performance indicator (KPI) property and also displays the KPI surname in the cell. A KPI is a quantifiable measurement, such together monthly gross profit or quarterly employee turnover, the is supplied to monitor an organization"s performance.

CUBEMEMBER function

Returns a member or tuple native the cube. Usage to validate the the member or tuple exists in the cube.

CUBEMEMBERPROPERTY function

Returns the worth of a member property from the cube. Usage to validate the a member name exists in ~ the cube and also to return the specified building for this member.

CUBERANKEDMEMBER duty

Returns the nth, or ranked, member in a set. Use to return one or much more elements in a set, such together the optimal sales demonstrate or the top 10 students.

CUBESET role

Defines a calculated collection of members or tuples by sending a collection expression to the cube ~ above the server, which creates the set, and also then returns that set to chathamtownfc.net Office Excel.

CUBESETCOUNT role

Returns the number of items in a set.

CUBEVALUE function

Returns one aggregated worth from the cube.


Function

Description

DATE function

Returns the serial variety of a certain date

DATEDIF duty

Calculates the number of days, months, or years between two dates. This function is useful in formulas whereby you need to calculate an age.

DATEVALUE role

Converts a day in the type of message to a serial number

DAY function

Converts a serial number come a day of the month

DAYS function

Returns the variety of days in between two dates

DAYS360 function

Calculates the variety of days in between two dates based on a 360-day year

EDATE function

Returns the serial number of the date that is the indicated variety of months prior to or ~ the begin date

EOMONTH role

Returns the serial number of the critical day the the month prior to or ~ a specified variety of months

HOUR role

Converts a serial number to an hour

ISOWEEKNUM function

Returns the variety of the ISO week variety of the year because that a given date

MINUTE duty

Converts a serial number to a minute

MONTH role

Converts a serial number to a month

NETWORKDAYS duty

Returns the variety of whole workdays in between two dates

NETWORKDAYS.INTL duty

Returns the number of whole workdays in between two days using parameters to indicate which and also how plenty of days are weekend days

NOW role

Returns the serial variety of the existing date and time

SECOND role

Converts a serial number to a second

TIME function

Returns the serial number of a specific time

TIMEVALUE duty

Converts a time in the kind of message to a serial number

TODAY duty

Returns the serial number of today"s date

WEEKDAY duty

Converts a serial number to a day of the week

WEEKNUM duty

Converts a serial number to a number representing wherein the week drops numerically v a year

WORKDAY function

Returns the serial number of the date prior to or after ~ a specified variety of workdays

WORKDAY.INTL role

Returns the serial number of the date before or ~ a specified variety of workdays using parameters to indicate which and how plenty of days space weekend days

YEAR function

Converts a serial number to a year

YEARFRAC function

Returns the year fraction representing the variety of whole days in between start_date and end_date


Function

Description

BESSELI role

Returns the amendment Bessel duty In(x)

BESSELJ duty

Returns the Bessel function Jn(x)

BESSELK role

Returns the amendment Bessel function Kn(x)

BESSELY role

Returns the Bessel role Yn(x)

BIN2DEC duty

Converts a binary number to decimal

BIN2HEX duty

Converts a binary number to hexadecimal

BIN2OCT function

Converts a binary number come octal

BITAND duty

Returns a "Bitwise And" of 2 numbers

BITLSHIFT duty

Returns a value number shifted left by shift_amount bits

BITOR role

Returns a bitwise OR that 2 numbers

BITRSHIFT duty

Returns a value number shifted ideal by shift_amount bits

BITXOR function

Returns a bitwise "Exclusive Or" of two numbers

complex function

Converts real and also imaginary coefficients into a complicated number

CONVERT role

Converts a number native one measurement mechanism to another

DEC2BIN function

Converts a decimal number come binary

DEC2HEX duty

Converts a decimal number come hexadecimal

DEC2OCT role

Converts a decimal number to octal

DELTA role

Tests whether two values space equal

ERF duty

Returns the error function

ERF.PRECISE role

Returns the error function

ERFC function

Returns the security error function

ERFC.PRECISE function

Returns the security ERF function integrated in between x and infinity

GESTEP function

Tests even if it is a number is greater than a threshold value

HEX2BIN function

Converts a hexadecimal number come binary

HEX2DEC function

Converts a hexadecimal number to decimal

HEX2OCT role

Converts a hexadecimal number come octal

IMABS role

Returns the absolute worth (modulus) the a facility number

IMAGINARY function

Returns the imaginary coefficient of a facility number

IMARGUMENT role

Returns the debate theta, an angle expressed in radians

IMCONJUGATE role

Returns the facility conjugate the a complicated number

IMCOS duty

Returns the cosine of a complicated number

IMCOSH role

Returns the hyperbolic cosine of a complicated number

IMCOT role

Returns the cotangent that a complicated number

IMCSC duty

Returns the cosecant that a facility number

IMCSCH function

Returns the hyperbolic cosecant that a facility number

IMDIV duty

Returns the quotient that two complex numbers

IMEXP duty

Returns the exponential that a complicated number

IMLN role

Returns the natural logarithm of a complex number

IMLOG10 function

Returns the base-10 logarithm that a facility number

IMLOG2 function

Returns the base-2 logarithm of a complex number

IMPOWER role

Returns a complex number elevated to an creature power

IMPRODUCT role

Returns the product of native 2 to 255 complex numbers

IMREAL duty

Returns the real coefficient the a complicated number

IMSEC duty

Returns the secant the a complex number

IMSECH role

Returns the hyperbolic secant that a facility number

IMSIN duty

Returns the sine of a complicated number

IMSINH duty

Returns the hyperbolic sine the a facility number

IMSQRT function

Returns the square root of a complicated number

IMSUB function

Returns the difference between two complicated numbers

IMSUM role

Returns the sum of complex numbers

IMTAN duty

Returns the tangent that a complex number

OCT2BIN duty

Converts an octal number to binary

OCT2DEC duty

Converts an octal number come decimal

OCT2HEX function

Converts one octal number to hexadecimal


Function

Description

ACCRINT duty

Returns the accrued interest for a defense that pays routine interest

ACCRINTM duty

Returns the accrued interest for a protection that pays attention at maturity

AMORDEGRC duty

Returns the depreciation because that each accounting duration by utilizing a depreciation coefficient

AMORLINC role

Returns the depreciation for each bookkeeping period

COUPDAYBS function

Returns the variety of days from the start of the coupon duration to the settlement date

COUPDAYS duty

Returns the variety of days in the coupon period that consists of the settlement date

COUPDAYSNC role

Returns the variety of days from the settlement day to the following coupon date

COUPNCD role

Returns the following coupon date after the settlement date

COUPNUM duty

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

COUPPCD duty

Returns the vault coupon date prior to the settlement date

CUMIPMT function

Returns the cumulative interest paid in between two periods

CUMPRINC function

Returns the cumulative major paid ~ above a loan in between two periods

DB function

Returns the depreciation of one asset because that a specified duration by making use of the fixed-declining balance method

DDB duty

Returns the depreciation of one asset because that a specified period by utilizing the double-declining balance technique or part other technique that girlfriend specify

DISC duty

Returns the discount price for a security

DOLLARDE duty

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

DOLLARFR duty

Converts a dissension price, expressed as a decimal number, into a dissension price, expressed as a fraction

DURATION duty

Returns the yearly duration of a security with periodic interest payments

EFFECT role

Returns the effective yearly interest rate

FV role

Returns the future worth of an investment

FVSCHEDULE duty

Returns the future worth of an initial major after applying a collection of compound attention rates

INTRATE role

Returns the interest price for a completely invested security

IPMT role

Returns the attention payment because that an invest for a provided period

IRR function

Returns the interior rate of return for a series of cash flows

ISPMT duty

Calculates the interest paid throughout a specific duration of one investment

MDURATION function

Returns the Macauley modified duration for a defense with an suspect par worth of $100

MIRR duty

Returns the internal rate of return where confident and an unfavorable cash flows space financed at various rates

NOMINAL function

Returns the yearly nominal interest rate

NPER role

Returns the variety of periods because that an investment

NPV role

Returns the net present value of one investment based upon a collection of periodic cash flows and also a discount rate

ODDFPRICE role

Returns the price per $100 challenge value the a security with an odd very first period

ODDFYIELD duty

Returns the productivity of a security with one odd first period

ODDLPRICE duty

Returns the price every $100 face value of a protection with one odd last period

ODDLYIELD role

Returns the yield of a security with an odd critical period

PDURATION function

Returns the number of periods compelled by an invest to reach a specified value

PMT function

Returns the regular payment for an annuity

PPMT role

Returns the payment top top the primary for an investment for a provided period

PRICE duty

Returns the price every $100 challenge value that a protection that pays regular interest

PRICEDISC role

Returns the price every $100 confront value the a discounted security

PRICEMAT role

Returns the price per $100 face value the a security that pays attention at maturity

PV function

Returns the current value of one investment

RATE duty

Returns the interest price per period of one annuity

RECEIVED role

Returns the amount received at maturity because that a totally invested security

RRI function

Returns an identical interest price for the growth of one investment

SLN role

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

SYD role

Returns the sum-of-years" digits depreciation of an asset because that a mentioned period

TBILLEQ duty

Returns the bond-equivalent yield because that a Treasury bill

TBILLPRICE function

Returns the price every $100 confront value because that a Treasury bill

TBILLYIELD role

Returns the yield for a Treasury bill

VDB role

Returns the depreciation of one asset because that a specified or partial period by making use of a declining balance method

XIRR function

Returns the interior rate that return because that a schedule the cash flows the is not necessarily periodic

XNPV duty

Returns the net present value because that a schedule that cash flows that is not necessarily periodic

YIELD role

Returns the yield on a security that pays regular interest

YIELDDISC duty

Returns the annual yield for a discounted security; because that example, a Treasury bill

YIELDMAT role

Returns the annual yield the a protection that pays interest at maturity


Function

Description

CELL role

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

ERROR.TYPE role

Returns a number matching to an error type

INFO duty

Returns information around the existing operating environment

Note: This role is not obtainable in Excel because that the web.

ISBLANK duty

Returns TRUE if the worth is blank

ISERR role

Returns TRUE if the value is any error value other than #N/A

ISERROR role

Returns TRUE if the value is any type of error value

ISEVEN duty

Returns TRUE if the number is even

ISFORMULA function

Returns TRUE if over there is a recommendation to a cell that includes a formula

ISLOGICAL function

Returns TRUE if the value is a reasonable value

ISNA duty

Returns TRUE if the worth is the #N/A error value

ISNONTEXT role

Returns TRUE if the worth is no text

ISNUMBER duty

Returns TRUE if the value is a number

ISODD role

Returns TRUE if the number is odd

ISREF function

Returns TRUE if the worth is a reference

ISTEXT role

Returns TRUE if the worth is text

N role

Returns a worth converted come a number

NA duty

Returns the error value #N/A

SHEET role

Returns the sheet variety of the referenced sheet

SHEETS duty

Returns the number of sheets in a reference

form function

Returns a number describe the data kind of a value


Function

Description

AND function

Returns TRUE if every one of its debates are TRUE

FALSE role

Returns the logical worth FALSE

IF role

Specifies a logical check to perform

IFERROR function

Returns a worth you specify if a formula evaluates to an error; otherwise, returns the result of the formula

IFNA role

Returns the worth you point out if the expression resolves come #N/A, otherwise return the result of the expression

IFS duty

Checks whether one or an ext conditions room met and also returns a worth that corresponds to the very first TRUE condition.

NOT duty

Reverses the logic of that argument

OR function

Returns TRUE if any argument is TRUE

SWITCH duty

Evaluates one expression against a perform of values and returns the an outcome corresponding come the first matching value. If there is no match, an optional default value may be returned.

TRUE function

Returns the logical worth TRUE

XOR role

Returns a logical exclusive OR of all arguments


Function

Description

ADDRESS role

Returns a recommendation as text to a single cell in a worksheet

AREAS role

Returns the variety of areas in a reference

CHOOSE duty

Chooses a value from a list of values

COLUMN function

Returns the column variety of a reference

COLUMNS role

Returns the variety of columns in a reference

FILTER duty

Filters a selection of data based on criteria girlfriend define

FORMULATEXT function

Returns the formula at the offered reference as text

GETPIVOTDATA function

Returns data save in a PivotTable report

HLOOKUP function

Looks in the height row of variety and returns the worth of the shown cell

HYPERLINK duty

Creates a shortcut or jump that opens a file stored on a network server, one intranet, or the Internet

INDEX function

Uses an table of contents to pick a value from a recommendation or array

INDIRECT role

Returns a reference suggested by a text value

LOOKUP function

Looks up worths in a vector or array

MATCH function

Looks up worths in a referral or array

OFFSET duty

Returns a reference offset from a given reference

ROW duty

Returns the row variety of a reference

ROWS role

Returns the variety of rows in a reference

RTD function

Retrieves real-time data native a regime that chathamtownfc.nets COM automation

SORT function

Sorts the components of a range or array

SORTBY duty

Sorts the materials of a variety or selection based ~ above the values in a corresponding selection or array

TRANSPOSE function

Returns the transpose of an array

UNIQUE role

Returns a perform of distinctive values in a list or range

VLOOKUP role

Looks in the an initial column of range and moves across the row to return the worth of a cell

XLOOKUP duty

Searches a variety or an array, and also returns an item corresponding to the first complement it finds. If a complement doesn"t exist, then XLOOKUP deserve to return the closest (approximate) match. 

XMATCH duty

Returns the relative position of an object in range or variety of cells. 


Function

Description

ABS role

Returns the absolute worth of a number

ACOS role

Returns the arccosine that a number

ACOSH function

Returns the inverse hyperbolic cosine that a number

ACOT duty

Returns the arccotangent of a number

ACOTH function

Returns the hyperbolic arccotangent of a number

AGGREGATE duty

Returns an accumulation in a list or database

ARABIC function

Converts a roman number to Arabic, together a number

ASIN duty

Returns the arcsine of a number

ASINH function

Returns the inverse hyperbolic sine that a number

ATAN duty

Returns the arctangent the a number

ATAN2 function

Returns the arctangent indigenous x- and also y-coordinates

ATANH duty

Returns the train station hyperbolic tangent the a number

BASE duty

Converts a number right into a text representation with the offered radix (base)

CEILING function

Rounds a number come the nearest integer or to the nearest lot of of significance

CEILING.MATH role

Rounds a number up, come the nearest essence or come the nearest lot of of significance

CEILING.PRECISE duty

Rounds a number the nearest essence or come the nearest multiple of significance. Nevertheless of the authorize of the number, the number is rounded up.

COMBIN duty

Returns the variety of combinations for a given variety of objects

COMBINA function

Returns the variety of combinations through repetitions because that a given number of items

COS role

Returns the cosine the a number

COSH duty

Returns the hyperbolic cosine the a number

COT function

Returns the cotangent of an angle

COTH duty

Returns the hyperbolic cotangent of a number

CSC role

Returns the cosecant of an angle

CSCH role

Returns the hyperbolic cosecant of one angle

DECIMAL function

Converts a text representation of a number in a provided base right into a decimal number

DEGREES role

Converts radians come degrees

EVEN function

Rounds a number as much as the nearest even integer

EXP duty

Returns e elevated to the power of a given number

FACT duty

Returns the factorial of a number

FACTDOUBLE duty

Returns the dual factorial that a number

FLOOR duty

Rounds a number down, toward zero

FLOOR.MATH role

Rounds a number down, to the nearest integer or come the nearest many of significance

FLOOR.PRECISE role

Rounds a number under to the nearest creature or come the nearest many of significance. Nevertheless of the authorize of the number, the number is rounded down.

GCD duty

Returns the greatest typical divisor

INT role

Rounds a number down to the nearest integer

ISO.CEILING role

Returns a number that is rounded approximately the nearest essence or come the nearest many of significance

LCM duty

Returns the least usual multiple

LET function

Assigns names come calculation results to permit storing intermediate calculations, values, or defining names within a formula

LN function

Returns the organic logarithm the a number

LOG role

Returns the logarithm of a number to a specified base

LOG10 role

Returns the base-10 logarithm that a number

MDETERM function

Returns the matrix determinant of an array

MINVERSE function

Returns the procession inverse of one array

MMULT role

Returns the matrix product of 2 arrays

MOD duty

Returns the remainder from division

MROUND duty

Returns a number rounded come the desired multiple

MULTINOMIAL role

Returns the multinomial of a collection of numbers

MUNIT duty

Returns the unit procession or the stated dimension

ODD duty

Rounds a number approximately the nearest strange integer

PI role

Returns the worth of pi

POWER duty

Returns the an outcome of a number raised to a power

PRODUCT function

Multiplies that is arguments

QUOTIENT role

Returns the integer part of a division

RADIANS duty

Converts levels to radians

RAND role

Returns a random number between 0 and 1

RANDARRAY duty

Returns selection of arbitrarily numbers between 0 and also 1. However, you have the right to specify the number of rows and also columns to fill, minimum and maximum values, and also whether to return whole numbers or decimal values.

RANDBETWEEN function

Returns a arbitrarily number in between the numbers you specify

ROMAN role

Converts one Arabic character to Roman, together text

ROUND duty

Rounds a number come a specified number of digits

ROUNDDOWN duty

Rounds a number down, towards zero

ROUNDUP function

Rounds a number up, far from zero

SEC function

Returns the secant of an angle

SECH duty

Returns the hyperbolic secant of one angle

SERIESSUM function

Returns the sum of a power collection based top top the formula

SEQUENCE function

Generates a list of sequential numbers in an array, such together 1, 2, 3, 4

SIGN role

Returns the authorize of a number

SIN role

Returns the sine of the given angle

SINH function

Returns the hyperbolic sine that a number

SQRT function

Returns a optimistic square root

SQRTPI duty

Returns the square root of (number * pi)

SUBTOTAL duty

Returns a subtotal in a perform or database

SUM function

Adds its arguments

SUMIF function

Adds the cells mentioned by a provided criteria

SUMIFS function

Adds the cells in a range that accomplish multiple criteria

SUMPRODUCT role

Returns the sum of the products of corresponding variety components

SUMSQ function

Returns the sum of the squares the the arguments

SUMX2MY2 duty

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

SUMX2PY2 duty

Returns the amount of the sum of squares of matching values in 2 arrays

SUMXMY2 function

Returns the amount of squares of distinctions of equivalent values in 2 arrays

TAN function

Returns the tangent of a number

TANH function

Returns the hyperbolic tangent of a number

TRUNC function

Truncates a number to an integer


Function

Description

AVEDEV role

Returns the median of the absolute deviations that data points from your mean

AVERAGE duty

Returns the average of the arguments

AVERAGEA role

Returns the average of that is arguments, including numbers, text, and also logical values

AVERAGEIF role

Returns the mean (arithmetic mean) of every the cells in a variety that accomplish a offered criteria

AVERAGEIFS function

Returns the median (arithmetic mean) of every cells that fulfill multiple criteria

BETA.DIST duty

Returns the beta cumulative circulation function

BETA.INV function

Returns the train station of the accumulation distribution duty for a specified beta distribution

BINOM.DIST function

Returns the separation, personal, instance term binomial circulation probability

BINOM.DIST.RANGE role

Returns the probability that a trial an outcome using a binomial distribution

BINOM.INV function

Returns the smallest value for i m sorry the cumulative binomial circulation is less than or same to a standard value

CHISQ.DIST function

Returns the accumulation beta probability density function

CHISQ.DIST.RT duty

Returns the one-tailed probability of the chi-squared distribution

CHISQ.INV duty

Returns the accumulation beta probability density function

CHISQ.INV.RT role

Returns the train station of the one-tailed probability that the chi-squared distribution

CHISQ.TEST duty

Returns the test because that independence

CONFIDENCE.NORM role

Returns the confidence interval because that a population mean

CONFIDENCE.T function

Returns the to trust interval because that a population mean, using a Student"s t distribution

CORREL duty

Returns the correlation coefficient in between two data sets

COUNT role

Counts how numerous numbers space in the perform of arguments

COUNTA role

Counts how many values space in the list of arguments

COUNTBLANK duty

Counts the number of blank cell within a range

COUNTIF duty

Counts the variety of cells in ~ a selection that accomplish the offered criteria

COUNTIFS duty

Counts the number of cells within a selection that accomplish multiple criteria

COVARIANCE.P role

Returns covariance, the mean of the commodities of paired deviations

COVARIANCE.S role

Returns the sample covariance, the average of the commodities deviations because that each data allude pair in two data sets

DEVSQ function

Returns the sum of squares the deviations

EXPON.DIST function

Returns the exponential distribution

F.DIST role

Returns the F probability distribution

F.DIST.RT duty

Returns the F probability distribution

F.INV duty

Returns the station of the F probability distribution

F.INV.RT function

Returns the train station of the F probability distribution

F.TEST duty

Returns the result of one F-test

FISHER function

Returns the Fisher transformation

FISHERINV duty

Returns the train station of the Fisher transformation

FORECAST function

Returns a worth along a linear trend

Note: In Excel 2016, this duty is changed with FORECAST.LINEAR as part of the new Forecasting functions, yet it"s still obtainable for compatibility with previously versions.

FORECAST.ETS duty

Returns a future value based upon existing (historical) worths by utilizing the AAA variation of the Exponential Smoothing (ETS) algorithm

FORECAST.ETS.CONFINT function

Returns a to trust interval because that the estimate value in ~ the mentioned target date

FORECAST.ETS.SEASONALITY function

Returns the length of the repeated pattern Excel detects because that the stated time series

FORECAST.ETS.STAT duty

Returns a statistical value as a an outcome of time series forecasting

FORECAST.LINEAR role

Returns a future value based upon existing values

FREQUENCY duty

Returns a frequency circulation as a vertical array

GAMMA function

Returns the Gamma role value

GAMMA.DIST duty

Returns the gamma distribution

GAMMA.INV role

Returns the inverse of the gamma cumulative distribution

GAMMALN duty

Returns the natural logarithm that the gamma function, Γ(x)

GAMMALN.PRECISE duty

Returns the organic logarithm the the gamma function, Γ(x)

GAUSS duty

Returns 0.5 much less than the typical normal accumulation distribution

GEOMEAN duty

Returns the geometric mean

GROWTH role

Returns values along an exponential trend

HARMEAN role

Returns the harmonic mean

HYPGEOM.DIST role

Returns the hypergeometric distribution

INTERCEPT duty

Returns the intercept that the direct regression line

KURT duty

Returns the kurtosis the a data set

big function

Returns the k-th biggest value in a data set

LINEST role

Returns the parameters of a direct trend

LOGEST duty

Returns the parameters of an exponential trend

LOGNORM.DIST duty

Returns the cumulative lognormal distribution

LOGNORM.INV function

Returns the train station of the lognormal cumulative distribution

MAX role

Returns the maximum worth in a list of arguments

MAXA function

Returns the maximum value in a perform of arguments, consisting of numbers, text, and logical values

MAXIFS role

Returns the maximum value among cells mentioned by a given set of conditions or criteria

MEDIAN duty

Returns the average of the given numbers

MIN function

Returns the minimum worth in a list of arguments

MINA role

Returns the smallest worth in a perform of arguments, including numbers, text, and logical values

MINIFS duty

Returns the minimum value among cells mentioned by a given set of problems or criteria.

MODE.MULT duty

Returns a vertical array of the most frequently occurring, or repetitive values in an array or variety of data

MODE.SNGL function

Returns the most typical value in a data set

NEGBINOM.DIST role

Returns the negative binomial distribution

NORM.DIST duty

Returns the regular cumulative distribution

NORM.INV role

Returns the train station of the regular cumulative distribution

NORM.S.DIST role

Returns the conventional normal accumulation distribution

NORM.S.INV duty

Returns the station of the conventional normal cumulative distribution

PEARSON function

Returns the Pearson product minute correlation coefficient

PERCENTILE.EXC role

Returns the k-th percentile of values in a range, whereby k is in the range 0..1, exclusive

PERCENTILE.INC duty

Returns the k-th percentile of worths in a range

PERCENTRANK.EXC duty

Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set

PERCENTRANK.INC duty

Returns the percentage rank that a value in a data set

PERMUT function

Returns the variety of permutations for a given variety of objects

PERMUTATIONA function

Returns the variety of permutations for a given variety of objects (with repetitions) that deserve to be selected from the complete objects

PHI duty

Returns the worth of the density duty for a standard normal distribution

POISSON.DIST function

Returns the Poisson distribution

PROB duty

Returns the probability that values in a variety are between two limits

QUARTILE.EXC function

Returns the quartile of the data set, based on percentile values from 0..1, exclusive

QUARTILE.INC role

Returns the quartile the a data set

RANK.AVG duty

Returns the location of a number in a list of numbers

RANK.EQ duty

Returns the rank of a number in a list of numbers

RSQ duty

Returns the square that the Pearson product minute correlation coefficient

SKEW role

Returns the skewness the a distribution

SKEW.P role

Returns the skewness the a distribution based on a population: a characterization of the degree of asymmetry the a distribution about its mean

SLOPE duty

Returns the slope of the direct regression line

SMALL role

Returns the k-th smallest value in a data set

STANDARDIZE duty

Returns a normalized value

STDEV.P function

Calculates standard deviation based on the whole population

STDEV.S role

Estimates standard deviation based upon a sample

STDEVA function

Estimates typical deviation based upon a sample, including numbers, text, and also logical values

STDEVPA role

Calculates conventional deviation based on the entire population, including numbers, text, and also logical values

STEYX duty

Returns the typical error of the predicted y-value for each x in the regression

T.DIST function

Returns the percent Points (probability) for the student t-distribution

T.DIST.2T role

Returns the portion Points (probability) for the college student t-distribution

T.DIST.RT duty

Returns the Student"s t-distribution

T.INV role

Returns the t-value of the Student"s t-distribution together a duty of the probability and the levels of freedom

T.INV.2T function

Returns the inverse of the Student"s t-distribution

T.TEST role

Returns the probability associated with a Student"s t-test

TREND role

Returns worths along a direct trend

TRIMMEAN role

Returns the average of the interior of a data set

VAR.P duty

Calculates variance based upon the whole population

VAR.S role

Estimates variance based upon a sample

VARA function

Estimates variance based upon a sample, including numbers, text, and logical values

VARPA function

Calculates variance based upon the whole population, including numbers, text, and logical values

WEIBULL.DIST duty

Returns the Weibull distribution

Z.TEST function

Returns the one-tailed probability-value of a z-test


Function

Description

ASC role

Changes full-width (double-byte) English letter or katakana within a personality string come half-width (single-byte) characters

ARRAYTOTEXT function

Returns range of text values from any kind of specified range

BAHTTEXT function

Converts a number come text, utilizing the ß (baht) currency format

CHAR role

Returns the character stated by the password number

CLEAN role

Removes every nonprintable characters from text

CODE role

Returns a numeric code for the very first character in a message string

CONCAT role

Combines the text from multiple ranges and/or strings, however it doesn"t carry out the delimiter or IgnoreEmpty arguments.

CONCATENATE function

Joins numerous text items right into one text item

DBCS role

Changes half-width (single-byte) English letters or katakana within a personality string to full-width (double-byte) characters

DOLLAR role

Converts a number to text, making use of the $ (dollar) money format

EXACT role

Checks to view if two message values are identical

FIND, FINDB attributes

Finds one text value within an additional (case-sensitive)

FIXED role

Formats a number as text with a fixed number of decimals

LEFT, LEFTB attributes

Returns the leftmost personalities from a message value

LEN, LENB functions

Returns the number of characters in a message string

LOWER function

Converts message to lowercase

MID, MIDB attributes

Returns a specific variety of characters native a text string beginning at the position you specify

NUMBERVALUE duty

Converts text to number in a locale-independent manner

PHONETIC role

Extracts the voice (furigana) characters from a text string

PROPER role

Capitalizes the an initial letter in every word that a message value

REPLACE, REPLACEB features

Replaces personalities within text

REPT duty

Repeats text a given number of times

RIGHT, RIGHTB functions

Returns the rightmost personalities from a message value

SEARCH, SEARCHB attributes

Finds one text value within an additional (not case-sensitive)

SUBSTITUTE duty

Substitutes brand-new text for old text in a message string

T role

Converts its arguments to text

TEXT duty

Formats a number and also converts it to text

TEXTJOIN role

Combines the text from multiple arrays and/or strings, and also includes a delimiter you specify between each message value that will certainly be combined. If the delimiter is an empty message string, this role will effectively concatenate the ranges.

TRIM function

Removes spaces from text

UNICHAR duty

Returns the Unicode character that is referrals by the offered numeric value

UNICODE duty

Returns the number (code point) that coincides to the very first character of the text

UPPER duty

Converts text to uppercase

VALUE function

Converts a text argument to a number

VALUETOTEXT duty

Returns message from any kind of specified value


If add-ins the you install contain functions, this add-in or automation functions will be easily accessible in the User Defined group in the Insert Function dialog box.

See more: Why Are Biologists Concerned About Ecosystem Disruption ? Human Impact On Ecosystems Review (Article)

User-defined features (UDFs) space not accessible in Excel because that the web.

Function

Description

CALL duty

Calls a procedure in a dynamic connect library or password resource

EUROCONVERT role

Converts a number come euros, counter a number from euros to a euro member currency, or switch a number from one euro member currency to another by making use of the euro as an intermediary (triangulation)

REGISTER.ID function

Returns the it is registered ID the the stated dynamic link library (DLL) or code source that has been previously registered