Excel and LibreOffice Calc
The following functions are available in both Microsoft Excel and LibreOffice Calc.
| ABS | ABS - The absolute value or a number without its sign. |
| ACCRINT | ACCRINT - The accrued interest for a security that pays interest periodically. |
| ACCRINTM | ACCRINTM - The accrued interest for a security that pays interest at maturity. |
| ACOS | ACOS - The angle in radians for a given cosine ratio. |
| ACOSH | ACOSH - The hyperbolic arc-cosine of a number. |
| ACOT | ACOT - The angle in radians for a given cotangent ratio. |
| ACOTH | ACOTH - The hyperbolic arc-cotangent of a number. |
| ADDRESS | ADDRESS - The cell reference given a row and column number. |
| AMORDEGRC | AMORDEGRC - The depreciation of an asset in a single period (declining-balance method). |
| AMORLINC | AMORLINC - The depreciation of an asset in a single period (linear method). |
| AND | AND - The boolean True or False depending on multiple conditions. |
| ARABIC | ARABIC - The number converted from roman to arabic. |
| AREAS | AREAS - The number of areas in a cell range or reference. |
| ASIN | ASIN - The angle in radians for a given sine ratio. |
| ASINH | ASINH - The hyperbolic arc-sine of a number. |
| ATAN | ATAN - The angle in radians for a given tangent ratio. |
| ATAN2 | ATAN2 - The arc-tangent of the given x and y co-ordinates. |
| ATANH | ATANH - The hyperbolic arc-tangent of a number. |
| AVEDEV | AVEDEV - The average deviation of the numerical values. |
| AVERAGE | AVERAGE - The arithmetic mean of the numerical values. |
| AVERAGEA | AVERAGEA - The arithmetic mean of the numerical values (including logical values and text). |
| BASE | BASE - The number converted into a text representation with the given base. |
| BESSELI | BESSELI - The Bessel function evaluated for purely imaginary arguments. |
| BESSELJ | BESSELJ - The modified Bessel function represented by J(x). |
| BESSELK | BESSELK - The modified Bessel function represented by K(x). |
| BESSELY | BESSELY - The modified Bessel function represented by Y(x). |
| BETADIST | BETADIST - (BETA.DIST) The cumulative probability function for a beta distribution (only cumulative). |
| BETAINV | BETAINV - (BETA.INV) The inverse of the probability distribution function for a beta distribution. |
| BIN2DEC | BIN2DEC - The number converted from binary to decimal. |
| BIN2HEX | BIN2HEX - The number converted from binary to hexadecimal. |
| BIN2OCT | BIN2OCT - The number converted from binary to octal. |
| BINOMDIST | BINOMDIST - (BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution. |
| CEILING | CEILING - (Compatibility) The number rounded to the nearest integer or multiple. |
| CELL | CELL - The text string indicating information about a cell. |
| CHAR | CHAR - The character with the corresponding ANSI/ASCII number. |
| CHIDIST | CHIDIST - (CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHIINV | CHIINV - (CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed). |
| CHITEST | CHITEST - (CHISQ.TEST) The probability value from a chi-squared distribution. |
| CHOOSE | CHOOSE - The value in a row (or column) based on an index number. |
| CLEAN | CLEAN - The text string with all the non-printable characters removed. |
| CODE | CODE - The ANSI/ASCII number for the first character in a text string. |
| COLUMN | COLUMN - The column number of a cell reference. |
| COLUMNS | COLUMNS - The number of columns in a cell range or reference. |
| COMBIN | COMBIN - The number of combinations for a given number of items (without repetition). |
| COMBINA | COMBINA - The number of combinations for a given number of items (with repetition). |
| COMPLEX | COMPLEX - The complex number given real and imaginary coefficients. |
| CONCATENATE | CONCATENATE - (CONCAT) The text string that is a concatenation of several strings. |
| CONFIDENCE | CONFIDENCE - (CONFIDENCE.NORM) The confidence interval for a population mean. |
| CONVERT | CONVERT - The number in one measurement system converted to another. |
| CORREL | CORREL - The correlation coefficient between two data sets. |
| COS | COS - The cosine ratio of an angle. |
| COSH | COSH - The hyperbolic cosine ratio of an angle. |
| COT | COT - The cotangent ratio of an angle. |
| COTH | COTH - The hyperbolic cotangent ratio of an angle. |
| COUNT | COUNT - The number of numerical values. |
| COUNTA | COUNTA - The number of numerical values (including logical values and text). |
| COUNTBLANK | COUNTBLANK - The number of empty cells. |
| COUNTIF | COUNTIF - (COUNTIFS) The number of numerical values that satisfies one condition. |
| COUPDAYBS | COUPDAYBS - The number of days between the previous coupon date and the settlement date. |
| COUPDAYS | COUPDAYS - The number of days between the coupon dates on either side of the settlement date. |
| COUPDAYSNC | COUPDAYSNC - The number of days between the settlement date and the next coupon date. |
| COUPNCD | COUPNCD - The next coupon date after the settlement date. |
| COUPNUM | COUPNUM - The number of coupons between the settlement date and the maturity date. |
| COUPPCD | COUPPCD - The previous coupon date before the settlement date. |
| COVAR | COVAR - (COVARIANCE.P) The covariance based on an entire population. |
| CRITBINOM | CRITBINOM - (BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). |
| CUMIPMT | CUMIPMT - The cumulative interest payment on a loan between two dates. |
| CUMPRINC | CUMPRINC - The cumulative principal paid on a loan between two dates. |
| DATE | DATE - The date as a date serial number given a year, month, day. |
| DATEVALUE | DATEVALUE - The date serial number given a date in text format. |
| DAVERAGE | DAVERAGE - The arithmetic mean of all the numbers in a column that satisfies multiple conditions. |
| DAY | DAY - The day as an integer given a date serial number. |
| DAYS | DAYS - The number of days between two dates. |
| DAYS360 | DAYS360 - The number of days between two dates, based on 30 day months. |
| DB | DB - The depreciation of an asset in a single period (declining balance method). |
| DCOUNT | DCOUNT - The number of numerical values in a column that satisfies multiple conditions. |
| DCOUNTA | DCOUNTA - The number of numerical values in a column that satisfies multiple conditions (including logical values and text). |
| DDB | DDB - The depreciation of an asset in a single period (double-declining balance method). |
| DEC2BIN | DEC2BIN - The number converted from decimal to binary. |
| DEC2HEX | DEC2HEX - The number converted from decimal to hexadecimal. |
| DEC2OCT | DEC2OCT - The number converted from decimal to octal. |
| DECIMAL | DECIMAL - The decimal number of a text representation of a number in a given base. |
| DEGREES | DEGREES - The number of degrees given a number of radians. |
| DELTA | DELTA - The numerical value indicating if two numbers are equal. |
| DEVSQ | DEVSQ - The sum of the squared deviations from the mean. |
| DGET | DGET - The single value in a column that satisfies multiple conditions. |
| DISC | DISC - The interest rate (or discount rate) for a security held to maturity. |
| DMAX | DMAX - The largest value in a column that satisfies multiple conditions. |
| DMIN | DMIN - The smallest value in a column that satisfies multiple conditions. |
| DOLLAR | DOLLAR - The text string of a number with the dollar formatting $0,000.00. |
| DOLLARDE | DOLLARDE - The dollar fraction expressed as a decimal. |
| DOLLARFR | DOLLARFR - The dollar decimal expressed as a fraction. |
| DPRODUCT | DPRODUCT - The product of the values in a column that satisfies multiple conditions. |
| DSTDEV | DSTDEV - The standard deviation of the values in a column that satisfies multiple conditions based on a sample. |
| DSTDEVP | DSTDEVP - The standard deviation of the values in a column that satisfies multiple conditions based on an entire population. |
| DSUM | DSUM - The total of the values in a column that satisfies multiple conditions. |
| DURATION | DURATION - The annual duration of a security that pays interest periodically. |
| DVAR | DVAR - The variance of the values in a column that satisfies multiple conditions based on a sample. |
| DVARP | DVARP - The variance of the values in a column that satisfies multiple conditions based on an entire population. |
| EDATE | EDATE - The date serial number that is a given number of months before or after a date. |
| EFFECT | EFFECT - The effective interest rate given a nominal interest rate and compounding frequency. |
| EOMONTH | EOMONTH - The date serial number of the last day of a month before or after a date. |
| ERF | ERF - The value of the error function integrated between two limits. |
| ERFC | ERFC - (ERFC.PRECISE) The complementary error function integrated between a limit and infinity. |
| EVEN | EVEN - The number rounded to the nearest even integer. |
| EXACT | EXACT - The boolean True or False based on whether two strings match exactly. |
| EXP | EXP - The exponential number raised to a particular power. |
| EXPONDIST | EXPONDIST - (EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution. |
| FACT | FACT - The factorial of a positive whole number. |
| FACTDOUBLE | FACTDOUBLE - The double factorial of a positive whole number. |
| FALSE | FALSE - (Compatibility) The logical value False. |
| FDIST | FDIST - (F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative). |
| FILTER | FILTER - The array after filtering data that satisfies multiple conditions. |
| FIND | FIND - The starting position of a substring within a larger text string (case sensitive). |
| FINV | FINV - (F.INV) The inverse of the probability distribution function for an f distribution (left tailed). |
| FISHER | FISHER - The fisher transformation. |
| FISHERINV | FISHERINV - The inverse of the fisher transformation. |
| FIXED | FIXED - The text string of a number rounded to a fixed number of decimal places. |
| FLOOR | FLOOR - (Compatibility) The number rounded to the nearest integer or multiple. |
| FORECAST | FORECAST - (FORECAST.LINEAR) The future y-value along a linear trend using existing values. |
| FREQUENCY | FREQUENCY - The number of times a particular value occurs. |
| FTEST | FTEST - (F.TEST) The probability value from an f distribution. |
| FV | FV - The future value of a series of equal cash flows at regular intervals. |
| FVSCHEDULE | FVSCHEDULE - The future value of an initial principal after applying different compound interest rates. |
| GAMMADIST | GAMMADIST - (GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution. |
| GAMMAINV | GAMMAINV - (GAMMA.INV) The inverse of the probability distribution for a gamma distribution. |
| GAMMALN | GAMMALN - (GAMMALN.PRECISE) The natural logarithm of the gamma function. |
| GAUSS | GAUSS - The 0.5 less than the standard normal cumulative distribution. |
| GCD | GCD - The greatest common divisor of two or more numbers. |
| GEOMEAN | GEOMEAN - The geometric mean of an array of numbers. |
| GESTEP | GESTEP - The value True or False depending if the number is greater than a threshold value. |
| GROWTH | GROWTH - The predicted exponential growth using existing data. |
| HARMEAN | HARMEAN - The harmonic mean of a data set. |
| HEX2BIN | HEX2BIN - The number converted from hexadecimal to binary. |
| HEX2DEC | HEX2DEC - The number converted from hexadecimal to decimal. |
| HEX2OCT | HEX2OCT - The number converted from hexadecimal to octal. |
| HLOOKUP | HLOOKUP - (XLOOKUP) The value in the same column after finding a matching value in the first row. |
| HOUR | HOUR - The hour as an integer given a date serial number. |
| HYPERLINK | HYPERLINK - The hyperlink linked to a cell, document or webpage. |
| HYPGEOMDIST | HYPGEOMDIST - (HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only cumulative). |
| IF | IF - The value based on whether a condition is True or False. |
| IMABS | IMABS - The absolute value of a complex number. |
| IMAGINARY | IMAGINARY - The imaginary coefficient of a complex number. |
| IMARGUMENT | IMARGUMENT - The theta argument in radians. |
| IMCONJUGATE | IMCONJUGATE - The complex conjugate of a complex number. |
| IMCOS | IMCOS - The cosine ratio of a complex number. |
| IMDIV | IMDIV - The quotient of two complex numbers. |
| IMEXP | IMEXP - The exponential of a complex number. |
| IMLN | IMLN - The natural logarithm of a complex number. |
| IMLOG10 | IMLOG10 - The base-10 logarithm of a complex number. |
| IMLOG2 | IMLOG2 - The base-2 logarithm of a complex number. |
| IMPOWER | IMPOWER - The complex number raised to an integer number. |
| IMPRODUCT | IMPRODUCT - The product of two or more complex numbers. |
| IMREAL | IMREAL - The real coefficient of a complex number. |
| IMSIN | IMSIN - The sine ratio of a complex number. |
| IMSQRT | IMSQRT - The square root of a complex number. |
| IMSUB | IMSUB - The difference of two complex numbers. |
| IMSUM | IMSUM - The sum of two or more complex numbers. |
| INDEX | INDEX - The value from a cell range which is the intersection of a row AND a column. |
| INDIRECT | INDIRECT - The value of a given cell reference specified by a text string. |
| INT | INT - The number rounded down to the nearest integer. |
| INTERCEPT | INTERCEPT - The intersection with the y-axis using a linear regression plotted through known values. |
| INTRATE | INTRATE - The interest rate for a security held to maturity. |
| IPMT | IPMT - The interest payment amount paid on a given period on a loan with fixed interest. |
| IRR | IRR - The interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate). |
| ISBLANK | ISBLANK - The boolean True or False depending if the value is blank. |
| ISERR | ISERR - The boolean True or False depending if the value is an error (excluding #N/A). |
| ISERROR | ISERROR - The boolean True or False depending if the value is an error. |
| ISEVEN | ISEVEN - The boolean True or False depending if the value is an even number. |
| ISFORMULA | ISFORMULA - The boolean True or False depending if the cell contains a formula. |
| ISLOGICAL | ISLOGICAL - The boolean True or False depending if the value is True or False. |
| ISNA | ISNA - The boolean True or False depending if the value is #N/A. |
| ISNONTEXT | ISNONTEXT - The boolean True or False depending if the value is non text. |
| ISNUMBER | ISNUMBER - The boolean True or False depending if the value is a number. |
| ISODD | ISODD - The boolean True or False depending if the value is an odd number. |
| ISPMT | ISPMT - (IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly). |
| ISREF | ISREF - The boolean True or False depending if the value is a cell reference. |
| ISTEXT | ISTEXT - The boolean True or False depending if the value is text. |
| KURT | KURT - The kurtosis for a list or array of numbers. |
| LARGE | LARGE - The kth largest numerical value. |
| LCM | LCM - The least common multiple of two or more numbers. |
| LEFT | LEFT - The first or left most characters in a text string. |
| LEN | LEN - The number of characters in a text string. |
| LET | LET - The result of a formula that can use variables. |
| LINEST | LINEST - The array of values for a straight line that best fits your data. |
| LN | LN - The natural logarithm of a number (to the base e). |
| LOG | LOG - The logarithm of a number to any base. |
| LOG10 | LOG10 - The logarithm of a number to the base 10. |
| LOGEST | LOGEST - The array of values for an exponential curve that best fits your data. |
| LOGINV | LOGINV - (LOGNORM.INV) The inverse of the probability distribution function for a lognormal distribution. |
| LOGNORMDIST | LOGNORMDIST - (LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative). |
| LOWER | LOWER - The text string with all the characters converted to lowercase. |
| MATCH | MATCH - (XMATCH) The position of a value in a list, table or cell range. |
| MAX | MAX - The largest numerical value. |
| MAXA | MAXA - The largest numerical value (including logical values and text). |
| MDETERM | MDETERM - The matrix determinant of an array. |
| MDURATION | MDURATION - The modified duration for a security that pays interest periodically. |
| MEDIAN | MEDIAN - The number in the middle of a set of numbers. |
| MID | MID - The characters from the middle of a text string. |
| MIN | MIN - The smallest numerical value. |
| MINA | MINA - The smallest numerical value (including logical values and text). |
| MINUTE | MINUTE - The minute as an integer given a date serial number. |
| MINVERSE | MINVERSE - The inverse matrix of an array. |
| MIRR | MIRR - The interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate). |
| MMULT | MMULT - The matrix product of two arrays. |
| MOD | MOD - The remainder after division. |
| MODE | MODE - (MODE.SNGL) The first number that appears the most often in a set. |
| MONTH | MONTH - The month as an integer given a date serial number. |
| MROUND | MROUND - The number rounded to the nearest multiple. |
| MULTINOMIAL | MULTINOMIAL - The number of permutations for a given number of items (with duplicates). |
| MUNIT | MUNIT - The unit matrix or the specified dimension. |
| N | N - The value converted to a number. |
| NA | NA - The error value #N/A. |
| NEGBINOMDIST | NEGBINOMDIST - (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative). |
| NETWORKDAYS | NETWORKDAYS - (NETWORKDAYS.INTL) The number of working days between two dates excluding weekends and holidays. |
| NOMINAL | NOMINAL - The nominal interest rate over a period given an annual interest rate. |
| NORMDIST | NORMDIST - (NORM.DIST) The probability distribution function OR the cumulative probability function for a normal distribution. |
| NORMINV | NORMINV - (NORM.INV) The inverse of the probability distribution function for a normal distribution. |
| NORMSDIST | NORMSDIST - (NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative). |
| NORMSINV | NORMSINV - (NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution. |
| NOT | NOT - The opposite of a True or False value. |
| NOW | NOW - The date serial number of the current system date and time. |
| NPER | NPER - The number of periods for an investment. |
| NPV | NPV - The net present value of a series of unequal cash flows at regular intervals. |
| OCT2BIN | OCT2BIN - The number converted from octal to binary. |
| OCT2DEC | OCT2DEC - The number converted from octal to decimal. |
| OCT2HEX | OCT2HEX - The number converted from octal to hexadecimal. |
| ODD | ODD - The number rounded to the nearest odd integer. |
| ODDFPRICE | ODDFPRICE - The price per $100 face value of a security with an odd first period. |
| ODDFYIELD | ODDFYIELD - The yield of a security with an odd first period. |
| ODDLPRICE | ODDLPRICE - The price per $100 face value of a security with an odd last period. |
| ODDLYIELD | ODDLYIELD - The yield of a security with an odd last period. |
| OFFSET | OFFSET - The value in a cell which is an offset from another cell. |
| OR | OR - The boolean True or False depending on multiple conditions. |
| PEARSON | PEARSON - The pearson product moment correlation coefficient. |
| PERCENTILE | PERCENTILE - (PERCENTILE.INC) The value from a data set that corresponds to a particular percentage (inclusive). |
| PERCENTRANK | PERCENTRANK - (PERCENTRANK.INC) The rank of a value as a percentage (inclusive). |
| PERMUT | PERMUT - The number of permutations for a subset of objects or events (without repetition). |
| PERMUTATIONA | PERMUTATIONA - The number of permutations for a subset of objects or events (with repetition). |
| PHI | PHI - The value of the density function for a standard normal distribution. |
| PI | PI - The mathematical number PI (3.141592). |
| PMT | PMT - The full payment amount (principal + interest) paid every period on a loan with fixed interest. |
| POISSON | POISSON - (POISSON.DIST) The probability distribution function OR the cumulative probability function for a poisson distribution. |
| POWER | POWER - The number raised to a given power. |
| PPMT | PPMT - The principal amount paid on a given period on a loan with fixed interest. |
| PRICE | PRICE - The price of a security that pays periodic interest. |
| PRICEDISC | PRICEDISC - The price of a discounted security (no interest payments). |
| PRICEMAT | PRICEMAT - The price of a security that pays interest at maturity. |
| PROB | PROB - The probability that the values in a data set are greater than a lower limit and less than an upper limit. |
| PRODUCT | PRODUCT - The product of all the numerical values. |
| PROPER | PROPER - The text string with the first letter of every word as a capital letter. |
| PV | PV - The present value of a series of equal cash flows at regular intervals. |
| QUARTILE | QUARTILE - (QUARTILE.INC) The quartile of a data set (inclusive). |
| QUOTIENT | QUOTIENT - The integer portion after division. |
| RADIANS | RADIANS - The number of radians given the number of degrees. |
| RAND | RAND - The random number between zero and one (>=0 and <1). |
| RANDARRAY | RANDARRAY - The array of random numbers between two values (>=min and |
| RANDBETWEEN | RANDBETWEEN - The random integer between two values (>=bottom and <=top). |
| RANK | RANK - (RANK.EQ) The rank of a value in descending order (equal ranking). |
| RATE | RATE - The interest rate for a series of equal cash flows at regular intervals. |
| RECEIVED | RECEIVED - The amount received at the end when a security is held to maturity. |
| REPLACE | REPLACE - The text string after replacing characters in a specific location. |
| REPT | REPT - The text string repeated a number of times. |
| RIGHT | RIGHT - The last or rightmost characters in a text string. |
| ROMAN | ROMAN - The text string converting a binary number to a roman numeral. |
| ROUND | ROUND - The number rounded to a certain number of decimal places. |
| ROUNDDOWN | ROUNDDOWN - The number rounded towards zero to a certain number of decimal places. |
| ROUNDUP | ROUNDUP - The number rounded away from zero to a certain number of decimal places. |
| ROW | ROW - The row number of a cell reference. |
| ROWS | ROWS - The number of rows in a cell range or reference. |
| RRI | RRI - The equivalent interest rate for the growth of an investment. |
| RSQ | RSQ - The square of pearson product moment correlation coefficient through data points in known y's and known x's. |
| SEARCH | SEARCH - The starting position of a substring within a larger text string (not case sensitive). |
| SECOND | SECOND - The number of seconds as an integer given a date serial number. |
| SERIESSUM | SERIESSUM - The sum of a power series based on a formula. |
| SEQUENCE | SEQUENCE - The array of sequential numbers. |
| SHEET | SHEET - The sheet number of the referenced sheet. |
| SHEETS | SHEETS - The number of sheets in a reference. |
| SIGN | SIGN - The numerical value indicating if a number is positive, negative or zero. |
| SIN | SIN - The sine ratio of an angle. |
| SINH | SINH - The hyperbolic sine ratio of an angle. |
| SKEW | SKEW - The number representing the skewness of a distribution based on a sample. |
| SLN | SLN - The depreciation of an asset in a single period (straight-line method). |
| SLOPE | SLOPE - The slope of a linear regression line through the given data points. |
| SMALL | SMALL - The kth smallest numerical value. |
| SORT | SORT - The array of data that has been sorted by one column. |
| SORTBY | SORTBY - The array of data that has been sorted based on multiple columns. |
| SQRT | SQRT - The positive square root of a number. |
| SQRTPI | SQRTPI - The square root of a number multiplied by PI. |
| STANDARDIZE | STANDARDIZE - The normalized value from a distributed characterised by a mean and a standard deviation. |
| STDEV | STDEV - (STDEV.S) The standard deviation based on a sample. |
| STDEVA | STDEVA - The standard deviation based on a sample (including logical values and text). |
| STDEVP | STDEVP - (STDEV.P) The standard deviation based on an entire population. |
| STDEVPA | STDEVPA - The standard deviation based on an entire population (including logical values and text). |
| STEYX | STEYX - The standard error of a regression. |
| SUBSTITUTE | SUBSTITUTE - The text string after replacing instances of a substring. |
| SUBTOTAL | SUBTOTAL - (AGGREGATE) The choice of 11 different operations for numerical values. |
| SUM | SUM - The total of the numerical values. |
| SUMIF | SUMIF - (SUMIFS) The total of the numerical values that satisfies one condition. |
| SUMPRODUCT | SUMPRODUCT - The sum of the product of one or more arrays of values. |
| SUMSQ | SUMSQ - The variation of a data set from its mean. |
| SUMX2MY2 | SUMX2MY2 - The sum of the difference of squares of corresponding values in two arrays. |
| SUMX2PY2 | SUMX2PY2 - The sum of the sum of squares of corresponding values in two arrays. |
| SUMXMY2 | SUMXMY2 - The sum of squares of differences of corresponding values in two arrays. |
| SYD | SYD - The depreciation of an asset in a single period (sum-of-years digits method). |
| T | T - The argument as a text string when the value is text. |
| TAN | TAN - The tangent ratio of an angle. |
| TANH | TANH - The hyperbolic tangent ratio of an angle. |
| TBILLEQ | TBILLEQ - The yield (bond-equivalent) for a treasury bill. |
| TBILLPRICE | TBILLPRICE - The price per $100 face value for a treasury bill. |
| TBILLYIELD | TBILLYIELD - The yield for a treasury bill. |
| TDIST | TDIST - (T.DIST.2T) The percentage points probability for the t distribution. |
| TEXT | TEXT - The number as a formatted text string. |
| TIME | TIME - The time as a decimal given an hour, minute, second. |
| TIMEVALUE | TIMEVALUE - The time as a decimal given a time in text format. |
| TINV | TINV - (T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom. |
| TODAY | TODAY - The date serial number representing today's date. |
| TRANSPOSE | TRANSPOSE - The array with its orientation changed. |
| TREND | TREND - The y-values along a linear trend given a set of x-values. |
| TRIM | TRIM - The text string with all extra spaces removed from the beginning, middle and end. |
| TRIMMEAN | TRIMMEAN - The mean of the interior of a data set. |
| TRUE | TRUE - (Compatibility) The logical value True. |
| TRUNC | TRUNC - The number rounded towards zero and truncated to a certain number of decimal places or digits. |
| TTEST | TTEST - (T.TEST) The probability value from a t distribution. |
| TYPE | TYPE - The number indicating the data type of the value. |
| UPPER | UPPER - The text string with all the characters converted to uppercase. |
| UNIQUE | UNIQUE - The array of unique values in a list, table or cell range. |
| VALUE | VALUE - (NUMBERVALUE) The number that a text string represents (renamed). |
| VAR | VAR - (VAR.S) The variance based on a sample. |
| VARA | VARA - The variance based on a sample (including logical values and text). |
| VARP | VARP - (VAR.P) The variance based on an entire population. |
| VARPA | VARPA - The variance based on an entire population (including logical values and text). |
| VDB | VDB - The depreciation of an asset in a single period (variable-declining balance method). |
| VLOOKUP | VLOOKUP - (XLOOKUP) The value in the same row after finding a matching value in the first column. |
| WEEKDAY | WEEKDAY - The day of the week for a given date. |
| WEEKNUM | WEEKNUM - The week number in the year for a given date (based on US convention). |
| WEIBULL | WEIBULL - (WEIBULL.DIST) The probability distribution function OR the cumulative probability function for a weibull distribution. |
| WORKDAY | WORKDAY - (WORKDAY.INTL) The date serial number that is a given number of working days before or after a date. |
| XIRR | XIRR - The interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate). |
| XLOOKUP | XLOOKUP - The value in the same row after finding a matching value in any column. |
| XMATCH | XMATCH - The position of a value in a list, table or cell range. |
| XNPV | XNPV - The net present value of a series of unequal cash flows at irregular intervals. |
| YEAR | YEAR - The year as an integer given a date serial number. |
| YEARFRAC | YEARFRAC - The number of years as a decimal between two dates. |
| YIELD | YIELD - The interest rate (or yield) for a series of equal cash flows at regular intervals. |
| YIELDDISC | YIELDDISC - The interest rate (or yield) for a discounted security (no interest payments). |
| YIELDMAT | YIELDMAT - The interest rate (or yield) for a security that pays interest at maturity. |
| ZTEST | ZTEST - (Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
| ABS ABS - The absolute value or a number without its sign. |
| ACCRINT ACCRINT - The accrued interest for a security that pays interest periodically. |
| ACCRINTM ACCRINTM - The accrued interest for a security that pays interest at maturity. |
| ACOS ACOS - The angle in radians for a given cosine ratio. |
| ACOSH ACOSH - The hyperbolic arc-cosine of a number. |
| ACOT ACOT - The angle in radians for a given cotangent ratio. |
| ACOTH ACOTH - The hyperbolic arc-cotangent of a number. |
| ADDRESS ADDRESS - The cell reference given a row and column number. |
| AMORDEGRC AMORDEGRC - The depreciation of an asset in a single period (declining-balance method). |
| AMORLINC AMORLINC - The depreciation of an asset in a single period (linear method). |
| AND AND - The boolean True or False depending on multiple conditions. |
| ARABIC ARABIC - The number converted from roman to arabic. |
| AREAS AREAS - The number of areas in a cell range or reference. |
| ASIN ASIN - The angle in radians for a given sine ratio. |
| ASINH ASINH - The hyperbolic arc-sine of a number. |
| ATAN ATAN - The angle in radians for a given tangent ratio. |
| ATAN2 ATAN2 - The arc-tangent of the given x and y co-ordinates. |
| ATANH ATANH - The hyperbolic arc-tangent of a number. |
| AVEDEV AVEDEV - The average deviation of the numerical values. |
| AVERAGE AVERAGE - The arithmetic mean of the numerical values. |
| AVERAGEA AVERAGEA - The arithmetic mean of the numerical values (including logical values and text). |
| BASE BASE - The number converted into a text representation with the given base. |
| BESSELI BESSELI - The Bessel function evaluated for purely imaginary arguments. |
| BESSELJ BESSELJ - The modified Bessel function represented by J(x). |
| BESSELK BESSELK - The modified Bessel function represented by K(x). |
| BESSELY BESSELY - The modified Bessel function represented by Y(x). |
| BETADIST BETADIST - (BETA.DIST) The cumulative probability function for a beta distribution (only cumulative). |
| BETAINV BETAINV - (BETA.INV) The inverse of the probability distribution function for a beta distribution. |
| BIN2DEC BIN2DEC - The number converted from binary to decimal. |
| BIN2HEX BIN2HEX - The number converted from binary to hexadecimal. |
| BIN2OCT BIN2OCT - The number converted from binary to octal. |
| BINOMDIST BINOMDIST - (BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution. |
| CEILING CEILING - (Compatibility) The number rounded to the nearest integer or multiple. |
| CELL CELL - The text string indicating information about a cell. |
| CHAR CHAR - The character with the corresponding ANSI/ASCII number. |
| CHIDIST CHIDIST - (CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHIINV CHIINV - (CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed). |
| CHITEST CHITEST - (CHISQ.TEST) The probability value from a chi-squared distribution. |
| CHOOSE CHOOSE - The value in a row (or column) based on an index number. |
| CLEAN CLEAN - The text string with all the non-printable characters removed. |
| CODE CODE - The ANSI/ASCII number for the first character in a text string. |
| COLUMN COLUMN - The column number of a cell reference. |
| COLUMNS COLUMNS - The number of columns in a cell range or reference. |
| COMBIN COMBIN - The number of combinations for a given number of items (without repetition). |
| COMBINA COMBINA - The number of combinations for a given number of items (with repetition). |
| COMPLEX COMPLEX - The complex number given real and imaginary coefficients. |
| CONCATENATE CONCATENATE - (CONCAT) The text string that is a concatenation of several strings. |
| CONFIDENCE CONFIDENCE - (CONFIDENCE.NORM) The confidence interval for a population mean. |
| CONVERT CONVERT - The number in one measurement system converted to another. |
| CORREL CORREL - The correlation coefficient between two data sets. |
| COS COS - The cosine ratio of an angle. |
| COSH COSH - The hyperbolic cosine ratio of an angle. |
| COT COT - The cotangent ratio of an angle. |
| COTH COTH - The hyperbolic cotangent ratio of an angle. |
| COUNT COUNT - The number of numerical values. |
| COUNTA COUNTA - The number of numerical values (including logical values and text). |
| COUNTBLANK COUNTBLANK - The number of empty cells. |
| COUNTIF COUNTIF - (COUNTIFS) The number of numerical values that satisfies one condition. |
| COUPDAYBS COUPDAYBS - The number of days between the previous coupon date and the settlement date. |
| COUPDAYS COUPDAYS - The number of days between the coupon dates on either side of the settlement date. |
| COUPDAYSNC COUPDAYSNC - The number of days between the settlement date and the next coupon date. |
| COUPNCD COUPNCD - The next coupon date after the settlement date. |
| COUPNUM COUPNUM - The number of coupons between the settlement date and the maturity date. |
| COUPPCD COUPPCD - The previous coupon date before the settlement date. |
| COVAR COVAR - (COVARIANCE.P) The covariance based on an entire population. |
| CRITBINOM CRITBINOM - (BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). |
| CUMIPMT CUMIPMT - The cumulative interest payment on a loan between two dates. |
| CUMPRINC CUMPRINC - The cumulative principal paid on a loan between two dates. |
| DATE DATE - The date as a date serial number given a year, month, day. |
| DATEVALUE DATEVALUE - The date serial number given a date in text format. |
| DAVERAGE DAVERAGE - The arithmetic mean of all the numbers in a column that satisfies multiple conditions. |
| DAY DAY - The day as an integer given a date serial number. |
| DAYS DAYS - The number of days between two dates. |
| DAYS360 DAYS360 - The number of days between two dates, based on 30 day months. |
| DB DB - The depreciation of an asset in a single period (declining balance method). |
| DCOUNT DCOUNT - The number of numerical values in a column that satisfies multiple conditions. |
| DCOUNTA DCOUNTA - The number of numerical values in a column that satisfies multiple conditions (including logical values and text). |
| DDB DDB - The depreciation of an asset in a single period (double-declining balance method). |
| DEC2BIN DEC2BIN - The number converted from decimal to binary. |
| DEC2HEX DEC2HEX - The number converted from decimal to hexadecimal. |
| DEC2OCT DEC2OCT - The number converted from decimal to octal. |
| DECIMAL DECIMAL - The decimal number of a text representation of a number in a given base. |
| DEGREES DEGREES - The number of degrees given a number of radians. |
| DELTA DELTA - The numerical value indicating if two numbers are equal. |
| DEVSQ DEVSQ - The sum of the squared deviations from the mean. |
| DGET DGET - The single value in a column that satisfies multiple conditions. |
| DISC DISC - The interest rate (or discount rate) for a security held to maturity. |
| DMAX DMAX - The largest value in a column that satisfies multiple conditions. |
| DMIN DMIN - The smallest value in a column that satisfies multiple conditions. |
| DOLLAR DOLLAR - The text string of a number with the dollar formatting $0,000.00. |
| DOLLARDE DOLLARDE - The dollar fraction expressed as a decimal. |
| DOLLARFR DOLLARFR - The dollar decimal expressed as a fraction. |
| DPRODUCT DPRODUCT - The product of the values in a column that satisfies multiple conditions. |
| DSTDEV DSTDEV - The standard deviation of the values in a column that satisfies multiple conditions based on a sample. |
| DSTDEVP DSTDEVP - The standard deviation of the values in a column that satisfies multiple conditions based on an entire population. |
| DSUM DSUM - The total of the values in a column that satisfies multiple conditions. |
| DURATION DURATION - The annual duration of a security that pays interest periodically. |
| DVAR DVAR - The variance of the values in a column that satisfies multiple conditions based on a sample. |
| DVARP DVARP - The variance of the values in a column that satisfies multiple conditions based on an entire population. |
| EDATE EDATE - The date serial number that is a given number of months before or after a date. |
| EFFECT EFFECT - The effective interest rate given a nominal interest rate and compounding frequency. |
| EOMONTH EOMONTH - The date serial number of the last day of a month before or after a date. |
| ERF ERF - The value of the error function integrated between two limits. |
| ERFC ERFC - (ERFC.PRECISE) The complementary error function integrated between a limit and infinity. |
| EVEN EVEN - The number rounded to the nearest even integer. |
| EXACT EXACT - The boolean True or False based on whether two strings match exactly. |
| EXP EXP - The exponential number raised to a particular power. |
| EXPONDIST EXPONDIST - (EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution. |
| FACT FACT - The factorial of a positive whole number. |
| FACTDOUBLE FACTDOUBLE - The double factorial of a positive whole number. |
| FALSE FALSE - (Compatibility) The logical value False. |
| FDIST FDIST - (F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative). |
| FILTER FILTER - The array after filtering data that satisfies multiple conditions. |
| FIND FIND - The starting position of a substring within a larger text string (case sensitive). |
| FINV FINV - (F.INV) The inverse of the probability distribution function for an f distribution (left tailed). |
| FISHER FISHER - The fisher transformation. |
| FISHERINV FISHERINV - The inverse of the fisher transformation. |
| FIXED FIXED - The text string of a number rounded to a fixed number of decimal places. |
| FLOOR FLOOR - (Compatibility) The number rounded to the nearest integer or multiple. |
| FORECAST FORECAST - (FORECAST.LINEAR) The future y-value along a linear trend using existing values. |
| FREQUENCY FREQUENCY - The number of times a particular value occurs. |
| FTEST FTEST - (F.TEST) The probability value from an f distribution. |
| FV FV - The future value of a series of equal cash flows at regular intervals. |
| FVSCHEDULE FVSCHEDULE - The future value of an initial principal after applying different compound interest rates. |
| GAMMADIST GAMMADIST - (GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution. |
| GAMMAINV GAMMAINV - (GAMMA.INV) The inverse of the probability distribution for a gamma distribution. |
| GAMMALN GAMMALN - (GAMMALN.PRECISE) The natural logarithm of the gamma function. |
| GAUSS GAUSS - The 0.5 less than the standard normal cumulative distribution. |
| GCD GCD - The greatest common divisor of two or more numbers. |
| GEOMEAN GEOMEAN - The geometric mean of an array of numbers. |
| GESTEP GESTEP - The value True or False depending if the number is greater than a threshold value. |
| GROWTH GROWTH - The predicted exponential growth using existing data. |
| HARMEAN HARMEAN - The harmonic mean of a data set. |
| HEX2BIN HEX2BIN - The number converted from hexadecimal to binary. |
| HEX2DEC HEX2DEC - The number converted from hexadecimal to decimal. |
| HEX2OCT HEX2OCT - The number converted from hexadecimal to octal. |
| HLOOKUP HLOOKUP - (XLOOKUP) The value in the same column after finding a matching value in the first row. |
| HOUR HOUR - The hour as an integer given a date serial number. |
| HYPERLINK HYPERLINK - The hyperlink linked to a cell, document or webpage. |
| HYPGEOMDIST HYPGEOMDIST - (HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only cumulative). |
| IF IF - The value based on whether a condition is True or False. |
| IMABS IMABS - The absolute value of a complex number. |
| IMAGINARY IMAGINARY - The imaginary coefficient of a complex number. |
| IMARGUMENT IMARGUMENT - The theta argument in radians. |
| IMCONJUGATE IMCONJUGATE - The complex conjugate of a complex number. |
| IMCOS IMCOS - The cosine ratio of a complex number. |
| IMDIV IMDIV - The quotient of two complex numbers. |
| IMEXP IMEXP - The exponential of a complex number. |
| IMLN IMLN - The natural logarithm of a complex number. |
| IMLOG10 IMLOG10 - The base-10 logarithm of a complex number. |
| IMLOG2 IMLOG2 - The base-2 logarithm of a complex number. |
| IMPOWER IMPOWER - The complex number raised to an integer number. |
| IMPRODUCT IMPRODUCT - The product of two or more complex numbers. |
| IMREAL IMREAL - The real coefficient of a complex number. |
| IMSIN IMSIN - The sine ratio of a complex number. |
| IMSQRT IMSQRT - The square root of a complex number. |
| IMSUB IMSUB - The difference of two complex numbers. |
| IMSUM IMSUM - The sum of two or more complex numbers. |
| INDEX INDEX - The value from a cell range which is the intersection of a row AND a column. |
| INDIRECT INDIRECT - The value of a given cell reference specified by a text string. |
| INT INT - The number rounded down to the nearest integer. |
| INTERCEPT INTERCEPT - The intersection with the y-axis using a linear regression plotted through known values. |
| INTRATE INTRATE - The interest rate for a security held to maturity. |
| IPMT IPMT - The interest payment amount paid on a given period on a loan with fixed interest. |
| IRR IRR - The interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate). |
| ISBLANK ISBLANK - The boolean True or False depending if the value is blank. |
| ISERR ISERR - The boolean True or False depending if the value is an error (excluding #N/A). |
| ISERROR ISERROR - The boolean True or False depending if the value is an error. |
| ISEVEN ISEVEN - The boolean True or False depending if the value is an even number. |
| ISFORMULA ISFORMULA - The boolean True or False depending if the cell contains a formula. |
| ISLOGICAL ISLOGICAL - The boolean True or False depending if the value is True or False. |
| ISNA ISNA - The boolean True or False depending if the value is #N/A. |
| ISNONTEXT ISNONTEXT - The boolean True or False depending if the value is non text. |
| ISNUMBER ISNUMBER - The boolean True or False depending if the value is a number. |
| ISODD ISODD - The boolean True or False depending if the value is an odd number. |
| ISPMT ISPMT - (IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly). |
| ISREF ISREF - The boolean True or False depending if the value is a cell reference. |
| ISTEXT ISTEXT - The boolean True or False depending if the value is text. |
| KURT KURT - The kurtosis for a list or array of numbers. |
| LARGE LARGE - The kth largest numerical value. |
| LCM LCM - The least common multiple of two or more numbers. |
| LEFT LEFT - The first or left most characters in a text string. |
| LEN LEN - The number of characters in a text string. |
| LET LET - The result of a formula that can use variables. |
| LINEST LINEST - The array of values for a straight line that best fits your data. |
| LN LN - The natural logarithm of a number (to the base e). |
| LOG LOG - The logarithm of a number to any base. |
| LOG10 LOG10 - The logarithm of a number to the base 10. |
| LOGEST LOGEST - The array of values for an exponential curve that best fits your data. |
| LOGINV LOGINV - (LOGNORM.INV) The inverse of the probability distribution function for a lognormal distribution. |
| LOGNORMDIST LOGNORMDIST - (LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative). |
| LOWER LOWER - The text string with all the characters converted to lowercase. |
| MATCH MATCH - (XMATCH) The position of a value in a list, table or cell range. |
| MAX MAX - The largest numerical value. |
| MAXA MAXA - The largest numerical value (including logical values and text). |
| MDETERM MDETERM - The matrix determinant of an array. |
| MDURATION MDURATION - The modified duration for a security that pays interest periodically. |
| MEDIAN MEDIAN - The number in the middle of a set of numbers. |
| MID MID - The characters from the middle of a text string. |
| MIN MIN - The smallest numerical value. |
| MINA MINA - The smallest numerical value (including logical values and text). |
| MINUTE MINUTE - The minute as an integer given a date serial number. |
| MINVERSE MINVERSE - The inverse matrix of an array. |
| MIRR MIRR - The interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate). |
| MMULT MMULT - The matrix product of two arrays. |
| MOD MOD - The remainder after division. |
| MODE MODE - (MODE.SNGL) The first number that appears the most often in a set. |
| MONTH MONTH - The month as an integer given a date serial number. |
| MROUND MROUND - The number rounded to the nearest multiple. |
| MULTINOMIAL MULTINOMIAL - The number of permutations for a given number of items (with duplicates). |
| MUNIT MUNIT - The unit matrix or the specified dimension. |
| N N - The value converted to a number. |
| NA NA - The error value #N/A. |
| NEGBINOMDIST NEGBINOMDIST - (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative). |
| NETWORKDAYS NETWORKDAYS - (NETWORKDAYS.INTL) The number of working days between two dates excluding weekends and holidays. |
| NOMINAL NOMINAL - The nominal interest rate over a period given an annual interest rate. |
| NORMDIST NORMDIST - (NORM.DIST) The probability distribution function OR the cumulative probability function for a normal distribution. |
| NORMINV NORMINV - (NORM.INV) The inverse of the probability distribution function for a normal distribution. |
| NORMSDIST NORMSDIST - (NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative). |
| NORMSINV NORMSINV - (NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution. |
| NOT NOT - The opposite of a True or False value. |
| NOW NOW - The date serial number of the current system date and time. |
| NPER NPER - The number of periods for an investment. |
| NPV NPV - The net present value of a series of unequal cash flows at regular intervals. |
| OCT2BIN OCT2BIN - The number converted from octal to binary. |
| OCT2DEC OCT2DEC - The number converted from octal to decimal. |
| OCT2HEX OCT2HEX - The number converted from octal to hexadecimal. |
| ODD ODD - The number rounded to the nearest odd integer. |
| ODDFPRICE ODDFPRICE - The price per $100 face value of a security with an odd first period. |
| ODDFYIELD ODDFYIELD - The yield of a security with an odd first period. |
| ODDLPRICE ODDLPRICE - The price per $100 face value of a security with an odd last period. |
| ODDLYIELD ODDLYIELD - The yield of a security with an odd last period. |
| OFFSET OFFSET - The value in a cell which is an offset from another cell. |
| OR OR - The boolean True or False depending on multiple conditions. |
| PEARSON PEARSON - The pearson product moment correlation coefficient. |
| PERCENTILE PERCENTILE - (PERCENTILE.INC) The value from a data set that corresponds to a particular percentage (inclusive). |
| PERCENTRANK PERCENTRANK - (PERCENTRANK.INC) The rank of a value as a percentage (inclusive). |
| PERMUT PERMUT - The number of permutations for a subset of objects or events (without repetition). |
| PERMUTATIONA PERMUTATIONA - The number of permutations for a subset of objects or events (with repetition). |
| PHI PHI - The value of the density function for a standard normal distribution. |
| PI PI - The mathematical number PI (3.141592). |
| PMT PMT - The full payment amount (principal + interest) paid every period on a loan with fixed interest. |
| POISSON POISSON - (POISSON.DIST) The probability distribution function OR the cumulative probability function for a poisson distribution. |
| POWER POWER - The number raised to a given power. |
| PPMT PPMT - The principal amount paid on a given period on a loan with fixed interest. |
| PRICE PRICE - The price of a security that pays periodic interest. |
| PRICEDISC PRICEDISC - The price of a discounted security (no interest payments). |
| PRICEMAT PRICEMAT - The price of a security that pays interest at maturity. |
| PROB PROB - The probability that the values in a data set are greater than a lower limit and less than an upper limit. |
| PRODUCT PRODUCT - The product of all the numerical values. |
| PROPER PROPER - The text string with the first letter of every word as a capital letter. |
| PV PV - The present value of a series of equal cash flows at regular intervals. |
| QUARTILE QUARTILE - (QUARTILE.INC) The quartile of a data set (inclusive). |
| QUOTIENT QUOTIENT - The integer portion after division. |
| RADIANS RADIANS - The number of radians given the number of degrees. |
| RAND RAND - The random number between zero and one (>=0 and <1). |
| RANDARRAY RANDARRAY - The array of random numbers between two values (>=min and |
| RANDBETWEEN RANDBETWEEN - The random integer between two values (>=bottom and <=top). |
| RANK RANK - (RANK.EQ) The rank of a value in descending order (equal ranking). |
| RATE RATE - The interest rate for a series of equal cash flows at regular intervals. |
| RECEIVED RECEIVED - The amount received at the end when a security is held to maturity. |
| REPLACE REPLACE - The text string after replacing characters in a specific location. |
| REPT REPT - The text string repeated a number of times. |
| RIGHT RIGHT - The last or rightmost characters in a text string. |
| ROMAN ROMAN - The text string converting a binary number to a roman numeral. |
| ROUND ROUND - The number rounded to a certain number of decimal places. |
| ROUNDDOWN ROUNDDOWN - The number rounded towards zero to a certain number of decimal places. |
| ROUNDUP ROUNDUP - The number rounded away from zero to a certain number of decimal places. |
| ROW ROW - The row number of a cell reference. |
| ROWS ROWS - The number of rows in a cell range or reference. |
| RRI RRI - The equivalent interest rate for the growth of an investment. |
| RSQ RSQ - The square of pearson product moment correlation coefficient through data points in known y's and known x's. |
| SEARCH SEARCH - The starting position of a substring within a larger text string (not case sensitive). |
| SECOND SECOND - The number of seconds as an integer given a date serial number. |
| SERIESSUM SERIESSUM - The sum of a power series based on a formula. |
| SEQUENCE SEQUENCE - The array of sequential numbers. |
| SHEET SHEET - The sheet number of the referenced sheet. |
| SHEETS SHEETS - The number of sheets in a reference. |
| SIGN SIGN - The numerical value indicating if a number is positive, negative or zero. |
| SIN SIN - The sine ratio of an angle. |
| SINH SINH - The hyperbolic sine ratio of an angle. |
| SKEW SKEW - The number representing the skewness of a distribution based on a sample. |
| SLN SLN - The depreciation of an asset in a single period (straight-line method). |
| SLOPE SLOPE - The slope of a linear regression line through the given data points. |
| SMALL SMALL - The kth smallest numerical value. |
| SORT SORT - The array of data that has been sorted by one column. |
| SORTBY SORTBY - The array of data that has been sorted based on multiple columns. |
| SQRT SQRT - The positive square root of a number. |
| SQRTPI SQRTPI - The square root of a number multiplied by PI. |
| STANDARDIZE STANDARDIZE - The normalized value from a distributed characterised by a mean and a standard deviation. |
| STDEV STDEV - (STDEV.S) The standard deviation based on a sample. |
| STDEVA STDEVA - The standard deviation based on a sample (including logical values and text). |
| STDEVP STDEVP - (STDEV.P) The standard deviation based on an entire population. |
| STDEVPA STDEVPA - The standard deviation based on an entire population (including logical values and text). |
| STEYX STEYX - The standard error of a regression. |
| SUBSTITUTE SUBSTITUTE - The text string after replacing instances of a substring. |
| SUBTOTAL SUBTOTAL - (AGGREGATE) The choice of 11 different operations for numerical values. |
| SUM SUM - The total of the numerical values. |
| SUMIF SUMIF - (SUMIFS) The total of the numerical values that satisfies one condition. |
| SUMPRODUCT SUMPRODUCT - The sum of the product of one or more arrays of values. |
| SUMSQ SUMSQ - The variation of a data set from its mean. |
| SUMX2MY2 SUMX2MY2 - The sum of the difference of squares of corresponding values in two arrays. |
| SUMX2PY2 SUMX2PY2 - The sum of the sum of squares of corresponding values in two arrays. |
| SUMXMY2 SUMXMY2 - The sum of squares of differences of corresponding values in two arrays. |
| SYD SYD - The depreciation of an asset in a single period (sum-of-years digits method). |
| T T - The argument as a text string when the value is text. |
| TAN TAN - The tangent ratio of an angle. |
| TANH TANH - The hyperbolic tangent ratio of an angle. |
| TBILLEQ TBILLEQ - The yield (bond-equivalent) for a treasury bill. |
| TBILLPRICE TBILLPRICE - The price per $100 face value for a treasury bill. |
| TBILLYIELD TBILLYIELD - The yield for a treasury bill. |
| TDIST TDIST - (T.DIST.2T) The percentage points probability for the t distribution. |
| TEXT TEXT - The number as a formatted text string. |
| TIME TIME - The time as a decimal given an hour, minute, second. |
| TIMEVALUE TIMEVALUE - The time as a decimal given a time in text format. |
| TINV TINV - (T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom. |
| TODAY TODAY - The date serial number representing today's date. |
| TRANSPOSE TRANSPOSE - The array with its orientation changed. |
| TREND TREND - The y-values along a linear trend given a set of x-values. |
| TRIM TRIM - The text string with all extra spaces removed from the beginning, middle and end. |
| TRIMMEAN TRIMMEAN - The mean of the interior of a data set. |
| TRUE TRUE - (Compatibility) The logical value True. |
| TRUNC TRUNC - The number rounded towards zero and truncated to a certain number of decimal places or digits. |
| TTEST TTEST - (T.TEST) The probability value from a t distribution. |
| TYPE TYPE - The number indicating the data type of the value. |
| UPPER UPPER - The text string with all the characters converted to uppercase. |
| UNIQUE UNIQUE - The array of unique values in a list, table or cell range. |
| VALUE VALUE - (NUMBERVALUE) The number that a text string represents (renamed). |
| VAR VAR - (VAR.S) The variance based on a sample. |
| VARA VARA - The variance based on a sample (including logical values and text). |
| VARP VARP - (VAR.P) The variance based on an entire population. |
| VARPA VARPA - The variance based on an entire population (including logical values and text). |
| VDB VDB - The depreciation of an asset in a single period (variable-declining balance method). |
| VLOOKUP VLOOKUP - (XLOOKUP) The value in the same row after finding a matching value in the first column. |
| WEEKDAY WEEKDAY - The day of the week for a given date. |
| WEEKNUM WEEKNUM - The week number in the year for a given date (based on US convention). |
| WEIBULL WEIBULL - (WEIBULL.DIST) The probability distribution function OR the cumulative probability function for a weibull distribution. |
| WORKDAY WORKDAY - (WORKDAY.INTL) The date serial number that is a given number of working days before or after a date. |
| XIRR XIRR - The interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate). |
| XLOOKUP XLOOKUP - The value in the same row after finding a matching value in any column. |
| XMATCH XMATCH - The position of a value in a list, table or cell range. |
| XNPV XNPV - The net present value of a series of unequal cash flows at irregular intervals. |
| YEAR YEAR - The year as an integer given a date serial number. |
| YEARFRAC YEARFRAC - The number of years as a decimal between two dates. |
| YIELD YIELD - The interest rate (or yield) for a series of equal cash flows at regular intervals. |
| YIELDDISC YIELDDISC - The interest rate (or yield) for a discounted security (no interest payments). |
| YIELDMAT YIELDMAT - The interest rate (or yield) for a security that pays interest at maturity. |
| ZTEST ZTEST - (Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext