# Alphabetical A - M

ABS | The absolute value or a number without its sign. |

ACCRINT | The accrued interest for a security that pays interest periodically. |

ACCRINTM | The accrued interest for a security that pays interest at maturity. |

ACOS | The arc-cosine of a number. |

ACOSH | The hyperbolic arc-cosine of a number. |

ACOT | (2013) The arc-cotangent of a number. |

ACOTH | (2013) The hyperbolic arc-cotangent of a number. |

ADDRESS | The cell reference given a row and column number. |

AGGREGATE | The aggregate of values in a list, table or cell range. |

AMORDEGRC | The depreciation of an asset in a single period (straight-line, implicit coefficient). |

AMORLINC | The depreciation of an asset in a single period (straight-line). |

AND | The logical AND for any number of arguments. |

ARABIC | (2013) The number converted from roman to arabic. |

AREAS | The number of areas in a cell range or reference. |

ARRAYTOTEXT | (Microsoft 365) The contents of an array or cell ranges converted into text. |

ASC | The text string converted from double byte to single byte characters. |

ASIN | The arc-sine of a number. |

ASINH | The hyperbolic arc-sine of a number. |

ATAN | The arc-tangent of a number. |

ATAN2 | The arc-tangent of the specified x and y co-ordinates. |

ATANH | The hyperbolic arc-tangent of a number. |

AVEDEV | The average deviation of the numbers in a list, table or cell range. |

AVERAGE | The arithmetic mean of the values in a list, range or array. |

AVERAGEA | The arithmetic mean of the values in a list, range or array (including logical values and text). |

AVERAGEIF | (AVERAGEIFS) The arithmetic mean of all the numbers in a range that satisfies one condition. |

AVERAGEIFS | The arithmetic mean of all the numbers in a range that satisfies multiple conditions. |

BAHTTEXT | The number converted to a Thai text string and appends 'Baht'. |

BASE | (2013) The number converted into a text representation with the given base. |

BESSELI | The Bessel function evaluated for purely imaginary arguments. |

BESSELJ | The modified Bessel function represented by J(x). |

BESSELK | The modified Bessel function represented by K(x). |

BESSELY | The modified Bessel function represented by Y(x). |

BETA.DIST | The probability of getting a specific value between 0 and 1 for different distribution shapes. |

BETA.INV | The inverse of the cumulative probability function for a beta distribution. |

BETADIST | (BETA.DIST) The cumulative probability function for a beta distribution (only cumulative). |

BETAINV | (BETA.INV) The inverse of the probability distribution function for a beta distribution. |

BIN2DEC | The number converted from binary to decimal. |

BIN2HEX | The number converted from binary to hexadecimal. |

BIN2OCT | The number converted from binary to octal. |

BINOM.DIST | The probability of getting a specific number of successes using a binomial distribution. |

BINOM.DIST.RANGE | (2013) The probability of a trial result using a binomial distribution. |

BINOM.INV | The number of trials needed for a specific amount of success using a binomial distribution. |

BINOMDIST | (BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution. |

BITAND | (2013) The bitwise AND of two numbers. |

BITLSHIFT | (2013) The number shifted left by a number of bits. |

BITOR | (2013) The bitwise OR of two numbers. |

BITRSHIFT | (2013) The number shifted right by a number of bits. |

BITXOR | (2013) The bitwise Exclusive OR of two numbers. |

BYCOL | (Microsoft 365) The results from applying a LAMBDA function to each column in an array. |

BYROW | (Microsoft 365) The results from applying a LAMBDA function to each row in an array. |

CEILING | (CEILING.MATH) The number rounded up to the nearest integer or significant figure. |

CEILING.MATH | (2013) The number rounded up to the nearest integer or significant figure (including negative). |

CEILING.PRECISE | (CEILING.MATH) The number rounded up to the nearest integer or significant figure. |

CELL | The text string indicating information about a cell. |

CHAR | The character with the corresponding ANSI/ASCII number. |

CHIDIST | (CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |

CHIINV | (CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed). |

CHISQ.DIST | The probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed). |

CHISQ.DIST.RT | The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |

CHISQ.INV | The inverse of the probability distribution function for a chi-squared distribution (left tailed). |

CHISQ.INV.RT | The inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |

CHISQ.TEST | The probability value from a chi-squared distribution. |

CHITEST | (CHISQ.TEST) The probability value from a chi-squared distribution. |

CHOOSE | The value in a row (or column) based on an index number. |

CHOOSECOLS | (Microsoft 365) The array with just a specific number of columns. |

CHOOSEROWS | (Microsoft 365) The array with just a specifiic number of rows. |

CLEAN | The text string with all the non-printable characters removed. |

CODE | The ANSI/ASCII number for the first character in a text string. |

COLUMN | The column number of a cell reference. |

COLUMNS | The number of columns in a cell range or reference. |

COMBIN | The number of combinations for a given number of items (without repetition). |

COMBINA | (2013) The number of combinations for a given number of items (with repetition). |

COMPLEX | The complex number given real and imaginary coefficients. |

CONCAT | (2019) The text string that is a concatenation of cell ranges and strings. |

CONCATENATE | (CONCAT) The text string that is a concatenation of several strings. |

CONFIDENCE | (CONFIDENCE.NORM) The confidence interval for a population mean. |

CONFIDENCE.NORM | The confidence interval for a population mean. |

CONFIDENCE.T | The confidence interval for a population mean using a t distribution. |

CONVERT | The number in one measurement system converted to another. |

CORREL | The correlation coefficient between two data sets. |

COS | The cosine of a number. |

COSH | The hyperbolic cosine of a number. |

COT | (2013) The cotangent of a number. |

COTH | (2013) The hyperbolic cotangent of a number. |

COUNT | The number of values in a list, range or array. |

COUNTA | The number of values that are not empty cells. |

COUNTBLANK | The number of blank cells in a list, table or range. |

COUNTIF | (COUNTIFS) The number of numerical values in a range that satisfies one condition. |

COUNTIFS | The number of numerical values in a range that satisfies multiple conditions. |

COUPDAYBS | The number of days between the previous coupon date and the settlement date. |

COUPDAYS | The number of days between the coupon dates on either side of the settlement date. |

COUPDAYSNC | The number of days between the settlement date and the next coupon date. |

COUPNCD | The next coupon date after the settlement date. |

COUPNUM | The number of coupons between the settlement date and the maturity date. |

COUPPCD | The previous coupon date before the settlement date. |

COVAR | (COVARIANCE.P) The average of the products of deviations for each data point pair. |

COVARIANCE.P | The covariance based on an entire population. |

COVARIANCE.S | The covariance based on a sample. |

CRITBINOM | (BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). |

CSC | (2013) The cosecant of a number. |

CSCH | (2013) The hyperbolic cosecant of a number. |

CUBEKPIMEMBER | The name of a key performance indicator. |

CUBEMEMBER | The member or tuple from a cube. |

CUBESET | The calculated members returned from a cube. |

CUBESETCOUNT | The number of items in a set. |

CUBEVALUE | The aggregated value from a cube. |

CUMIPMT | The cumulative interest payment on a loan between two dates. |

CUMPRINC | The cumulative principal paid on a loan between two dates. |

DATE | The date as a date serial number given a year, month, day. |

DATEDIF | (Compatibility) The number of days, months or years between two dates. |

DATEVALUE | The date serial number given a date in text format. |

DAVERAGE | The arithmetic mean of all the numbers in a column that satisfies multiple conditions. |

DAY | The day as an integer given a date serial number. |

DAYS | (2013) The number of days between two dates. |

DAYS360 | The number of days between two dates, based on 30 day months. |

DB | The depreciation of an asset in a single period (declining balance method). |

DBCS | (2013) The text string converted from single byte to double byte characters. |

DCOUNT | The number of numerical values in a column that satisfies multiple conditions. |

DCOUNTA | The number of numerical values in a column that satisfies multiple conditions (including logical values and text). |

DDB | The depreciation of an asset in a single period (double or triple declining balance method). |

DEC2BIN | The number converted from decimal to binary. |

DEC2HEX | The number converted from decimal to hexadecimal. |

DEC2OCT | The number converted from decimal to octal. |

DECIMAL | (2013) The decimal number of a text representation of a number in a given base. |

DEGREES | The number of degrees given a number of radians. |

DELTA | The numerical value indicating if two numbers are equal. |

DEVSQ | The sum of the squared deviations from the mean. |

DGET | The single value in a column that satisfies multiple conditions. |

DISC | The interest rate (or discount rate) for a security held to maturity. |

DMAX | The largest value in a column that satisfies multiple conditions. |

DMIN | The smallest value in a column that satisfies multiple conditions. |

DOLLAR | The text string of a number with the dollar formatting $0,000.00. |

DOLLARDE | The dollar fraction expressed as a decimal. |

DOLLARFR | The dollar decimal expressed as a fraction. |

DPRODUCT | The product of the values in a column that satisfies multiple conditions. |

DROP | (Microsoft 365) The array without certain rows or columns. |

DSTDEV | The standard deviation of a column that satisfies multiple conditions based on a sample. |

DSTDEVP | The standard deviation of a column that satisfies multiple conditions based on an entire population. |

DSUM | The total of the values in a column that satisfies multiple conditions. |

DURATION | The annual duration of a security that pays interest periodically. |

DVAR | The variance of a column that satisfies multiple conditions based on a sample. |

DVARP | The variance of a column that satisfies multiple conditions based on an entire population. |

ECMA.CEILING | (Compatibility) The number rounded up to the nearest multiple of significance. |

EDATE | The date serial number that is a certain number of months before or after a date. |

EFFECT | The effective interest rate given a nominal interest rate and compounding frequency. |

ENCODEURL | (2013) The url encoded string. |

EOMONTH | The date serial number of the last day of a month before or after a date. |

ERF | The value of the error function integrated between two limits. |

ERF.PRECISE | The value of the error function integrated between 0 and a limit. |

ERFC | (ERFC.PRECISE) The complementary error function integrated between a limit and infinity. |

ERFC.PRECISE | The complementary error function integrated between a limit and infinity. |

ERROR.TYPE | The number corresponding to a particular error value in a cell. |

EUROCONVERT | The number converted to euros. |

EVEN | The number rounded up to the nearest even integer. |

EXACT | The value True or False based on whether two strings match exactly. |

EXP | The exponential number raised to a particular power. |

EXPAND | (Microsoft 365) The array expanded or padded to specific dimensions. |

EXPON.DIST | The probability distribution function OR the cumulative probability function for an exponential distribution. |

EXPONDIST | (EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution. |

F.DIST | The probability distribution function OR the cumulative probability function for an f distribution (left tailed). |

F.DIST.RT | The probability distribution function for an f distribution (right tailed) (no cumulative). |

F.INV | The inverse of the probability distribution function for an f distribution (left tailed). |

F.INV.RT | The inverse of the probability distribution function for an f distribution (right tailed). |

F.TEST | The probability value from an f distribution. |

FACT | The factorial of a positive whole number. |

FACTDOUBLE | The double factorial of a positive whole number. |

FALSE | The logical value False. |

FDIST | (F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative). |

FIELDVALUE | (Microsoft 365) The value in a particular field from a linked data type. |

FILTER | (2021) The array after filtering data in a range that satisfies multiple conditions. |

FILTERXML | (2013) The specific data from the xml content by using xpath. |

FIND | The starting position of a substring within a larger text string. |

FINV | (F.INV) The inverse of the probability distribution function for an f distribution (left tailed). |

FISHER | The fisher transformation. |

FISHERINV | The inverse of the fisher transformation. |

FIXED | The text string of a number rounded to a fixed number of decimal places. |

FLOOR | (FLOOR.MATH) The number rounded down to the nearest integer or significant figure. |

FLOOR.MATH | (2013) The number rounded down to the nearest integer or significant figure (including negative). |

FLOOR.PRECISE | (FLOOR.MATH) The number rounded down to the nearest integer or significant figure. |

FORECAST | (FORECAST.LINEAR) The future y-value along a linear trend using existing values. |

FORECAST.ETS | (2016) The future value based on historical values. |

FORECAST.LINEAR | (2016) The future y-value along a linear trend using existing values. |

FORMULATEXT | (2013) The formula from a particular cell. |

FREQUENCY | The number of times a particular value occurs in a list, table or cell range. |

FTEST | (F.TEST) The probability value from an f distribution. |

FV | The future value of a series of equal cash flows at regular intervals. |

FVSCHEDULE | The future value of an initial principal after applying compound interest rates. |

GAMMA | (2013) The gamma function value. |

GAMMA.DIST | The probability distribution function OR the cumulative probability function for a gamma distribution. |

GAMMA.INV | The inverse of the cumulative probability function for a gamma distribution. |

GAMMADIST | (GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution. |

GAMMAINV | (GAMMA.INV) The inverse of the probability distribution for a gamma distribution. |

GAMMALN | (GAMMALN.PRECISE) The natural logarithm of the gamma function. |

GAMMALN.PRECISE | The natural logarithm of the gamma function. |

GAUSS | (2013) The 0.5 less than the standard normal cumulative distribution. |

GCD | The greatest common divisor of two or more numbers. |

GEOMEAN | The geometric mean of an array of numbers. |

GESTEP | The value True or False depending if the number is greater than a threshold value. |

GETPIVOTDATA | The data obtained from a pivot table. |

GROUPBY | (Microsoft 365) The grouping of your data along one axis and aggregates the associated values. |

GROWTH | The predicted exponential growth using existing data. |

HARMEAN | The harmonic mean of a data set. |

HEX2BIN | The number converted from hexadecimal to binary. |

HEX2DEC | The number converted from hexadecimal to decimal. |

HEX2OCT | The number converted from hexadecimal to octal. |

HLOOKUP | The value in the same column after finding a matching value in the first row. |

HOUR | The hour as an integer given a date serial number. |

HSTACK | (Microsoft 365) The array after putting multiple arrays next to each other. |

HYPERLINK | The hyperlink linked to a cell, document or webpage. |

HYPGEOM.DIST | The probability distribution functon OR the cumulative probability function for a hypergeometric distribution. |

HYPGEOMDIST | (HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only cumulative). |

IF | The value based on whether a condition is True or False. |

IFERROR | The value or something else if it evaluates to an error. |

IFNA | (2013) The value or something else if it evaluates to #N/A. |

IFS | (2019) The value based on multiple True or False conditions. |

IMABS | The absolute value of a complex number. |

IMAGE | (Microsoft 365) The image from a web URL. |

IMAGINARY | The imaginary coefficient of a complex number. |

IMARGUMENT | The theta argument in radians. |

IMCONJUGATE | The complex conjugate of a complex number. |

IMCOS | The cosine of a complex number. |

IMCOSH | (2013) The hyperbolic cosine of a complex number. |

IMCOT | (2013) The cotangent of a complex number. |

IMCSC | (2013) The cosecant of a complex number. |

IMCSCH | (2013) The hyperbolic cosecant of a complex number. |

IMDIV | The quotient of two complex numbers. |

IMEXP | The exponential of a complex number. |

IMLN | The natural logarithm of a complex number. |

IMLOG10 | The base-10 logarithm of a complex number. |

IMLOG2 | The base-2 logarithm of a complex number. |

IMPOWER | The complex number raised to an integer number. |

IMPRODUCT | The product of two or more complex numbers. |

IMREAL | The real coefficient of a complex number. |

IMSEC | (2013) The secant of a complex number. |

IMSECH | (2013) The hyperbolic secant of a complex number. |

IMSIN | The sine of a complex number. |

IMSINH | (2013) The hyperbolic sine of a complex number. |

IMSQRT | The square root of a complex number. |

IMSUB | The difference of two complex numbers. |

IMSUM | The sum of two or more complex numbers. |

IMTAN | (2013) The tangent of a complex number. |

INDEX | The value from a cell range which is the intersection of a row AND a column. |

INDIRECT | The value of a given cell reference specified by a text string. |

INFO | The text string returning useful information about the environment. |

INT | The number rounded down to the nearest integer. |

INTERCEPT | The intersection with the y-axis using a linear regression plotted through known values. |

INTRATE | The interest rate for a security held to maturity. |

IPMT | The interest amount paid on a given period on a loan with fixed interest. |

IRR | The interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate). |

ISBLANK | The boolean True or False depending if the value is blank. |

ISERR | The boolean True or False depending if the value is an error (not #N/A). |

ISERROR | The boolean True or False depending if the value is an error. |

ISEVEN | The boolean True or False depending if the value is an even number. |

ISFORMULA | (2013) The boolean True or False depending if the cell contains a formula. |

ISLOGICAL | The boolean True or False depending if the value is True or False. |

ISNA | The boolean True or False depending if the value is #N/A. |

ISNONTEXT | The boolean True or False depending if the value is non text. |

ISNUMBER | The boolean True or False depending if the value is a number. |

ISO.CEILING | (CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed). |

ISODD | The boolean True or False depending if the value is an odd number. |

ISOMITTED | (Microsoft 365) The boolean True or False depending whether the value in a LAMBDA is missing. |

ISOWEEKNUM | (2013) The number of the ISO week of the year for a given date. |

ISPMT | (IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly). |

ISREF | The boolean True or False depending if the value is a cell reference. |

ISTEXT | The boolean True or False depending if the value is text. |

JIS | (DBCS) The text string converted from single byte to double byte characters (renamed). |

KURT | The kurtosis for a list or array of numbers. |

LAMBDA | (Microsoft 365) The results of a formula added as a named range. |

LARGE | The kth largest value in a list or array of numbers. |

LCM | The least common multiple of two or more numbers. |

LEFT | The first or left most characters in a text string. |

LEN | The number of characters in a text string. |

LET | (2021) The result of a formula that can use variables. |

LINEST | The array of values for a straight line that best fits your data. |

LN | The natural logarithm of a number. |

LOG | The logarithm of a number to any base. |

LOG10 | The logarithm of a number to the base 10. |

LOGEST | The array of values for an exponential curve that best fits your data. |

LOGINV | (LOGNORM.INV) The inverse of the probability distribution function for a lognormal distribution. |

LOGNORM.DIST | The probability distribution function OR the cumulative probability function for a lognormal distribution. |

LOGNORM.INV | The inverse of the probability distribution function for a lognormal distribution. |

LOGNORMDIST | (LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative). |

LOOKUP | The value in a row (or column) that matches a value in a column (or row). |

LOWER | The text string with all the characters converted to lowercase. |

MAKEARRAY | (Microsoft 365) The array calculated by applying a LAMBDA function. |

MAP | (Microsoft 365) The array formed by applying a map using a LAMBDA function. |

MATCH | The position of a value in a list, table or cell range. |

MAX | The largest value in a list, range or array. |

MAXA | The largest value in a list, range or array (including logical values and text). |

MAXIFS | (2019) The largest value in a list, range or array that satisfies multiple conditions. |

MDETERM | The matrix determinant of an array. |

MDURATION | The modified duration for a security that pays interest periodically. |

MEDIAN | The number in the middle of a set of numbers. |

MID | The characters from the middle of a text string. |

MIN | The smallest value in a list, range or array. |

MINA | The smallest value in a list, range or array (including logical values and text). |

MINIFS | (2019) The smallest value in a list, range or array that satisfies multiple conditions. |

MINUTE | The minute as an integer given a date serial number. |

MINVERSE | The inverse matrix of an array. |

MIRR | The interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate). |

MMULT | The matrix product of two arrays. |

MOD | The remainder after division. |

MODE | (MODE.SNGL) The first number that appears the most often in a set. |

MODE.MULT | The array of all the numbers that appears the most often in a set. |

MODE.SNGL | The first number that appears the most often in a set. |

MONTH | The month as an integer given a date serial number. |

MROUND | The number rounded to the desired multiple. |

MULTINOMIAL | The multinomial of a set of numbers in a list or cell range. |

MUNIT | (2013) The unit matrix or the specified dimension. |

ABSThe absolute value or a number without its sign. |

ACCRINTThe accrued interest for a security that pays interest periodically. |

ACCRINTMThe accrued interest for a security that pays interest at maturity. |

ACOSThe arc-cosine of a number. |

ACOSHThe hyperbolic arc-cosine of a number. |

ACOT(2013) The arc-cotangent of a number. |

ACOTH(2013) The hyperbolic arc-cotangent of a number. |

ADDRESSThe cell reference given a row and column number. |

AGGREGATEThe aggregate of values in a list, table or cell range. |

AMORDEGRCThe depreciation of an asset in a single period (straight-line, implicit coefficient). |

AMORLINCThe depreciation of an asset in a single period (straight-line). |

ANDThe logical AND for any number of arguments. |

ARABIC(2013) The number converted from roman to arabic. |

AREASThe number of areas in a cell range or reference. |

ARRAYTOTEXT(Microsoft 365) The contents of an array or cell ranges converted into text. |

ASCThe text string converted from double byte to single byte characters. |

ASINThe arc-sine of a number. |

ASINHThe hyperbolic arc-sine of a number. |

ATANThe arc-tangent of a number. |

ATAN2The arc-tangent of the specified x and y co-ordinates. |

ATANHThe hyperbolic arc-tangent of a number. |

AVEDEVThe average deviation of the numbers in a list, table or cell range. |

AVERAGEThe arithmetic mean of the values in a list, range or array. |

AVERAGEAThe arithmetic mean of the values in a list, range or array (including logical values and text). |

AVERAGEIF(AVERAGEIFS) The arithmetic mean of all the numbers in a range that satisfies one condition. |

AVERAGEIFSThe arithmetic mean of all the numbers in a range that satisfies multiple conditions. |

BAHTTEXTThe number converted to a Thai text string and appends 'Baht'. |

BASE(2013) The number converted into a text representation with the given base. |

BESSELIThe Bessel function evaluated for purely imaginary arguments. |

BESSELJThe modified Bessel function represented by J(x). |

BESSELKThe modified Bessel function represented by K(x). |

BESSELYThe modified Bessel function represented by Y(x). |

BETA.DISTThe probability of getting a specific value between 0 and 1 for different distribution shapes. |

BETA.INVThe inverse of the cumulative probability function for a beta distribution. |

BETADIST(BETA.DIST) The cumulative probability function for a beta distribution (only cumulative). |

BETAINV(BETA.INV) The inverse of the probability distribution function for a beta distribution. |

BIN2DECThe number converted from binary to decimal. |

BIN2HEXThe number converted from binary to hexadecimal. |

BIN2OCTThe number converted from binary to octal. |

BINOM.DISTThe probability of getting a specific number of successes using a binomial distribution. |

BINOM.DIST.RANGE(2013) The probability of a trial result using a binomial distribution. |

BINOM.INVThe number of trials needed for a specific amount of success using a binomial distribution. |

BINOMDIST(BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution. |

BITAND(2013) The bitwise AND of two numbers. |

BITLSHIFT(2013) The number shifted left by a number of bits. |

BITOR(2013) The bitwise OR of two numbers. |

BITRSHIFT(2013) The number shifted right by a number of bits. |

BITXOR(2013) The bitwise Exclusive OR of two numbers. |

BYCOL(Microsoft 365) The results from applying a LAMBDA function to each column in an array. |

BYROW(Microsoft 365) The results from applying a LAMBDA function to each row in an array. |

CEILING(CEILING.MATH) The number rounded up to the nearest integer or significant figure. |

CEILING.MATH(2013) The number rounded up to the nearest integer or significant figure (including negative). |

CEILING.PRECISE(CEILING.MATH) The number rounded up to the nearest integer or significant figure. |

CELLThe text string indicating information about a cell. |

CHARThe character with the corresponding ANSI/ASCII number. |

CHIDIST(CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |

CHIINV(CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed). |

CHISQ.DISTThe probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed). |

CHISQ.DIST.RTThe probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |

CHISQ.INVThe inverse of the probability distribution function for a chi-squared distribution (left tailed). |

CHISQ.INV.RTThe inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |

CHISQ.TESTThe probability value from a chi-squared distribution. |

CHITEST(CHISQ.TEST) The probability value from a chi-squared distribution. |

CHOOSEThe value in a row (or column) based on an index number. |

CHOOSECOLS(Microsoft 365) The array with just a specific number of columns. |

CHOOSEROWS(Microsoft 365) The array with just a specifiic number of rows. |

CLEANThe text string with all the non-printable characters removed. |

CODEThe ANSI/ASCII number for the first character in a text string. |

COLUMNThe column number of a cell reference. |

COLUMNSThe number of columns in a cell range or reference. |

COMBINThe number of combinations for a given number of items (without repetition). |

COMBINA(2013) The number of combinations for a given number of items (with repetition). |

COMPLEXThe complex number given real and imaginary coefficients. |

CONCAT(2019) The text string that is a concatenation of cell ranges and strings. |

CONCATENATE(CONCAT) The text string that is a concatenation of several strings. |

CONFIDENCE(CONFIDENCE.NORM) The confidence interval for a population mean. |

CONFIDENCE.NORMThe confidence interval for a population mean. |

CONFIDENCE.TThe confidence interval for a population mean using a t distribution. |

CONVERTThe number in one measurement system converted to another. |

CORRELThe correlation coefficient between two data sets. |

COSThe cosine of a number. |

COSHThe hyperbolic cosine of a number. |

COT(2013) The cotangent of a number. |

COTH(2013) The hyperbolic cotangent of a number. |

COUNTThe number of values in a list, range or array. |

COUNTAThe number of values that are not empty cells. |

COUNTBLANKThe number of blank cells in a list, table or range. |

COUNTIF(COUNTIFS) The number of numerical values in a range that satisfies one condition. |

COUNTIFSThe number of numerical values in a range that satisfies multiple conditions. |

COUPDAYBSThe number of days between the previous coupon date and the settlement date. |

COUPDAYSThe number of days between the coupon dates on either side of the settlement date. |

COUPDAYSNCThe number of days between the settlement date and the next coupon date. |

COUPNCDThe next coupon date after the settlement date. |

COUPNUMThe number of coupons between the settlement date and the maturity date. |

COUPPCDThe previous coupon date before the settlement date. |

COVAR(COVARIANCE.P) The average of the products of deviations for each data point pair. |

COVARIANCE.PThe covariance based on an entire population. |

COVARIANCE.SThe covariance based on a sample. |

CRITBINOM(BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). |

CSC(2013) The cosecant of a number. |

CSCH(2013) The hyperbolic cosecant of a number. |

CUBEKPIMEMBERThe name of a key performance indicator. |

CUBEMEMBERThe member or tuple from a cube. |

CUBESETThe calculated members returned from a cube. |

CUBESETCOUNTThe number of items in a set. |

CUBEVALUEThe aggregated value from a cube. |

CUMIPMTThe cumulative interest payment on a loan between two dates. |

CUMPRINCThe cumulative principal paid on a loan between two dates. |

DATEThe date as a date serial number given a year, month, day. |

DATEDIF(Compatibility) The number of days, months or years between two dates. |

DATEVALUEThe date serial number given a date in text format. |

DAVERAGEThe arithmetic mean of all the numbers in a column that satisfies multiple conditions. |

DAYThe day as an integer given a date serial number. |

DAYS(2013) The number of days between two dates. |

DAYS360The number of days between two dates, based on 30 day months. |

DBThe depreciation of an asset in a single period (declining balance method). |

DBCS(2013) The text string converted from single byte to double byte characters. |

DCOUNTThe number of numerical values in a column that satisfies multiple conditions. |

DCOUNTAThe number of numerical values in a column that satisfies multiple conditions (including logical values and text). |

DDBThe depreciation of an asset in a single period (double or triple declining balance method). |

DEC2BINThe number converted from decimal to binary. |

DEC2HEXThe number converted from decimal to hexadecimal. |

DEC2OCTThe number converted from decimal to octal. |

DECIMAL(2013) The decimal number of a text representation of a number in a given base. |

DEGREESThe number of degrees given a number of radians. |

DELTAThe numerical value indicating if two numbers are equal. |

DEVSQThe sum of the squared deviations from the mean. |

DGETThe single value in a column that satisfies multiple conditions. |

DISCThe interest rate (or discount rate) for a security held to maturity. |

DMAXThe largest value in a column that satisfies multiple conditions. |

DMINThe smallest value in a column that satisfies multiple conditions. |

DOLLARThe text string of a number with the dollar formatting $0,000.00. |

DOLLARDEThe dollar fraction expressed as a decimal. |

DOLLARFRThe dollar decimal expressed as a fraction. |

DPRODUCTThe product of the values in a column that satisfies multiple conditions. |

DROP(Microsoft 365) The array without certain rows or columns. |

DSTDEVThe standard deviation of a column that satisfies multiple conditions based on a sample. |

DSTDEVPThe standard deviation of a column that satisfies multiple conditions based on an entire population. |

DSUMThe total of the values in a column that satisfies multiple conditions. |

DURATIONThe annual duration of a security that pays interest periodically. |

DVARThe variance of a column that satisfies multiple conditions based on a sample. |

DVARPThe variance of a column that satisfies multiple conditions based on an entire population. |

ECMA.CEILING(Compatibility) The number rounded up to the nearest multiple of significance. |

EDATEThe date serial number that is a certain number of months before or after a date. |

EFFECTThe effective interest rate given a nominal interest rate and compounding frequency. |

ENCODEURL(2013) The url encoded string. |

EOMONTHThe date serial number of the last day of a month before or after a date. |

ERFThe value of the error function integrated between two limits. |

ERF.PRECISEThe value of the error function integrated between 0 and a limit. |

ERFC(ERFC.PRECISE) The complementary error function integrated between a limit and infinity. |

ERFC.PRECISEThe complementary error function integrated between a limit and infinity. |

ERROR.TYPEThe number corresponding to a particular error value in a cell. |

EUROCONVERTThe number converted to euros. |

EVENThe number rounded up to the nearest even integer. |

EXACTThe value True or False based on whether two strings match exactly. |

EXPThe exponential number raised to a particular power. |

EXPAND(Microsoft 365) The array expanded or padded to specific dimensions. |

EXPON.DISTThe probability distribution function OR the cumulative probability function for an exponential distribution. |

EXPONDIST(EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution. |

F.DISTThe probability distribution function OR the cumulative probability function for an f distribution (left tailed). |

F.DIST.RTThe probability distribution function for an f distribution (right tailed) (no cumulative). |

F.INVThe inverse of the probability distribution function for an f distribution (left tailed). |

F.INV.RTThe inverse of the probability distribution function for an f distribution (right tailed). |

F.TESTThe probability value from an f distribution. |

FACTThe factorial of a positive whole number. |

FACTDOUBLEThe double factorial of a positive whole number. |

FALSEThe logical value False. |

FDIST(F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative). |

FIELDVALUE(Microsoft 365) The value in a particular field from a linked data type. |

FILTER(2021) The array after filtering data in a range that satisfies multiple conditions. |

FILTERXML(2013) The specific data from the xml content by using xpath. |

FINDThe starting position of a substring within a larger text string. |

FINV(F.INV) The inverse of the probability distribution function for an f distribution (left tailed). |

FISHERThe fisher transformation. |

FISHERINVThe inverse of the fisher transformation. |

FIXEDThe text string of a number rounded to a fixed number of decimal places. |

FLOOR(FLOOR.MATH) The number rounded down to the nearest integer or significant figure. |

FLOOR.MATH(2013) The number rounded down to the nearest integer or significant figure (including negative). |

FLOOR.PRECISE(FLOOR.MATH) The number rounded down to the nearest integer or significant figure. |

FORECAST(FORECAST.LINEAR) The future y-value along a linear trend using existing values. |

FORECAST.ETS(2016) The future value based on historical values. |

FORECAST.LINEAR(2016) The future y-value along a linear trend using existing values. |

FORMULATEXT(2013) The formula from a particular cell. |

FREQUENCYThe number of times a particular value occurs in a list, table or cell range. |

FTEST(F.TEST) The probability value from an f distribution. |

FVThe future value of a series of equal cash flows at regular intervals. |

FVSCHEDULEThe future value of an initial principal after applying compound interest rates. |

GAMMA(2013) The gamma function value. |

GAMMA.DISTThe probability distribution function OR the cumulative probability function for a gamma distribution. |

GAMMA.INVThe inverse of the cumulative probability function for a gamma distribution. |

GAMMADIST(GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution. |

GAMMAINV(GAMMA.INV) The inverse of the probability distribution for a gamma distribution. |

GAMMALN(GAMMALN.PRECISE) The natural logarithm of the gamma function. |

GAMMALN.PRECISEThe natural logarithm of the gamma function. |

GAUSS(2013) The 0.5 less than the standard normal cumulative distribution. |

GCDThe greatest common divisor of two or more numbers. |

GEOMEANThe geometric mean of an array of numbers. |

GESTEPThe value True or False depending if the number is greater than a threshold value. |

GETPIVOTDATAThe data obtained from a pivot table. |

GROUPBY(Microsoft 365) The grouping of your data along one axis and aggregates the associated values. |

GROWTHThe predicted exponential growth using existing data. |

HARMEANThe harmonic mean of a data set. |

HEX2BINThe number converted from hexadecimal to binary. |

HEX2DECThe number converted from hexadecimal to decimal. |

HEX2OCTThe number converted from hexadecimal to octal. |

HLOOKUPThe value in the same column after finding a matching value in the first row. |

HOURThe hour as an integer given a date serial number. |

HSTACK(Microsoft 365) The array after putting multiple arrays next to each other. |

HYPERLINKThe hyperlink linked to a cell, document or webpage. |

HYPGEOM.DISTThe probability distribution functon OR the cumulative probability function for a hypergeometric distribution. |

HYPGEOMDIST(HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only cumulative). |

IFThe value based on whether a condition is True or False. |

IFERRORThe value or something else if it evaluates to an error. |

IFNA(2013) The value or something else if it evaluates to #N/A. |

IFS(2019) The value based on multiple True or False conditions. |

IMABSThe absolute value of a complex number. |

IMAGE(Microsoft 365) The image from a web URL. |

IMAGINARYThe imaginary coefficient of a complex number. |

IMARGUMENTThe theta argument in radians. |

IMCONJUGATEThe complex conjugate of a complex number. |

IMCOSThe cosine of a complex number. |

IMCOSH(2013) The hyperbolic cosine of a complex number. |

IMCOT(2013) The cotangent of a complex number. |

IMCSC(2013) The cosecant of a complex number. |

IMCSCH(2013) The hyperbolic cosecant of a complex number. |

IMDIVThe quotient of two complex numbers. |

IMEXPThe exponential of a complex number. |

IMLNThe natural logarithm of a complex number. |

IMLOG10The base-10 logarithm of a complex number. |

IMLOG2The base-2 logarithm of a complex number. |

IMPOWERThe complex number raised to an integer number. |

IMPRODUCTThe product of two or more complex numbers. |

IMREALThe real coefficient of a complex number. |

IMSEC(2013) The secant of a complex number. |

IMSECH(2013) The hyperbolic secant of a complex number. |

IMSINThe sine of a complex number. |

IMSINH(2013) The hyperbolic sine of a complex number. |

IMSQRTThe square root of a complex number. |

IMSUBThe difference of two complex numbers. |

IMSUMThe sum of two or more complex numbers. |

IMTAN(2013) The tangent of a complex number. |

INDEXThe value from a cell range which is the intersection of a row AND a column. |

INDIRECTThe value of a given cell reference specified by a text string. |

INFOThe text string returning useful information about the environment. |

INTThe number rounded down to the nearest integer. |

INTERCEPTThe intersection with the y-axis using a linear regression plotted through known values. |

INTRATEThe interest rate for a security held to maturity. |

IPMTThe interest amount paid on a given period on a loan with fixed interest. |

IRRThe interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate). |

ISBLANKThe boolean True or False depending if the value is blank. |

ISERRThe boolean True or False depending if the value is an error (not #N/A). |

ISERRORThe boolean True or False depending if the value is an error. |

ISEVENThe boolean True or False depending if the value is an even number. |

ISFORMULA(2013) The boolean True or False depending if the cell contains a formula. |

ISLOGICALThe boolean True or False depending if the value is True or False. |

ISNAThe boolean True or False depending if the value is #N/A. |

ISNONTEXTThe boolean True or False depending if the value is non text. |

ISNUMBERThe boolean True or False depending if the value is a number. |

ISO.CEILING(CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed). |

ISODDThe boolean True or False depending if the value is an odd number. |

ISOMITTED(Microsoft 365) The boolean True or False depending whether the value in a LAMBDA is missing. |

ISOWEEKNUM(2013) The number of the ISO week of the year for a given date. |

ISPMT(IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly). |

ISREFThe boolean True or False depending if the value is a cell reference. |

ISTEXTThe boolean True or False depending if the value is text. |

JIS(DBCS) The text string converted from single byte to double byte characters (renamed). |

KURTThe kurtosis for a list or array of numbers. |

LAMBDA(Microsoft 365) The results of a formula added as a named range. |

LARGEThe kth largest value in a list or array of numbers. |

LCMThe least common multiple of two or more numbers. |

LEFTThe first or left most characters in a text string. |

LENThe number of characters in a text string. |

LET(2021) The result of a formula that can use variables. |

LINESTThe array of values for a straight line that best fits your data. |

LNThe natural logarithm of a number. |

LOGThe logarithm of a number to any base. |

LOG10The logarithm of a number to the base 10. |

LOGESTThe array of values for an exponential curve that best fits your data. |

LOGINV(LOGNORM.INV) The inverse of the probability distribution function for a lognormal distribution. |

LOGNORM.DISTThe probability distribution function OR the cumulative probability function for a lognormal distribution. |

LOGNORM.INVThe inverse of the probability distribution function for a lognormal distribution. |

LOGNORMDIST(LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative). |

LOOKUPThe value in a row (or column) that matches a value in a column (or row). |

LOWERThe text string with all the characters converted to lowercase. |

MAKEARRAY(Microsoft 365) The array calculated by applying a LAMBDA function. |

MAP(Microsoft 365) The array formed by applying a map using a LAMBDA function. |

MATCHThe position of a value in a list, table or cell range. |

MAXThe largest value in a list, range or array. |

MAXAThe largest value in a list, range or array (including logical values and text). |

MAXIFS(2019) The largest value in a list, range or array that satisfies multiple conditions. |

MDETERMThe matrix determinant of an array. |

MDURATIONThe modified duration for a security that pays interest periodically. |

MEDIANThe number in the middle of a set of numbers. |

MIDThe characters from the middle of a text string. |

MINThe smallest value in a list, range or array. |

MINAThe smallest value in a list, range or array (including logical values and text). |

MINIFS(2019) The smallest value in a list, range or array that satisfies multiple conditions. |

MINUTEThe minute as an integer given a date serial number. |

MINVERSEThe inverse matrix of an array. |

MIRRThe interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate). |

MMULTThe matrix product of two arrays. |

MODThe remainder after division. |

MODE(MODE.SNGL) The first number that appears the most often in a set. |

MODE.MULTThe array of all the numbers that appears the most often in a set. |

MODE.SNGLThe first number that appears the most often in a set. |

MONTHThe month as an integer given a date serial number. |

MROUNDThe number rounded to the desired multiple. |

MULTINOMIALThe multinomial of a set of numbers in a list or cell range. |

MUNIT(2013) The unit matrix or the specified dimension. |

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top