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 | The arc-cotangent of a number. |
| ACOTH | The hyperbolic arc-cotangent of a number. |
| ADDRESS | The cell reference given a row and column number. |
| AGGREGATE | The choice of 19 different operations for numerical values which can ignore hidden rows and errors. |
| 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 boolean True or False depending on multiple conditions. |
| ARABIC | The number converted from roman to arabic. |
| AREAS | The number of areas in a cell range or reference. |
| ARRAYTOTEXT | (2024) The contents of an array or cell range converted to text. |
| ASC | (Japanese) 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 given x and y co-ordinates. |
| ATANH | The hyperbolic arc-tangent of a number. |
| AVEDEV | The average deviation of the numerical values. |
| AVERAGE | The arithmetic mean of the numerical values. |
| AVERAGEA | The arithmetic mean of the numerical values (including logical values and text). |
| AVERAGEIF | (AVERAGEIFS) The arithmetic mean of the numerical values that satisfies one condition. |
| AVERAGEIFS | The arithmetic mean of the numerical values that satisfies multiple conditions. |
| BAHTTEXT | The number converted to Thai text and appended with 'Baht'. |
| BASE | 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 distribution function OR the cumulative probability function for a beta distribution. |
| 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 | 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 | The bitwise AND of two numbers. |
| BITLSHIFT | The number shifted left by a number of bits. |
| BITOR | The bitwise OR of two numbers. |
| BITRSHIFT | The number shifted right by a number of bits. |
| BITXOR | The bitwise Exclusive OR of two numbers. |
| BYCOL | (2024) The results from applying a LAMBDA function to each column in an array. |
| BYROW | (2024) The results from applying a LAMBDA function to each row in an array. |
| CALL | (Removed in 2003) The specification for a function or command using a registration ID. |
| CEILING | (Compatibility) The number rounded up to the nearest integer or significant figure. |
| CEILING.MATH | 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 | (2024) The array with just a specific number of columns. |
| CHOOSEROWS | (2024) 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 | 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 | The cotangent of a number. |
| COTH | The hyperbolic cotangent of a number. |
| COUNT | The number of numerical values. |
| COUNTA | The number of numerical values (including logical values and text). |
| COUNTBLANK | The number of empty cells. |
| COUNTIF | (COUNTIFS) The number of numerical values that satisfies one condition. |
| COUNTIFS | The number of numerical values 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 covariance based on an entire population. |
| 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 | The cosecant of a number. |
| CSCH | 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 | 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 | (Japanese) 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 | 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. |
| DETECTLANGUAGE | (365) Preview. The language code for the text string provided. |
| 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 | (2024) The array without certain rows or columns. |
| DSTDEV | The standard deviation of the values in a column that satisfies multiple conditions based on a sample. |
| DSTDEVP | The standard deviation of the values in 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 the values in a column that satisfies multiple conditions based on a sample. |
| DVARP | The variance of the values in 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 | 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 | (Euro Currency Tools add-in) 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 | (2024) 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 | (Compatibility) The logical value False. |
| FDIST | (F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative). |
| FIELDVALUE | (2024) The value in a particular field from a linked data type. |
| FILTER | (2021) The array after filtering data that satisfies multiple conditions. |
| FILTERXML | The specific data from the xml content by using xpath. |
| FIND | The starting position of a substring within a larger text string (case sensitive). |
| 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 | (Compatibility) The number rounded down to the nearest integer or significant figure. |
| FLOOR.MATH | 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 | The future value based on historical values. |
| FORECAST.LINEAR | The future y-value along a linear trend using existing values. |
| FORMULATEXT | The formula from a particular cell. |
| FREQUENCY | The number of times a particular value occurs. |
| 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 | 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 | 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 | (365) Preview. 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 | (XLOOKUP) 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 | (2024) 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 | 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 | (2024) 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 | The hyperbolic cosine of a complex number. |
| IMCOT | The cotangent of a complex number. |
| IMCSC | The cosecant of a complex number. |
| IMCSCH | 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 | The secant of a complex number. |
| IMSECH | The hyperbolic secant of a complex number. |
| IMSIN | The sine of a complex number. |
| IMSINH | 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 | 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 (excluding #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 | 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 | (2024) The boolean True or False depending whether the value in a LAMBDA is missing. |
| ISOWEEKNUM | The number of the ISO week of the year for a given date. |
| ISPMT | (Compatibility) 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 | (Japanese) The text string converted from single byte to double byte characters (renamed). |
| KURT | The kurtosis for a list or array of numbers. |
| LAMBDA | (2024) The results of a formula added as a named range. |
| LARGE | The kth largest numerical value. |
| 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 | (2024) The array calculated by applying a LAMBDA function. |
| MAP | (2024) The array formed by applying a map using a LAMBDA function. |
| MATCH | (XMATCH) The position of a value in a list, table or cell range. |
| MAX | The largest numerical value. |
| MAXA | The largest numerical value (including logical values and text). |
| MAXIFS | (2019) The largest numerical value 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 numerical value. |
| MINA | The smallest numerical value (including logical values and text). |
| MINIFS | (2019) The smallest numerical value 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 number of permutations for a given number of items (with duplicates). |
| MUNIT | The unit matrix or the specified dimension. |
| 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 The arc-cotangent of a number. |
| ACOTH The hyperbolic arc-cotangent of a number. |
| ADDRESS The cell reference given a row and column number. |
| AGGREGATE The choice of 19 different operations for numerical values which can ignore hidden rows and errors. |
| 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 boolean True or False depending on multiple conditions. |
| ARABIC The number converted from roman to arabic. |
| AREAS The number of areas in a cell range or reference. |
| ARRAYTOTEXT (2024) The contents of an array or cell range converted to text. |
| ASC (Japanese) 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 given x and y co-ordinates. |
| ATANH The hyperbolic arc-tangent of a number. |
| AVEDEV The average deviation of the numerical values. |
| AVERAGE The arithmetic mean of the numerical values. |
| AVERAGEA The arithmetic mean of the numerical values (including logical values and text). |
| AVERAGEIF (AVERAGEIFS) The arithmetic mean of the numerical values that satisfies one condition. |
| AVERAGEIFS The arithmetic mean of the numerical values that satisfies multiple conditions. |
| BAHTTEXT The number converted to Thai text and appended with 'Baht'. |
| BASE 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 distribution function OR the cumulative probability function for a beta distribution. |
| 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 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 The bitwise AND of two numbers. |
| BITLSHIFT The number shifted left by a number of bits. |
| BITOR The bitwise OR of two numbers. |
| BITRSHIFT The number shifted right by a number of bits. |
| BITXOR The bitwise Exclusive OR of two numbers. |
| BYCOL (2024) The results from applying a LAMBDA function to each column in an array. |
| BYROW (2024) The results from applying a LAMBDA function to each row in an array. |
| CALL (Removed in 2003) The specification for a function or command using a registration ID. |
| CEILING (Compatibility) The number rounded up to the nearest integer or significant figure. |
| CEILING.MATH 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 (2024) The array with just a specific number of columns. |
| CHOOSEROWS (2024) 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 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 The cotangent of a number. |
| COTH The hyperbolic cotangent of a number. |
| COUNT The number of numerical values. |
| COUNTA The number of numerical values (including logical values and text). |
| COUNTBLANK The number of empty cells. |
| COUNTIF (COUNTIFS) The number of numerical values that satisfies one condition. |
| COUNTIFS The number of numerical values 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 covariance based on an entire population. |
| 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 The cosecant of a number. |
| CSCH 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 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 (Japanese) 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 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. |
| DETECTLANGUAGE (365) Preview. The language code for the text string provided. |
| 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 (2024) The array without certain rows or columns. |
| DSTDEV The standard deviation of the values in a column that satisfies multiple conditions based on a sample. |
| DSTDEVP The standard deviation of the values in 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 the values in a column that satisfies multiple conditions based on a sample. |
| DVARP The variance of the values in 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 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 (Euro Currency Tools add-in) 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 (2024) 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 (Compatibility) The logical value False. |
| FDIST (F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative). |
| FIELDVALUE (2024) The value in a particular field from a linked data type. |
| FILTER (2021) The array after filtering data that satisfies multiple conditions. |
| FILTERXML The specific data from the xml content by using xpath. |
| FIND The starting position of a substring within a larger text string (case sensitive). |
| 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 (Compatibility) The number rounded down to the nearest integer or significant figure. |
| FLOOR.MATH 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 The future value based on historical values. |
| FORECAST.LINEAR The future y-value along a linear trend using existing values. |
| FORMULATEXT The formula from a particular cell. |
| FREQUENCY The number of times a particular value occurs. |
| 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 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 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 (365) Preview. 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 (XLOOKUP) 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 (2024) 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 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 (2024) 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 The hyperbolic cosine of a complex number. |
| IMCOT The cotangent of a complex number. |
| IMCSC The cosecant of a complex number. |
| IMCSCH 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 The secant of a complex number. |
| IMSECH The hyperbolic secant of a complex number. |
| IMSIN The sine of a complex number. |
| IMSINH 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 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 (excluding #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 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 (2024) The boolean True or False depending whether the value in a LAMBDA is missing. |
| ISOWEEKNUM The number of the ISO week of the year for a given date. |
| ISPMT (Compatibility) 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 (Japanese) The text string converted from single byte to double byte characters (renamed). |
| KURT The kurtosis for a list or array of numbers. |
| LAMBDA (2024) The results of a formula added as a named range. |
| LARGE The kth largest numerical value. |
| 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 (2024) The array calculated by applying a LAMBDA function. |
| MAP (2024) The array formed by applying a map using a LAMBDA function. |
| MATCH (XMATCH) The position of a value in a list, table or cell range. |
| MAX The largest numerical value. |
| MAXA The largest numerical value (including logical values and text). |
| MAXIFS (2019) The largest numerical value 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 numerical value. |
| MINA The smallest numerical value (including logical values and text). |
| MINIFS (2019) The smallest numerical value 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 number of permutations for a given number of items (with duplicates). |
| MUNIT The unit matrix or the specified dimension. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top