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 |