Click a letter to go to functions that start with it. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
AÂ Â Â BÂ Â Â CÂ Â Â DÂ Â Â EÂ Â Â FÂ Â Â GÂ Â Â HÂ Â Â IÂ Â Â JÂ Â Â KÂ Â Â LÂ Â Â MÂ Â Â
NÂ Â Â OÂ Â Â PÂ Â Â QÂ Â Â RÂ Â Â SÂ Â Â TÂ Â Â UÂ Â Â VÂ Â Â WÂ Â Â XÂ Â Â YÂ Â Â Z
Note:Â Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions.
Important:Â The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.Â
|
Function name |
Type and description |
|---|---|
|
Math and trigonometry:Â Â Â Â Returns the absolute value of a number |
|
|
Financial:Â Â Â Â Returns the accrued interest for a security that pays periodic interest |
|
|
Financial:Â Â Â Â Returns the accrued interest for a security that pays interest at maturity |
|
|
Math and trigonometry:Â Â Â Â Returns the arccosine of a number |
|
|
Math and trigonometry:Â Â Â Â Returns the inverse hyperbolic cosine of a number |
|
|
ACOT (2013)​​​​​​​ |
Math and trigonometry:Â Â Â Returns the arccotangent of a number |
|
ACOTH (2013) |
Math and trigonometry:Â Â Â Returns the hyperbolic arccotangent of a number |
|
Math and trigonometry:Â Â Â Â Returns an aggregate in a list or database |
|
|
Lookup and reference:Â Â Â Â Returns a reference as text to a single cell in a worksheet |
|
|
Financial:Â Â Â Â Returns the depreciation for each accounting period by using a depreciation coefficient |
|
|
Financial:Â Â Â Â Returns the depreciation for each accounting period |
|
|
Logical:Â Â Â Â Returns TRUE if all of its arguments are TRUE |
|
|
ARABIC (2013) |
Math and trigonometry:Â Â Â Converts a Roman number to Arabic, as a number |
|
Lookup and reference:Â Â Â Â Returns the number of areas in a reference |
|
|
ARRAYTOTEXT (2021) ​​​​​​​ |
Text:Â Â Â Returns an array of text values from any specified range |
|
Text:Â Â Â Â Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters |
|
|
Math and trigonometry:Â Â Â Â Returns the arcsine of a number |
|
|
Math and trigonometry:Â Â Â Â Returns the inverse hyperbolic sine of a number |
|
|
Math and trigonometry:Â Â Â Â Returns the arctangent of a number |
|
|
Math and trigonometry:Â Â Â Â Returns the arctangent from x- and y-coordinates |
|
|
Math and trigonometry:Â Â Â Â Returns the inverse hyperbolic tangent of a number |
|
|
Statistical:Â Â Â Â Returns the average of the absolute deviations of data points from their mean |
|
|
Statistical:Â Â Â Â Returns the average of its arguments |
|
|
Statistical:Â Â Â Â Returns the average of its arguments, including numbers, text, and logical values |
|
|
Statistical:Â Â Â Â Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria |
|
|
Statistical:Â Â Â Â Returns the average (arithmetic mean) of all cells that meet multiple criteria. |
|
|
Text:    Converts a number to text, using the ß (baht) currency format |
|
|
Math and trigonometry:Â Â Â Â Converts a number into a text representation with the given radix (base) |
|
|
Engineering:Â Â Â Â Returns the modified Bessel function In(x) |
|
|
Engineering:Â Â Â Â Returns the Bessel function Jn(x) |
|
|
Engineering:Â Â Â Â Returns the modified Bessel function Kn(x) |
|
|
Engineering:Â Â Â Â Returns the Bessel function Yn(x) |
|
|
Compatibility:Â Â Â Â Returns the beta cumulative distribution function |
|
|
BETA.DIST (2010) |
Statistical:Â Â Â Â Returns the beta cumulative distribution function |
|
Compatibility:Â Â Â Â Returns the inverse of the cumulative distribution function for a specified beta distribution |
|
|
BETA.INVn (2010) |
Statistical:Â Â Â Â Returns the inverse of the cumulative distribution function for a specified beta distribution |
|
Engineering:Â Â Â Â Converts a binary number to decimal |
|
|
Engineering:Â Â Â Â Converts a binary number to hexadecimal |
|
|
Engineering:Â Â Â Â Converts a binary number to octal |
|
|
Compatibility:Â Â Â Â Returns the individual term binomial distribution probability |
|
|
BINOM.DIST (2010) |
Statistical:Â Â Â Â Returns the individual term binomial distribution probability |
|
BINOM.DIST.RANGE (2013) |
Statistical:Â Â Â Â Returns the probability of a trial result using a binomial distribution |
|
BINOM.INV (2010) |
Statistical:Â Â Â Â Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
|
BITAND (2013) |
Engineering:Â Â Â Returns a 'Bitwise And' of two numbers |
|
BITLSHIFT (2013) |
Engineering:Â Â Â Returns a value number shifted left by shift_amount bits |
|
BITOR (2013) |
Engineering:Â Â Â Returns a bitwise OR of 2 numbers |
|
BITRSHIFT (2013) |
Engineering:Â Â Â Returns a value number shifted right by shift_amount bits |
|
BITXOR (2013) |
Engineering:Â Â Â Returns a bitwise 'Exclusive Or' of two numbers |
|
BYCOL (2024) |
Logical:    Applies a LAMBDA to each column and returns an array of the results |
|
BYROW (2024) |
Logical:    Applies a LAMBDA to each row and returns an array of the results |
|
Add-in and Automation:Â Â Â Â Calls a procedure in a dynamic link library or code resource |
|
|
Compatibility:Â Â Â Â Rounds a number to the nearest integer or to the nearest multiple of significance |
|
|
CEILING.MATH (2013) |
Math and trigonometry:Â Â Â Â Rounds a number up, to the nearest integer or to the nearest multiple of significance |
|
Math and trigonometry:Â Â Â Â Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. |
|
|
Information:Â Â Â Â Returns information about the formatting, location, or contents of a cell This function is not available in Excel for the web. |
|
|
Text:Â Â Â Â Returns the character specified by the code number |
|
|
Compatibility:Â Â Â Â Returns the one-tailed probability of the chi-squared distribution |
|
|
Compatibility:Â Â Â Â Returns the inverse of the one-tailed probability of the chi-squared distribution |
|
|
Compatibility:Â Â Â Â Returns the test for independence |
|
|
CHISQ.DIST (2010) |
Statistical:Â Â Â Â Returns the cumulative beta probability density function |
|
CHISQ.DIST.RT (2010) |
Statistical:Â Â Â Â Returns the one-tailed probability of the chi-squared distribution |
|
CHISQ.INV (2010) |
Statistical:Â Â Â Â Returns the cumulative beta probability density function |
|
CHISQ.INV.RT (2010) |
Statistical:Â Â Â Â Returns the inverse of the one-tailed probability of the chi-squared distribution |
|
CHISQ.TEST (2010) |
Statistical:Â Â Â Â Returns the test for independence |
|
Lookup and reference:Â Â Â Â Chooses a value from a list of values |
|
|
CHOOSECOLS (2024) |
Lookup and reference:Â Â Â Â Returns the specified columns from an array |
|
CHOOSEROWS (2024) |
Lookup and reference: Â Â Â Returns the specified rows from an array |
|
Text:Â Â Â Â Removes all nonprintable characters from text |
|
|
Text:Â Â Â Â Returns a numeric code for the first character in a text string |
|
|
Lookup and reference:Â Â Â Â Returns the column number of a reference |
|
|
Lookup and reference:Â Â Â Â Returns the number of columns in a reference |
|
|
Math and trigonometry:Â Â Â Â Returns the number of combinations for a given number of objects |
|
|
COMBINA (2013) |
Math and trigonometry:Â Â Â Returns the number of combinations with repetitions for a given number of items |
|
Engineering:Â Â Â Â Converts real and imaginary coefficients into a complex number |
|
|
CONCAT (2019) |
Text:Â Â Â Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. |
|
Text:Â Â Â Â Joins several text items into one text item |
|
|
Compatibility:Â Â Â Â Returns the confidence interval for a population mean |
|
|
CONFIDENCE.NORM (2010) |
Statistical:Â Â Â Â Returns the confidence interval for a population mean |
|
CONFIDENCE.T (2010) |
Statistical:Â Â Â Â Returns the confidence interval for a population mean, using a Student's t distribution |
|
Engineering:Â Â Â Â Converts a number from one measurement system to another |
|
|
COPILOT (Premium Copilot feature, Beta) |
Text:    Categorize, summarize, and generate text using Copilot |
|
Statistical:Â Â Â Â Returns the correlation coefficient between two data sets |
|
|
Math and trigonometry:Â Â Â Â Returns the cosine of a number |
|
|
Math and trigonometry:Â Â Â Â Returns the hyperbolic cosine of a number |
|
|
COT (2013) |
Math and trigonometry:Â Â Â Returns the hyperbolic cosine of a number |
|
COTH (2013) |
Math and trigonometry:Â Â Â Returns the cotangent of an angle |
|
Statistical:Â Â Â Â Counts how many numbers are in the list of arguments |
|
|
Statistical:Â Â Â Â Counts how many values are in the list of arguments |
|
|
Statistical:Â Â Â Â Counts the number of blank cells within a range |
|
|
Statistical:Â Â Â Â Counts the number of cells within a range that meet the given criteria |
|
|
Statistical:Â Â Â Â Counts the number of cells within a range that meet multiple criteria |
|
|
Financial:Â Â Â Â Returns the number of days from the beginning of the coupon period to the settlement date |
|
|
Financial:Â Â Â Â Returns the number of days in the coupon period that contains the settlement date |
|
|
Financial:Â Â Â Â Returns the number of days from the settlement date to the next coupon date |
|
|
Financial:Â Â Â Â Returns the next coupon date after the settlement date |
|
|
Financial:Â Â Â Â Returns the number of coupons payable between the settlement date and maturity date |
|
|
Financial:Â Â Â Â Returns the previous coupon date before the settlement date |
|
|
Compatibility:Â Â Â Â Returns covariance, the average of the products of paired deviations |
|
|
COVARIANCE.P (2010) |
Statistical:Â Â Â Â Returns covariance, the average of the products of paired deviations |
|
COVARIANCE.S (2010) |
Statistical:Â Â Â Â Returns the sample covariance, the average of the products deviations for each data point pair in two data sets |
|
Compatibility:Â Â Â Â Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
|
|
CSC (2013) |
Math and trigonometry:Â Â Â Returns the cosecant of an angle |
|
CSCH (2013) |
Math and trigonometry:Â Â Â Returns the hyperbolic cosecant of an angle |
|
Cube:Â Â Â Â Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance. |
|
|
Cube:Â Â Â Â Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube. |
|
|
Cube:Â Â Â Â Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member. |
|
|
Cube:Â Â Â Â Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students. |
|
|
Cube:Â Â Â Â Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel. |
|
|
Cube:Â Â Â Â Returns the number of items in a set. |
|
|
Cube:Â Â Â Â Returns an aggregated value from a cube. |
|
|
Financial:Â Â Â Â Returns the cumulative interest paid between two periods |
|
|
Financial:Â Â Â Â Returns the cumulative principal paid on a loan between two periods |
|
|
Date and time:Â Â Â Â Returns the serial number of a particular date |
|
|
Date and time:Â Â Â Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. |
|
|
Date and time:Â Â Â Â Converts a date in the form of text to a serial number |
|
|
Database:Â Â Â Â Returns the average of selected database entries |
|
|
Date and time:Â Â Â Â Converts a serial number to a day of the month |
|
|
DAYS (2013) |
Date and time:Â Â Â Returns the number of days between two dates |
|
Date and time:Â Â Â Â Calculates the number of days between two dates based on a 360-day year |
|
|
Financial:Â Â Â Â Returns the depreciation of an asset for a specified period by using the fixed-declining balance method |
|
|
DBCS (2013) |
Text:Â Â Â Â Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters |
|
Database:Â Â Â Â Counts the cells that contain numbers in a database |
|
|
Database:Â Â Â Â Counts nonblank cells in a database |
|
|
Financial:Â Â Â Â Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify |
|
|
Engineering:Â Â Â Â Converts a decimal number to binary |
|
|
Engineering:Â Â Â Â Converts a decimal number to hexadecimal |
|
|
Engineering:Â Â Â Â Converts a decimal number to octal |
|
|
DECIMAL (2013) |
Math and trigonometry:Â Â Â Converts a text representation of a number in a given base into a decimal number |
|
Math and trigonometry:Â Â Â Â Converts radians to degrees |
|
|
Engineering:Â Â Â Â Tests whether two values are equal |
|
|
DETECTLANGUAGE (Microsoft 365) |
Text:Â Â Â Â Identifies the language of a specified text |
|
Statistical:Â Â Â Â Returns the sum of squares of deviations |
|
|
Database:Â Â Â Â Extracts from a database a single record that matches the specified criteria |
|
|
Financial:Â Â Â Â Returns the discount rate for a security |
|
|
Database:Â Â Â Â Returns the maximum value from selected database entries |
|
|
Database:Â Â Â Â Returns the minimum value from selected database entries |
|
|
Text:Â Â Â Â Converts a number to text, using the $ (dollar) currency format |
|
|
Financial:Â Â Â Â Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number |
|
|
Financial:Â Â Â Â Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction |
|
|
Database:Â Â Â Â Multiplies the values in a particular field of records that match the criteria in a database |
|
|
DROP (2024) |
Lookup and reference: Â Â Â Excludes a specified number of rows or columns from the start or end of an array |
|
Database:Â Â Â Â Estimates the standard deviation based on a sample of selected database entries |
|
|
Database:Â Â Â Â Calculates the standard deviation based on the entire population of selected database entries |
|
|
Database:Â Â Â Â Adds the numbers in the field column of records in the database that match the criteria |
|
|
Financial:Â Â Â Â Returns the annual duration of a security with periodic interest payments |
|
|
Database:Â Â Â Â Estimates variance based on a sample from selected database entries |
|
|
Database:Â Â Â Â Calculates variance based on the entire population of selected database entries |
|
|
Date and time:Â Â Â Â Returns the serial number of the date that is the indicated number of months before or after the start date |
|
|
Financial:Â Â Â Â Returns the effective annual interest rate |
|
|
ENCODEURL (2013) |
Web:Â Â Â Returns a URL-encoded string This function is not available in Excel for the web. |
|
Date and time:Â Â Â Â Returns the serial number of the last day of the month before or after a specified number of months |
|
|
Engineering:Â Â Â Â Returns the error function |
|
|
ERF.PRECISE (2010) |
Engineering:Â Â Â Â Returns the error function |
|
Engineering:Â Â Â Â Returns the complementary error function |
|
|
ERFC.PRECISE (2010) |
Engineering:Â Â Â Â Returns the complementary ERF function integrated between x and infinity |
|
Information:Â Â Â Â Returns a number corresponding to an error type |
|
|
Add-in and Automation:Â Â Â Â Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation). |
|
|
Math and trigonometry:Â Â Â Â Rounds a number up to the nearest even integer |
|
|
Text:Â Â Â Â Checks to see if two text values are identical |
|
|
Math and trigonometry:Â Â Â Â Returns e raised to the power of a given number |
|
|
EXPAND (2024) |
Lookup and reference: Â Â Â Expands or pads an array to specified row and column dimensions |
|
EXPON.DIST (2010) |
Statistical:Â Â Â Â Returns the exponential distribution |
|
Compatibility:Â Â Â Â Returns the exponential distribution |
|
|
Math and trigonometry:Â Â Â Â Returns the factorial of a number |
|
|
Math and trigonometry:Â Â Â Â Returns the double factorial of a number |
|
|
Logical:Â Â Â Â Returns the logical value FALSE |
|
|
F.DIST (2010) |
Statistical:Â Â Â Â Returns the F probability distribution |
|
Compatibility:Â Â Â Â Returns the F probability distribution |
|
|
F.DIST.RT (2010) |
Statistical:Â Â Â Â Returns the F probability distribution |
|
FILTER (2021) |
Lookup and reference:Â Â Â Filters a range of data based on criteria you define |
|
FILTERXML (2013) |
Web:Â Â Â Returns specific data from the XML content by using the specified XPath This function is not available in Excel for the web. |
|
Text:Â Â Â Â Finds one text value within another (case-sensitive) |
|
|
F.INV (2010) |
Statistical:Â Â Â Â Returns the inverse of the F probability distribution |
|
F.INV.RT (2010) |
Statistical:Â Â Â Â Returns the inverse of the F probability distribution |
|
Compatibility:Â Â Â Â Returns the inverse of the F probability distribution |
|
|
Statistical:Â Â Â Â Returns the Fisher transformation |
|
|
Statistical:Â Â Â Â Returns the inverse of the Fisher transformation |
|
|
Text:Â Â Â Â Formats a number as text with a fixed number of decimals |
|
|
Compatibility:Â Â Â Â Rounds a number down, toward zero |
|
|
FLOOR.MATH (2013) |
Math and trigonometry:Â Â Â Rounds a number down, to the nearest integer or to the nearest multiple of significance |
|
Math and trigonometry:Â Â Â Â Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. |
|
|
Statistical:    Returns a value along a linear trend This function has been replaced with FORECAST.LINEAR as part of the new Forecasting, but it's still available for compatibility with earlier versions. |
|
|
FORECAST.ETS (2016) |
Statistical:Â Â Â Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm |
|
FORECAST.ETS.CONFINT (2016) |
Statistical:Â Â Â Returns a confidence interval for the forecast value at the specified target date |
|
FORECAST.ETS.SEASONALITY (2016) |
Statistical:Â Â Â Returns the length of the repetitive pattern Excel detects for the specified time series |
|
FORECAST.ETS.STAT (2016) |
Statistical:Â Â Â Returns a statistical value as a result of time series forecasting |
|
FORECAST.LINEAR (2016) |
Statistical:Â Â Â Returns a future value based on existing values |
|
FORMULATEXT (2013) |
Lookup and reference:Â Â Â Returns the formula at the given reference as text |
|
Statistical:Â Â Â Â Returns a frequency distribution as a vertical array |
|
|
F.TEST (2010) |
Statistical:Â Â Â Â Returns the result of an F-test |
|
Compatibility:Â Â Â Â Returns the result of an F-test |
|
|
Financial:Â Â Â Â Returns the future value of an investment |
|
|
Financial:Â Â Â Â Returns the future value of an initial principal after applying a series of compound interest rates |
|
|
GAMMA (2013) |
Statistical:Â Â Â Returns the Gamma function value |
|
GAMMA.DIST (2010) |
Statistical:Â Â Â Â Returns the gamma distribution |
|
Compatibility:Â Â Â Â Returns the gamma distribution |
|
|
GAMMA.INV (2010) |
Statistical:Â Â Â Â Returns the inverse of the gamma cumulative distribution |
|
Compatibility:Â Â Â Â Returns the inverse of the gamma cumulative distribution |
|
|
Statistical:    Returns the natural logarithm of the gamma function, Γ(x) |
|
|
GAMMALN.PRECISE (2010) |
Statistical:    Returns the natural logarithm of the gamma function, Γ(x) |
|
GAUSS (2013) |
Statistical:Â Â Â Â Returns 0.5 less than the standard normal cumulative distribution |
|
Math and trigonometry:Â Â Â Â Returns the greatest common divisor |
|
|
Statistical:Â Â Â Â Returns the geometric mean |
|
|
Engineering:Â Â Â Â Tests whether a number is greater than a threshold value |
|
|
Lookup and reference:Â Â Â Â Returns data stored in a PivotTable report |
|
|
GROUPBY (Microsoft 365) |
Lookup and reference:Â Â Â Â Helps a user group, aggregate, sort, and filter data based on the fields you specify |
|
Statistical:Â Â Â Â Returns values along an exponential trend |
|
|
Statistical:Â Â Â Â Returns the harmonic mean |
|
|
Engineering:Â Â Â Â Converts a hexadecimal number to binary |
|
|
Engineering:Â Â Â Â Converts a hexadecimal number to decimal |
|
|
Engineering:Â Â Â Â Converts a hexadecimal number to octal |
|
|
Lookup and reference:Â Â Â Â Looks in the top row of an array and returns the value of the indicated cell |
|
|
Date and time:Â Â Â Â Converts a serial number to an hour |
|
|
HSTACK (2024) |
Lookup and reference:    Appends arrays horizontally and in sequence to return a larger array |
|
Lookup and reference:Â Â Â Â Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet |
|
|
Statistical:Â Â Â Â Returns the hypergeometric distribution |
|
|
Compatibility:Â Â Â Â Returns the hypergeometric distribution |
|
|
Logical:Â Â Â Â Specifies a logical test to perform |
|
|
Logical:Â Â Â Â Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula |
|
|
IFNA (2013) |
Logical:Â Â Â Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression |
|
IFS (2019) |
Logical:Â Â Â Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. |
|
Engineering:Â Â Â Â Returns the absolute value (modulus) of a complex number |
|
|
IMAGE (2024) |
Lookup and reference:Â Returns an image from a given source |
|
Engineering:Â Â Â Â Returns the imaginary coefficient of a complex number |
|
|
Engineering:Â Â Â Â Returns the argument theta, an angle expressed in radians |
|
|
Engineering:Â Â Â Â Returns the complex conjugate of a complex number |
|
|
Engineering:Â Â Â Â Returns the cosine of a complex number |
|
|
IMCOSH (2013) |
Engineering:Â Â Â Â Returns the hyperbolic cosine of a complex number |
|
IMCOT (2013) |
Engineering:Â Â Â Returns the cotangent of a complex number |
|
IMCSC (2013) |
Engineering:Â Â Â Returns the cosecant of a complex number |
|
IMCSCH (2013) |
Engineering:Â Â Â Returns the hyperbolic cosecant of a complex number |
|
Engineering:Â Â Â Â Returns the quotient of two complex numbers |
|
|
Engineering:Â Â Â Â Returns the exponential of a complex number |
|
|
Engineering:Â Â Â Â Returns the natural logarithm of a complex number |
|
|
Engineering:Â Â Â Â Returns the base-10 logarithm of a complex number |
|
|
Engineering:Â Â Â Â Returns the base-2 logarithm of a complex number |
|
|
Engineering:Â Â Â Â Returns a complex number raised to an integer power |
|
|
Engineering:Â Â Â Â Returns the product of complex numbers |
|
|
Engineering:Â Â Â Â Returns the real coefficient of a complex number |
|
|
IMSEC (2013) |
Engineering:Â Â Â Returns the secant of a complex number |
|
IMSECH (2013) |
Engineering:Â Â Â Returns the hyperbolic secant of a complex number |
|
Engineering:Â Â Â Â Returns the sine of a complex number |
|
|
IMSINH (2013) |
Engineering:Â Â Â Returns the hyperbolic sine of a complex number |
|
Engineering:Â Â Â Â Returns the square root of a complex number |
|
|
Engineering:Â Â Â Â Returns the difference between two complex numbers |
|
|
Engineering:Â Â Â Â Returns the sum of complex numbers |
|
|
IMTAN (2013) |
Engineering:Â Â Â Returns the tangent of a complex number |
|
Lookup and reference:Â Â Â Â Uses an index to choose a value from a reference or array |
|
|
Lookup and reference:Â Â Â Â Returns a reference indicated by a text value |
|
|
Information:Â Â Â Â Returns information about the current operating environment This function is not available in Excel for the web. |
|
|
Math and trigonometry:Â Â Â Â Rounds a number down to the nearest integer |
|
|
Statistical:Â Â Â Â Returns the intercept of the linear regression line |
|
|
Financial:Â Â Â Â Returns the interest rate for a fully invested security |
|
|
Financial:Â Â Â Â Returns the interest payment for an investment for a given period |
|
|
Financial:Â Â Â Â Returns the internal rate of return for a series of cash flows |
|
|
Information:Â Â Â Â Returns TRUE if the value is blank |
|
|
Information:Â Â Â Â Returns TRUE if the value is any error value except #N/A |
|
|
Information:Â Â Â Â Returns TRUE if the value is any error value |
|
|
Information:Â Â Â Â Returns TRUE if the number is even |
|
|
ISFORMULA (2013) |
Information:Â Â Â Returns TRUE if there is a reference to a cell that contains a formula |
|
Information:Â Â Â Â Returns TRUE if the value is a logical value |
|
|
Information:Â Â Â Â Returns TRUE if the value is the #N/A error value |
|
|
Information:Â Â Â Â Returns TRUE if the value is not text |
|
|
Information:Â Â Â Â Returns TRUE if the value is a number |
|
|
Information:Â Â Â Â Returns TRUE if the number is odd |
|
|
ISOMITTED (2024) |
Information:    Checks whether the value in a LAMBDA is missing and returns TRUE or FALSE |
|
Information:Â Â Â Â Returns TRUE if the value is a reference |
|
|
Information:Â Â Â Â Returns TRUE if the value is text |
|
|
ISO.CEILING (2013) |
Math and trigonometry:Â Â Â Â Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance |
|
ISOWEEKNUM (2013) |
Date and time:Â Â Â Returns the number of the ISO week number of the year for a given date |
|
Financial:Â Â Â Â Calculates the interest paid during a specific period of an investment |
|
|
Text:Â Â Â Â Changes half-width (single-byte) characters within a string to full-width (double-byte) characters |
|
|
Statistical:Â Â Â Â Returns the kurtosis of a data set |
|
|
LAMBDA (2024) |
Logical: Â Â Â Create custom, reusable and call them by a friendly name |
|
Statistical:Â Â Â Â Returns the k-th largest value in a data set |
|
|
Math and trigonometry:Â Â Â Â Returns the least common multiple |
|
|
Text:Â Â Â Â Returns the leftmost characters from a text value |
|
|
Text:Â Â Â Â Returns the number of characters in a text string |
|
|
LET (2021) |
Logical: Â Â Â Assigns names to calculation results |
|
Statistical:Â Â Â Â Returns the parameters of a linear trend |
|
|
Math and trigonometry:Â Â Â Â Returns the natural logarithm of a number |
|
|
Math and trigonometry:Â Â Â Â Returns the logarithm of a number to a specified base |
|
|
Math and trigonometry:Â Â Â Â Returns the base-10 logarithm of a number |
|
|
Statistical:Â Â Â Â Returns the parameters of an exponential trend |
|
|
Compatibility:Â Â Â Â Returns the inverse of the lognormal cumulative distribution |
|
|
LOGNORM.DIST (2010) |
Statistical:Â Â Â Â Returns the cumulative lognormal distribution |
|
Compatibility:Â Â Â Â Returns the cumulative lognormal distribution |
|
|
LOGNORM.INV (2010) |
Statistical:Â Â Â Â Returns the inverse of the lognormal cumulative distribution |
|
Lookup and reference:Â Â Â Â Looks up values in a vector or array |
|
|
Text:Â Â Â Â Converts text to lowercase |
|
|
MAKEARRAY (2024) |
Logical:    Returns a calculated array of a specified row and column size, by applying a LAMBDA |
|
MAP (2024) |
Logical:    Returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value |
|
Lookup and reference:Â Â Â Â Looks up values in a reference or array |
|
|
Statistical:Â Â Â Â Returns the maximum value in a list of arguments |
|
|
Statistical:Â Â Â Â Returns the maximum value in a list of arguments, including numbers, text, and logical values |
|
|
MAXIFS (2019) |
Statistical:Â Â Â Returns the maximum value among cells specified by a given set of conditions or criteria |
|
Math and trigonometry:Â Â Â Â Returns the matrix determinant of an array |
|
|
Financial:Â Â Â Â Returns the Macauley modified duration for a security with an assumed par value of $100 |
|
|
Statistical:Â Â Â Â Returns the median of the given numbers |
|
|
Text:Â Â Â Â Returns a specific number of characters from a text string starting at the position you specify |
|
|
Statistical:Â Â Â Â Returns the minimum value in a list of arguments |
|
|
MINIFS (2019) |
Statistical:Â Â Â Returns the minimum value among cells specified by a given set of conditions or criteria. |
|
Statistical:Â Â Â Â Returns the smallest value in a list of arguments, including numbers, text, and logical values |
|
|
Date and time:Â Â Â Â Converts a serial number to a minute |
|
|
Math and trigonometry:Â Â Â Â Returns the matrix inverse of an array |
|
|
Financial:Â Â Â Â Returns the internal rate of return where positive and negative cash flows are financed at different rates |
|
|
Math and trigonometry:Â Â Â Â Returns the matrix product of two arrays |
|
|
Math and trigonometry:Â Â Â Â Returns the remainder from division |
|
|
Compatibility:Â Â Â Â Returns the most common value in a data set |
|
|
MODE.MULT (2010) |
Statistical:Â Â Â Â Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data |
|
MODE.SNGL (2010) |
Statistical:Â Â Â Â Returns the most common value in a data set |
|
Date and time:Â Â Â Â Converts a serial number to a month |
|
|
Math and trigonometry:Â Â Â Â Returns a number rounded to the desired multiple |
|
|
Math and trigonometry:Â Â Â Â Returns the multinomial of a set of numbers |
|
|
MUNIT (2013) |
Math and trigonometry:Â Â Â Returns the unit matrix or the specified dimension |
|
Information:Â Â Â Â Returns a value converted to a number |
|
|
Information:Â Â Â Â Returns the error value #N/A |
|
|
NEGBINOM.DIST (2010) |
Statistical:Â Â Â Â Returns the negative binomial distribution |
|
Compatibility:Â Â Â Â Returns the negative binomial distribution |
|
|
Date and time:Â Â Â Â Returns the number of whole workdays between two dates |
|
|
NETWORKDAYS.INTL (2010) |
Date and time:Â Â Â Â Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days |
|
Financial:Â Â Â Â Returns the annual nominal interest rate |
|
|
NORM.DIST (2010) |
Statistical:Â Â Â Â Returns the normal cumulative distribution |
|
Compatibility:Â Â Â Â Returns the normal cumulative distribution |
|
|
Statistical:Â Â Â Â Returns the inverse of the normal cumulative distribution |
|
|
NORM.INV (2010) |
Compatibility:Â Â Â Â Returns the inverse of the normal cumulative distribution |
|
NORM.S.DIST (2010) |
Statistical:Â Â Â Â Returns the standard normal cumulative distribution |
|
Compatibility:Â Â Â Â Returns the standard normal cumulative distribution |
|
|
NORM.S.INV (2010) |
Statistical:Â Â Â Â Returns the inverse of the standard normal cumulative distribution |
|
Compatibility:Â Â Â Â Returns the inverse of the standard normal cumulative distribution |
|
|
Logical:Â Â Â Â Reverses the logic of its argument |
|
|
Date and time:Â Â Â Â Returns the serial number of the current date and time |
|
|
Financial:Â Â Â Â Returns the number of periods for an investment |
|
|
Financial:Â Â Â Â Returns the net present value of an investment based on a series of periodic cash flows and a discount rate |
|
|
NUMBERVALUE (2013) |
Text:Â Â Â Â Converts text to number in a locale-independent manner |
|
Engineering:Â Â Â Â Converts an octal number to binary |
|
|
Engineering:Â Â Â Â Converts an octal number to decimal |
|
|
Engineering:Â Â Â Â Converts an octal number to hexadecimal |
|
|
Math and trigonometry:Â Â Â Â Rounds a number up to the nearest odd integer |
|
|
Financial:Â Â Â Â Returns the price per $100 face value of a security with an odd first period |
|
|
Financial:Â Â Â Â Returns the yield of a security with an odd first period |
|
|
Financial:Â Â Â Â Returns the price per $100 face value of a security with an odd last period |
|
|
Financial:Â Â Â Â Returns the yield of a security with an odd last period |
|
|
Lookup and reference:Â Â Â Â Returns a reference offset from a given reference |
|
|
Logical:Â Â Â Â Returns TRUE if any argument is TRUE |
|
|
PDURATION (2013) |
Financial:Â Â Â Returns the number of periods required by an investment to reach a specified value |
|
Statistical:Â Â Â Â Returns the Pearson product moment correlation coefficient |
|
|
PERCENTILE.EXC (2010) |
Statistical:Â Â Â Â Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive |
|
PERCENTILE.INC (2010) |
Statistical:Â Â Â Â Returns the k-th percentile of values in a range |
|
Compatibility:Â Â Â Â Returns the k-th percentile of values in a range |
|
|
PERCENTOF (Microsoft 365)​​​​​​​ |
Math and trigonometry:Â Â Â Â Sums the values in the subset and divides it by all the values |
|
PERCENTRANK.EXC (2010) |
Statistical:Â Â Â Â Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set |
|
PERCENTRANK.INC (2010) |
Statistical:Â Â Â Â Returns the percentage rank of a value in a data set |
|
Compatibility:Â Â Â Â Returns the percentage rank of a value in a data set |
|
|
Statistical:Â Â Â Â Returns the number of permutations for a given number of objects |
|
|
PERMUTATIONA (2013) |
Statistical:Â Â Â Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects |
|
PHI (2013) |
Statistical:Â Â Â Returns the value of the density function for a standard normal distribution |
|
Text:Â Â Â Â Extracts the phonetic (furigana) characters from a text string |
|
|
Math and trigonometry:Â Â Â Â Returns the value of pi |
|
|
PIVOTBY (Microsoft 365) |
Lookup and reference:Â Â Â Â Helps a user group, aggregate, sort, and filter data based on the row and column fields that you specify |
|
Financial:Â Â Â Â Returns the periodic payment for an annuity |
|
|
POISSON.DIST (2010) |
Statistical:Â Â Â Â Returns the Poisson distribution |
|
Compatibility:Â Â Â Â Returns the Poisson distribution |
|
|
Math and trigonometry:Â Â Â Â Returns the result of a number raised to a power |
|
|
Financial:Â Â Â Â Returns the payment on the principal for an investment for a given period |
|
|
Financial:Â Â Â Â Returns the price per $100 face value of a security that pays periodic interest |
|
|
Financial:Â Â Â Â Returns the price per $100 face value of a discounted security |
|
|
Financial:Â Â Â Â Returns the price per $100 face value of a security that pays interest at maturity |
|
|
Statistical:Â Â Â Â Returns the probability that values in a range are between two limits |
|
|
Math and trigonometry:Â Â Â Â Multiplies its arguments |
|
|
Text:Â Â Â Â Capitalizes the first letter in each word of a text value |
|
|
Financial:Â Â Â Â Returns the present value of an investment |
|
|
Compatibility:Â Â Â Â Returns the quartile of a data set |
|
|
QUARTILE.EXC (2010) |
Statistical:Â Â Â Â Returns the quartile of the data set, based on percentile values from 0..1, exclusive |
|
QUARTILE.INC (2010) |
Statistical:Â Â Â Â Returns the quartile of a data set |
|
Math and trigonometry:Â Â Â Â Returns the integer portion of a division |
|
|
Math and trigonometry:Â Â Â Â Converts degrees to radians |
|
|
Math and trigonometry:Â Â Â Â Returns a random number between 0 and 1 |
|
|
RANDARRAY (2021) |
Math and trigonometry:Â Â Â Â Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values. |
|
Math and trigonometry:Â Â Â Â Returns a random number between the numbers you specify |
|
|
RANK.AVG (2010) |
Statistical:Â Â Â Â Returns the rank of a number in a list of numbers |
|
RANK.EQ (2010) |
Statistical:Â Â Â Â Returns the rank of a number in a list of numbers |
|
Compatibility:Â Â Â Â Returns the rank of a number in a list of numbers |
|
|
Financial:Â Â Â Â Returns the interest rate per period of an annuity |
|
|
Financial:Â Â Â Â Returns the amount received at maturity for a fully invested security |
|
|
REDUCE (2024) |
Logical:    Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator |
|
REGEXEXTRACT (Microsoft 365) |
Text:Â Â Â Â Extracts strings within the provided text that matches the pattern |
|
REGEXREPLACE (Microsoft 365) |
Text:Â Â Â Â Replaces strings within the provided text that matches the pattern with replacement |
|
REGEXTEST (Microsoft 365)​​​​​​​ |
Text:Â Â Â Â Determines whether any part of text matches the pattern |
|
Add-in and Automation:Â Â Â Â Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered |
|
|
Text:Â Â Â Â Replaces characters within text |
|
|
Text:Â Â Â Â Repeats text a given number of times |
|
|
Text:Â Â Â Â Returns the rightmost characters from a text value |
|
|
Math and trigonometry:Â Â Â Â Converts an arabic numeral to roman, as text |
|
|
Math and trigonometry:Â Â Â Â Rounds a number to a specified number of digits |
|
|
Math and trigonometry:Â Â Â Â Rounds a number down, toward zero |
|
|
Math and trigonometry:Â Â Â Â Rounds a number up, away from zero |
|
|
Lookup and reference:Â Â Â Â Returns the row number of a reference |
|
|
Lookup and reference:Â Â Â Â Returns the number of rows in a reference |
|
|
RRI (2013) |
Financial:Â Â Â Returns an equivalent interest rate for the growth of an investment |
|
Statistical:Â Â Â Â Returns the square of the Pearson product moment correlation coefficient |
|
|
Lookup and reference:Â Â Â Â Retrieves real-time data from a program that supports COM automation |
|
|
SCAN (2024) |
Logical:    Scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value |
|
Text:Â Â Â Â Finds one text value within another (not case-sensitive) |
|
|
SEC (2013) |
Math and trigonometry:Â Â Â Returns the secant of an angle |
|
SECH (2013) |
Math and trigonometry:Â Â Â Returns the hyperbolic secant of an angle |
|
Date and time:Â Â Â Â Converts a serial number to a second |
|
|
SEQUENCE (2021) |
Math and trigonometry:Â Â Â Generates a list of sequential numbers in an array, such as 1, 2, 3, 4 |
|
Math and trigonometry:Â Â Â Â Returns the sum of a power series based on the formula |
|
|
SHEET (2013) |
Information:Â Â Â Returns the sheet number of the referenced sheet |
|
SHEETS (2013) |
Information:Â Â Â Returns the number of sheets in a reference |
|
Math and trigonometry:Â Â Â Â Returns the sign of a number |
|
|
Math and trigonometry:Â Â Â Â Returns the sine of the given angle |
|
|
Math and trigonometry:Â Â Â Â Returns the hyperbolic sine of a number |
|
|
Statistical:Â Â Â Â Returns the skewness of a distribution |
|
|
SKEW.P (2013) |
Statistical:Â Â Â Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean |
|
Financial:Â Â Â Â Returns the straight-line depreciation of an asset for one period |
|
|
Statistical:Â Â Â Â Returns the slope of the linear regression line |
|
|
Statistical:Â Â Â Â Returns the k-th smallest value in a data set |
|
|
SORT (2021) |
Lookup and reference:Â Â Â Â Sorts the contents of a range or array |
|
SORTBY (2021) |
Lookup and reference:Â Â Â Â Sorts the contents of a range or array based on the values in a corresponding range or array |
|
Math and trigonometry:Â Â Â Â Returns a positive square root |
|
|
Math and trigonometry:Â Â Â Â Returns the square root of (number * pi) |
|
|
Statistical:Â Â Â Â Returns a normalized value |
|
|
Compatibility:Â Â Â Â Estimates standard deviation based on a sample |
|
|
STDEV.P (2010) |
Statistical:Â Â Â Â Calculates standard deviation based on the entire population |
|
STDEV.S (2010) |
Statistical:Â Â Â Â Estimates standard deviation based on a sample |
|
Statistical:Â Â Â Â Estimates standard deviation based on a sample, including numbers, text, and logical values |
|
|
Compatibility:Â Â Â Â Calculates standard deviation based on the entire population |
|
|
Statistical:Â Â Â Â Calculates standard deviation based on the entire population, including numbers, text, and logical values |
|
|
Statistical:Â Â Â Â Returns the standard error of the predicted y-value for each x in the regression |
|
|
Information:Â Â Â Â Retrieves historical data about a financial instrument and loads it as an array |
|
|
Text:Â Â Â Â Substitutes new text for old text in a text string |
|
|
Math and trigonometry:Â Â Â Â Returns a subtotal in a list or database |
|
|
Math and trigonometry:Â Â Â Â Adds its arguments |
|
|
Math and trigonometry:Â Â Â Â Adds the cells specified by a given criteria |
|
|
Math and trigonometry:Â Â Â Â Adds the cells in a range that meet multiple criteria |
|
|
Math and trigonometry:Â Â Â Â Returns the sum of the products of corresponding array components |
|
|
Math and trigonometry:Â Â Â Â Returns the sum of the squares of the arguments |
|
|
Math and trigonometry:Â Â Â Â Returns the sum of the difference of squares of corresponding values in two arrays |
|
|
Math and trigonometry:Â Â Â Â Returns the sum of the sum of squares of corresponding values in two arrays |
|
|
Math and trigonometry:Â Â Â Â Returns the sum of squares of differences of corresponding values in two arrays |
|
|
SWITCH (2019) |
Logical:Â Â Â 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. |
|
Financial:Â Â Â Â Returns the sum-of-years' digits depreciation of an asset for a specified period |
|
|
Text:Â Â Â Â Converts its arguments to text |
|
|
Math and trigonometry:Â Â Â Â Returns the tangent of a number |
|
|
Math and trigonometry:Â Â Â Â Returns the hyperbolic tangent of a number |
|
|
TAKE (2024) |
Lookup and reference: Â Â Â Returns a specified number of contiguous rows or columns from the start or end of an array |
|
Financial:Â Â Â Â Returns the bond-equivalent yield for a Treasury bill |
|
|
Financial:Â Â Â Â Returns the price per $100 face value for a Treasury bill |
|
|
Financial:Â Â Â Â Returns the yield for a Treasury bill |
|
|
T.DIST (2010) |
Statistical:Â Â Â Â Returns the Percentage Points (probability) for the Student t-distribution |
|
T.DIST.2T (2010) |
Statistical:Â Â Â Â Returns the Percentage Points (probability) for the Student t-distribution |
|
T.DIST.RT (2010) |
Statistical:Â Â Â Â Returns the Student's t-distribution |
|
Compatibility:Â Â Â Â Returns the Student's t-distribution |
|
|
Text:Â Â Â Â Formats a number and converts it to text |
|
|
TEXTAFTER (2024) |
Text: Â Â Â Returns text that occurs after given character or string |
|
TEXTBEFORE (2024) |
Text: Â Â Â Returns text that occurs before a given character or string |
|
TEXTJOIN (2019) |
Text: Â Â Â Combines the text from multiple ranges and/or strings |
|
TEXTSPLIT (2024) |
Text: Â Â Â Splits text strings by using column and row delimiters |
|
Date and time:Â Â Â Â Returns the serial number of a particular time |
|
|
Date and time:Â Â Â Â Converts a time in the form of text to a serial number |
|
|
T.INV (2010) |
Statistical:Â Â Â Â Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom |
|
T.INV.2T (2010) |
Statistical:Â Â Â Â Returns the inverse of the Student's t-distribution |
|
Compatibility:Â Â Â Â Returns the inverse of the Student's t-distribution |
|
|
TOCOL (2024) |
Lookup and reference: Â Â Â Returns the array in a single column |
|
TOROW (2024) |
Lookup and reference: Â Â Â Returns the array in a single row |
|
Date and time:Â Â Â Â Returns the serial number of today's date |
|
|
TRANSLATE (Microsoft 365)​​​​​​​ |
Text:Â Â Â Â Translates a text from one language to another |
|
Lookup and reference:Â Â Â Â Returns the transpose of an array |
|
|
Statistical:Â Â Â Â Returns values along a linear trend |
|
|
Text:Â Â Â Â Removes spaces from text |
|
|
Statistical:Â Â Â Â Returns the mean of the interior of a data set |
|
|
TRIMRANGE (Microsoft 365) |
Lookup and reference:Â Â Â Â Scans in from the edges of a range or array until it finds a non-blank cell (or value), it then excludes those blank rows or columns |
|
Logical:Â Â Â Â Returns the logical value TRUE |
|
|
Math and trigonometry:Â Â Â Â Truncates a number to an integer |
|
|
T.TEST (2010) |
Statistical:Â Â Â Â Returns the probability associated with a Student's t-test |
|
Compatibility:Â Â Â Â Returns the probability associated with a Student's t-test |
|
|
Information:Â Â Â Â Returns a number indicating the data type of a value |
|
|
UNICHAR (2013) |
Text:Â Â Â Returns the Unicode character that is references by the given numeric value |
|
UNICODE (2013) |
Text:Â Â Â Returns the number (code point) that corresponds to the first character of the text |
|
UNIQUE (2021) |
Lookup and reference:Â Â Â Â Returns a list of unique values in a list or range |
|
Text:Â Â Â Â Converts text to uppercase |
|
|
Text:Â Â Â Â Converts a text argument to a number |
|
|
Text: Â Â Â Returns text from any specified value |
|
|
Compatibility:Â Â Â Â Estimates variance based on a sample |
|
|
VAR.P (2010) |
Statistical:Â Â Â Â Calculates variance based on the entire population |
|
VAR.S (2010) |
Statistical:Â Â Â Â Estimates variance based on a sample |
|
Statistical:Â Â Â Â Estimates variance based on a sample, including numbers, text, and logical values |
|
|
Compatibility:Â Â Â Â Calculates variance based on the entire population |
|
|
Statistical:Â Â Â Â Calculates variance based on the entire population, including numbers, text, and logical values |
|
|
Financial:Â Â Â Â Returns the depreciation of an asset for a specified or partial period by using a declining balance method |
|
|
Lookup and reference:Â Â Â Â Looks in the first column of an array and moves across the row to return the value of a cell |
|
|
VSTACK (2024) |
Look and reference:    Appends arrays vertically and in sequence to return a larger array |
|
WEBSERVICE (2013) |
Web:Â Â Â Returns data from a web service. This function is not available in Excel for the web. |
|
Date and time:Â Â Â Â Converts a serial number to a day of the week |
|
|
Date and time:Â Â Â Â Converts a serial number to a number representing where the week falls numerically with a year |
|
|
Compatibility:Â Â Â Â Calculates variance based on the entire population, including numbers, text, and logical values |
|
|
WEIBULL.DIST (2010) |
Statistical:Â Â Â Â Returns the Weibull distribution |
|
Date and time:Â Â Â Â Returns the serial number of the date before or after a specified number of workdays |
|
|
WORKDAY.INTL (2010) |
Date and time:Â Â Â Returns 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 |
|
WRAPCOLS (2024) |
Look and reference: Â Â Â Wraps the provided row or column of values by columns after a specified number of elements |
|
WRAPROWS (2024) |
Look and reference: Â Â Â Wraps the provided row or column of values by rows after a specified number of elements |
|
Financial:Â Â Â Â Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic |
|
|
XLOOKUP (2021) |
Lookup and reference:   Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. |
|
XMATCH (2021) |
Lookup and reference:   Returns the relative position of an item in an array or range of cells. |
|
Financial:Â Â Â Â Returns the net present value for a schedule of cash flows that is not necessarily periodic |
|
|
XOR (2013) |
Logical:Â Â Â Returns a logical exclusive OR of all arguments |
|
Date and time:Â Â Â Â Converts a serial number to a year |
|
|
Date and time:Â Â Â Â Returns the year fraction representing the number of whole days between start_date and end_date |
|
|
Financial:Â Â Â Â Returns the yield on a security that pays periodic interest |
|
|
Financial:Â Â Â Â Returns the annual yield for a discounted security; for example, a Treasury bill |
|
|
Financial:Â Â Â Â Returns the annual yield of a security that pays interest at maturity |
|
|
Z.TEST (2010) |
Statistical:Â Â Â Â Returns the one-tailed probability-value of a z-test |
|
Compatibility:Â Â Â Â Returns the one-tailed probability-value of a z-test |
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.
