Excel and LibreOffice Calc
The following functions are available in both Microsoft Excel and LibreOffice Calc.
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. |
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. |
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). |
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). |
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. |
BINOMDIST | (BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution. |
CEILING | (Compatibility) 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). |
CHITEST | (CHISQ.TEST) The probability value from a chi-squared distribution. |
CHOOSE | The value in a row (or column) based on an index number. |
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. |
CONCATENATE | (CONCAT) The text string that is a concatenation of several strings. |
CONFIDENCE | (CONFIDENCE.NORM) The confidence interval for a population mean. |
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. |
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. |
CRITBINOM | (BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). |
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. |
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). |
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. |
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. |
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. |
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. |
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. |
ERFC | (ERFC.PRECISE) The complementary error function integrated between a limit and infinity. |
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. |
EXPONDIST | (EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential 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). |
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. |
FORECAST | (FORECAST.LINEAR) The future y-value along a linear trend using existing values. |
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. |
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. |
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. |
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. |
HYPERLINK | The hyperlink linked to a cell, document or webpage. |
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. |
IMABS | The absolute value of a complex number. |
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. |
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. |
IMSIN | The 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. |
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. |
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. |
ISODD | The boolean True or False depending if the value is an odd number. |
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. |
KURT | The kurtosis for a list or array of numbers. |
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. |
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. |
LOGNORMDIST | (LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative). |
LOWER | The text string with all the characters converted to lowercase. |
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). |
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). |
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. |
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. |
N | The value converted to a number. |
NA | The error value #N/A. |
NEGBINOMDIST | (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative). |
NETWORKDAYS | (NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays. |
NOMINAL | The nominal interest rate over a period given an annual interest rate. |
NORMDIST | (NORM.DIST) The probability distribution function OR the cumulative probability function for a normal distribution. |
NORMINV | (NORM.INV) The inverse of the probability distribution function for a normal distribution. |
NORMSDIST | (NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative). |
NORMSINV | (NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution. |
NOT | The opposite of a True or False value. |
NOW | The date serial number of the current system date and time. |
NPER | The number of periods for an investment. |
NPV | The net present value of a series of unequal cash flows at regular intervals. |
OCT2BIN | The number converted from octal to binary. |
OCT2DEC | The number converted from octal to decimal. |
OCT2HEX | The number converted from octal to hexadecimal. |
ODD | The number rounded up to the nearest odd integer. |
ODDFPRICE | The price per $100 face value of a security with an odd first period. |
ODDFYIELD | The yield of a security with an odd first period. |
ODDLPRICE | The price per $100 face value of a security with an odd last period. |
ODDLYIELD | The yield of a security with an odd last period. |
OFFSET | The value in a cell which is an offset from another cell. |
OR | The boolean True or False depending on multiple conditions. |
PEARSON | The pearson product moment correlation coefficient. |
PERCENTILE | (PERCENTILE.INC) The value from a data set that corresponds to a particular percentage (inclusive). |
PERCENTRANK | (PERCENTRANK.INC) The rank of a value as a percentage (inclusive). |
PERMUT | The number of permutations for a subset of objects or events. |
PERMUTATIONA | The number of permutations for a subset of objects or events (with repetition). |
PHI | The value of the density function for a standard normal distribution. |
PI | The number PI (3.141592). |
PMT | The full amount (principal + interest) paid every period on a loan with fixed interest. |
POISSON | (POISSON.DIST) The probability distribution function OR the cumulative probability function for a poisson distribution. |
POWER | The number raised to a given power. |
PPMT | The principal amount paid on a given period on a loan with fixed interest. |
PRICE | The price of a security that pays periodic interest. |
PRICEDISC | The price of a discounted security (no interest payments). |
PRICEMAT | The price of a security that pays interest at maturity. |
PROB | The probability that the values in a data set are greater than a lower limit and less than an upper limit. |
PRODUCT | The product of all the numerical values. |
PROPER | The text string with the first letter of every word as a capital letter. |
PV | The present value of a series of equal cash flows at regular intervals. |
QUARTILE | (QUARTILE.INC) The quartile of a data set (inclusive). |
QUOTIENT | The integer portion after division. |
RADIANS | The number of radians given the number of degrees. |
RAND | The random number between zero and one (>=0 and <1). |
RANDBETWEEN | The random integer between two values (>=bottom and <=top). |
RANK | (RANK.EQ) The rank of a value in descending order (equal ranking). |
RATE | The interest rate for a series of equal cash flows at regular intervals. |
RECEIVED | The amount received at the end when a security is held to maturity. |
REPLACE | The text string after replacing characters in a specific location. |
REPT | The text string repeated a number of times. |
RIGHT | The last or right most characters in a text string. |
ROMAN | The text string converting a binary number to a roman numeral. |
ROUND | The number rounded to a specified number of digits. |
ROUNDDOWN | The number rounded down to a specified number of digits. |
ROUNDUP | The number rounded up to a specified number of digits. |
ROW | The row number of a cell reference. |
ROWS | The number of rows in a cell range or reference. |
RRI | The equivalent interest rate for the growth of an investment. |
RSQ | The square of pearson product moment correlation coefficient through data points in known y's and known x's. |
SEARCH | The starting position of a substring within a larger text string (not case sensitive). |
SECOND | The number of seconds as an integer given a date serial number. |
SERIESSUM | The sum of a power series based on a formula. |
SHEET | The sheet number of the referenced sheet. |
SHEETS | The number of sheets in a reference. |
SIGN | The numerical value indicating if a number is positive or negative. |
SIN | The sine of a number. |
SINH | The hyperbolic sine of a number. |
SKEW | The number representing the skewness of a distribution based on a sample. |
SLN | The depreciation of an asset in a single period (straight-line method). |
SLOPE | The slope of a linear regression line through the given data points. |
SMALL | The kth smallest numerical value. |
SQRT | The positive square root of a number. |
SQRTPI | The square root of a number multiplied by PI. |
STANDARDIZE | The normalized value from a distributed characterised by a mean and a standard deviation. |
STDEV | (STDEV.S) The standard deviation based on a sample. |
STDEVA | The standard deviation based on a sample (including logical values and text). |
STDEVP | (STDEV.P) The standard deviation based on an entire population. |
STDEVPA | The standard deviation based on an entire population (including logical values and text). |
STEYX | The standard error of a regression. |
SUBSTITUTE | The text string after replacing instances of a substring. |
SUBTOTAL | (AGGREGATE) The choice of 11 different operations for numerical values (renamed). |
SUM | The total of the numerical values. |
SUMIF | (SUMIFS) The total of the numerical values that satisfies one condition. |
SUMPRODUCT | The sum of the product of one or more arrays of values. |
SUMSQ | The variation of a data set from its mean. |
SUMX2MY2 | The sum of the difference of squares of corresponding values in two arrays. |
SUMX2PY2 | The sum of the sum of squares of corresponding values in two arrays. |
SUMXMY2 | The sum of squares of differences of corresponding values in two arrays. |
SYD | The depreciation of an asset in a single period (sum-of-years digits method). |
T | The text string of the value given. |
TAN | The tangent of a number. |
TANH | The hyperbolic tangent of a number. |
TBILLEQ | The yield (bond-equivalent) for a treasury bill. |
TBILLPRICE | The price per $100 face value for a treasury bill. |
TBILLYIELD | The yield for a treasury bill. |
TDIST | (T.DIST.2T) The percentage points probability for the t distribution. |
TEXT | The number as a formatted text string. |
TIME | The time as a decimal given an hour, minute, second. |
TIMEVALUE | The time as a decimal given a time in text format. |
TINV | (T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom. |
TODAY | The date serial number representing today's date. |
TRANSPOSE | The array with its orientation changed. |
TREND | The y-values along a linear trend given a set of x-values. |
TRIM | The text string with all extra spaces removed from the beginning, middle and end. |
TRIMMEAN | The mean of the interior of a data set. |
TRUE | (Compatibility) The logical value True. |
TRUNC | The number with any decimal places removed. |
TTEST | (T.TEST) The probability value from a t distribution. |
TYPE | The number indicating the data type of the value. |
UPPER | The text string with all the characters converted to uppercase. |
VALUE | (NUMBERVALUE) The number that a text string represents (renamed). |
VAR | (VAR.S) The variance based on a sample. |
VARA | The variance based on a sample (including logical values and text). |
VARP | (VAR.P) The variance based on an entire population. |
VARPA | The variance based on an entire population (including logical values and text). |
VDB | The depreciation of an asset in a single period (variable declining balance method). |
VLOOKUP | (XLOOKUP) The value in the same row after finding a matching value in the first column. |
WEEKDAY | The day of the week for a given date. |
WEEKNUM | The week number in the year for a given date. |
WEIBULL | (WEIBULL.DIST) The probability distribution function OR the cumulative probability function for a weibull distribution. |
WORKDAY | (WORKDAY.INTL) The date serial number that is a given number of working days before or after a date. |
XIRR | The interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate). |
XNPV | The net present value of a series of unequal cash flows at irregular intervals. |
YEAR | The year as an integer given a date serial number. |
YEARFRAC | The number of years as a decimal between two dates. |
YIELD | The interest rate (annual) for a series of equal cash flows at regular intervals. |
YIELDDISC | The interest rate (annual) for a discounted security (no interest payments). |
YIELDMAT | The interest rate (annual) for a security that pays interest at maturity. |
ZTEST | (Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
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. |
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. |
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). |
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). |
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. |
BINOMDIST (BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution. |
CEILING (Compatibility) 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). |
CHITEST (CHISQ.TEST) The probability value from a chi-squared distribution. |
CHOOSE The value in a row (or column) based on an index number. |
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. |
CONCATENATE (CONCAT) The text string that is a concatenation of several strings. |
CONFIDENCE (CONFIDENCE.NORM) The confidence interval for a population mean. |
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. |
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. |
CRITBINOM (BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). |
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. |
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). |
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. |
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. |
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. |
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. |
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. |
ERFC (ERFC.PRECISE) The complementary error function integrated between a limit and infinity. |
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. |
EXPONDIST (EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential 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). |
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. |
FORECAST (FORECAST.LINEAR) The future y-value along a linear trend using existing values. |
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. |
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. |
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. |
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. |
HYPERLINK The hyperlink linked to a cell, document or webpage. |
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. |
IMABS The absolute value of a complex number. |
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. |
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. |
IMSIN The 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. |
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. |
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. |
ISODD The boolean True or False depending if the value is an odd number. |
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. |
KURT The kurtosis for a list or array of numbers. |
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. |
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. |
LOGNORMDIST (LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative). |
LOWER The text string with all the characters converted to lowercase. |
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). |
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). |
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. |
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. |
N The value converted to a number. |
NA The error value #N/A. |
NEGBINOMDIST (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative). |
NETWORKDAYS (NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays. |
NOMINAL The nominal interest rate over a period given an annual interest rate. |
NORMDIST (NORM.DIST) The probability distribution function OR the cumulative probability function for a normal distribution. |
NORMINV (NORM.INV) The inverse of the probability distribution function for a normal distribution. |
NORMSDIST (NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative). |
NORMSINV (NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution. |
NOT The opposite of a True or False value. |
NOW The date serial number of the current system date and time. |
NPER The number of periods for an investment. |
NPV The net present value of a series of unequal cash flows at regular intervals. |
OCT2BIN The number converted from octal to binary. |
OCT2DEC The number converted from octal to decimal. |
OCT2HEX The number converted from octal to hexadecimal. |
ODD The number rounded up to the nearest odd integer. |
ODDFPRICE The price per $100 face value of a security with an odd first period. |
ODDFYIELD The yield of a security with an odd first period. |
ODDLPRICE The price per $100 face value of a security with an odd last period. |
ODDLYIELD The yield of a security with an odd last period. |
OFFSET The value in a cell which is an offset from another cell. |
OR The boolean True or False depending on multiple conditions. |
PEARSON The pearson product moment correlation coefficient. |
PERCENTILE (PERCENTILE.INC) The value from a data set that corresponds to a particular percentage (inclusive). |
PERCENTRANK (PERCENTRANK.INC) The rank of a value as a percentage (inclusive). |
PERMUT The number of permutations for a subset of objects or events. |
PERMUTATIONA The number of permutations for a subset of objects or events (with repetition). |
PHI The value of the density function for a standard normal distribution. |
PI The number PI (3.141592). |
PMT The full amount (principal + interest) paid every period on a loan with fixed interest. |
POISSON (POISSON.DIST) The probability distribution function OR the cumulative probability function for a poisson distribution. |
POWER The number raised to a given power. |
PPMT The principal amount paid on a given period on a loan with fixed interest. |
PRICE The price of a security that pays periodic interest. |
PRICEDISC The price of a discounted security (no interest payments). |
PRICEMAT The price of a security that pays interest at maturity. |
PROB The probability that the values in a data set are greater than a lower limit and less than an upper limit. |
PRODUCT The product of all the numerical values. |
PROPER The text string with the first letter of every word as a capital letter. |
PV The present value of a series of equal cash flows at regular intervals. |
QUARTILE (QUARTILE.INC) The quartile of a data set (inclusive). |
QUOTIENT The integer portion after division. |
RADIANS The number of radians given the number of degrees. |
RAND The random number between zero and one (>=0 and <1). |
RANDBETWEEN The random integer between two values (>=bottom and <=top). |
RANK (RANK.EQ) The rank of a value in descending order (equal ranking). |
RATE The interest rate for a series of equal cash flows at regular intervals. |
RECEIVED The amount received at the end when a security is held to maturity. |
REPLACE The text string after replacing characters in a specific location. |
REPT The text string repeated a number of times. |
RIGHT The last or right most characters in a text string. |
ROMAN The text string converting a binary number to a roman numeral. |
ROUND The number rounded to a specified number of digits. |
ROUNDDOWN The number rounded down to a specified number of digits. |
ROUNDUP The number rounded up to a specified number of digits. |
ROW The row number of a cell reference. |
ROWS The number of rows in a cell range or reference. |
RRI The equivalent interest rate for the growth of an investment. |
RSQ The square of pearson product moment correlation coefficient through data points in known y's and known x's. |
SEARCH The starting position of a substring within a larger text string (not case sensitive). |
SECOND The number of seconds as an integer given a date serial number. |
SERIESSUM The sum of a power series based on a formula. |
SHEET The sheet number of the referenced sheet. |
SHEETS The number of sheets in a reference. |
SIGN The numerical value indicating if a number is positive or negative. |
SIN The sine of a number. |
SINH The hyperbolic sine of a number. |
SKEW The number representing the skewness of a distribution based on a sample. |
SLN The depreciation of an asset in a single period (straight-line method). |
SLOPE The slope of a linear regression line through the given data points. |
SMALL The kth smallest numerical value. |
SQRT The positive square root of a number. |
SQRTPI The square root of a number multiplied by PI. |
STANDARDIZE The normalized value from a distributed characterised by a mean and a standard deviation. |
STDEV (STDEV.S) The standard deviation based on a sample. |
STDEVA The standard deviation based on a sample (including logical values and text). |
STDEVP (STDEV.P) The standard deviation based on an entire population. |
STDEVPA The standard deviation based on an entire population (including logical values and text). |
STEYX The standard error of a regression. |
SUBSTITUTE The text string after replacing instances of a substring. |
SUBTOTAL (AGGREGATE) The choice of 11 different operations for numerical values (renamed). |
SUM The total of the numerical values. |
SUMIF (SUMIFS) The total of the numerical values that satisfies one condition. |
SUMPRODUCT The sum of the product of one or more arrays of values. |
SUMSQ The variation of a data set from its mean. |
SUMX2MY2 The sum of the difference of squares of corresponding values in two arrays. |
SUMX2PY2 The sum of the sum of squares of corresponding values in two arrays. |
SUMXMY2 The sum of squares of differences of corresponding values in two arrays. |
SYD The depreciation of an asset in a single period (sum-of-years digits method). |
T The text string of the value given. |
TAN The tangent of a number. |
TANH The hyperbolic tangent of a number. |
TBILLEQ The yield (bond-equivalent) for a treasury bill. |
TBILLPRICE The price per $100 face value for a treasury bill. |
TBILLYIELD The yield for a treasury bill. |
TDIST (T.DIST.2T) The percentage points probability for the t distribution. |
TEXT The number as a formatted text string. |
TIME The time as a decimal given an hour, minute, second. |
TIMEVALUE The time as a decimal given a time in text format. |
TINV (T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom. |
TODAY The date serial number representing today's date. |
TRANSPOSE The array with its orientation changed. |
TREND The y-values along a linear trend given a set of x-values. |
TRIM The text string with all extra spaces removed from the beginning, middle and end. |
TRIMMEAN The mean of the interior of a data set. |
TRUE (Compatibility) The logical value True. |
TRUNC The number with any decimal places removed. |
TTEST (T.TEST) The probability value from a t distribution. |
TYPE The number indicating the data type of the value. |
UPPER The text string with all the characters converted to uppercase. |
VALUE (NUMBERVALUE) The number that a text string represents (renamed). |
VAR (VAR.S) The variance based on a sample. |
VARA The variance based on a sample (including logical values and text). |
VARP (VAR.P) The variance based on an entire population. |
VARPA The variance based on an entire population (including logical values and text). |
VDB The depreciation of an asset in a single period (variable declining balance method). |
VLOOKUP (XLOOKUP) The value in the same row after finding a matching value in the first column. |
WEEKDAY The day of the week for a given date. |
WEEKNUM The week number in the year for a given date. |
WEIBULL (WEIBULL.DIST) The probability distribution function OR the cumulative probability function for a weibull distribution. |
WORKDAY (WORKDAY.INTL) The date serial number that is a given number of working days before or after a date. |
XIRR The interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate). |
XNPV The net present value of a series of unequal cash flows at irregular intervals. |
YEAR The year as an integer given a date serial number. |
YEARFRAC The number of years as a decimal between two dates. |
YIELD The interest rate (annual) for a series of equal cash flows at regular intervals. |
YIELDDISC The interest rate (annual) for a discounted security (no interest payments). |
YIELDMAT The interest rate (annual) for a security that pays interest at maturity. |
ZTEST (Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext