Excel and LibreOffice Calc

The following functions are available in both Microsoft Excel and LibreOffice Calc.

ABSThe absolute value or a number without its sign.
ACCRINTThe accrued interest for a security that pays interest periodically.
ACCRINTMThe accrued interest for a security that pays interest at maturity.
ACOSThe arc-cosine of a number.
ACOSHThe hyperbolic arc-cosine of a number.
ACOTThe arc-cotangent of a number.
ACOTHThe hyperbolic arc-cotangent of a number.
ADDRESSThe cell reference given a row and column number.
AMORDEGRCThe depreciation of an asset in a single period (straight-line, implicit coefficient).
AMORLINCThe depreciation of an asset in a single period (straight-line).
ANDThe boolean True or False depending on multiple conditions.
ARABICThe number converted from roman to arabic.
AREASThe number of areas in a cell range or reference.
ASINThe arc-sine of a number.
ASINHThe hyperbolic arc-sine of a number.
ATANThe arc-tangent of a number.
ATAN2The arc-tangent of the given x and y co-ordinates.
ATANHThe hyperbolic arc-tangent of a number.
AVEDEVThe average deviation of the numerical values.
AVERAGEThe arithmetic mean of the numerical values.
AVERAGEAThe arithmetic mean of the numerical values (including logical values and text).
BASEThe number converted into a text representation with the given base.
BESSELIThe Bessel function evaluated for purely imaginary arguments.
BESSELJThe modified Bessel function represented by J(x).
BESSELKThe modified Bessel function represented by K(x).
BESSELYThe modified Bessel function represented by Y(x).
BETADIST(BETA.DIST) The cumulative probability function for a beta distribution (only cumulative).
BETAINV(BETA.INV) The inverse of the probability distribution function for a beta distribution.
BIN2DECThe number converted from binary to decimal.
BIN2HEXThe number converted from binary to hexadecimal.
BIN2OCTThe number converted from binary to octal.
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.
CELLThe text string indicating information about a cell.
CHARThe character with the corresponding ANSI/ASCII number.
CHIDIST(CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHIINV(CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed).
CHITEST(CHISQ.TEST) The probability value from a chi-squared distribution.
CHOOSEThe value in a row (or column) based on an index number.
CLEANThe text string with all the non-printable characters removed.
CODEThe ANSI/ASCII number for the first character in a text string.
COLUMNThe column number of a cell reference.
COLUMNSThe number of columns in a cell range or reference.
COMBINThe number of combinations for a given number of items (without repetition).
COMBINAThe number of combinations for a given number of items (with repetition).
COMPLEXThe 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.
CONVERTThe number in one measurement system converted to another.
CORRELThe correlation coefficient between two data sets.
COSThe cosine of a number.
COSHThe hyperbolic cosine of a number.
COTThe cotangent of a number.
COTHThe hyperbolic cotangent of a number.
COUNTThe number of numerical values.
COUNTAThe number of numerical values (including logical values and text).
COUNTBLANKThe number of empty cells.
COUNTIF(COUNTIFS) The number of numerical values that satisfies one condition.
COUPDAYBSThe number of days between the previous coupon date and the settlement date.
COUPDAYSThe number of days between the coupon dates on either side of the settlement date.
COUPDAYSNCThe number of days between the settlement date and the next coupon date.
COUPNCDThe next coupon date after the settlement date.
COUPNUMThe number of coupons between the settlement date and the maturity date.
COUPPCDThe previous coupon date before the settlement date.
COVAR(COVARIANCE.P) The covariance based on an entire population.
CRITBINOM(BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed).
CUMIPMTThe cumulative interest payment on a loan between two dates.
CUMPRINCThe cumulative principal paid on a loan between two dates.
DATEThe date as a date serial number given a year, month, day.
DATEVALUEThe date serial number given a date in text format.
DAVERAGEThe arithmetic mean of all the numbers in a column that satisfies multiple conditions.
DAYThe day as an integer given a date serial number.
DAYSThe number of days between two dates.
DAYS360The number of days between two dates, based on 30 day months.
DBThe depreciation of an asset in a single period (declining balance method).
DCOUNTThe number of numerical values in a column that satisfies multiple conditions.
DCOUNTAThe number of numerical values in a column that satisfies multiple conditions (including logical values and text).
DDBThe depreciation of an asset in a single period (double or triple declining balance method).
DEC2BINThe number converted from decimal to binary.
DEC2HEXThe number converted from decimal to hexadecimal.
DEC2OCTThe number converted from decimal to octal.
DECIMALThe decimal number of a text representation of a number in a given base.
DEGREESThe number of degrees given a number of radians.
DELTAThe numerical value indicating if two numbers are equal.
DEVSQThe sum of the squared deviations from the mean.
DGETThe single value in a column that satisfies multiple conditions.
DISCThe interest rate (or discount rate) for a security held to maturity.
DMAXThe largest value in a column that satisfies multiple conditions.
DMINThe smallest value in a column that satisfies multiple conditions.
DOLLARThe text string of a number with the dollar formatting $0,000.00.
DOLLARDEThe dollar fraction expressed as a decimal.
DOLLARFRThe dollar decimal expressed as a fraction.
DPRODUCTThe product of the values in a column that satisfies multiple conditions.
DSTDEVThe standard deviation of the values in a column that satisfies multiple conditions based on a sample.
DSTDEVPThe standard deviation of the values in a column that satisfies multiple conditions based on an entire population.
DSUMThe total of the values in a column that satisfies multiple conditions.
DURATIONThe annual duration of a security that pays interest periodically.
DVARThe variance of the values in a column that satisfies multiple conditions based on a sample.
DVARPThe variance of the values in a column that satisfies multiple conditions based on an entire population.
EDATEThe date serial number that is a certain number of months before or after a date.
EFFECTThe effective interest rate given a nominal interest rate and compounding frequency.
EOMONTHThe date serial number of the last day of a month before or after a date.
ERFThe value of the error function integrated between two limits.
ERFC(ERFC.PRECISE) The complementary error function integrated between a limit and infinity.
EVENThe number rounded up to the nearest even integer.
EXACTThe value True or False based on whether two strings match exactly.
EXPThe exponential number raised to a particular power.
EXPONDIST(EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution.
FACTThe factorial of a positive whole number.
FACTDOUBLEThe 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).
FINDThe 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).
FISHERThe fisher transformation.
FISHERINVThe inverse of the fisher transformation.
FIXEDThe 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.
FREQUENCYThe number of times a particular value occurs.
FTEST(F.TEST) The probability value from an f distribution.
FVThe future value of a series of equal cash flows at regular intervals.
FVSCHEDULEThe future value of an initial principal after applying compound interest rates.
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.
GAUSSThe 0.5 less than the standard normal cumulative distribution.
GCDThe greatest common divisor of two or more numbers.
GEOMEANThe geometric mean of an array of numbers.
GESTEPThe value True or False depending if the number is greater than a threshold value.
GROWTHThe predicted exponential growth using existing data.
HARMEANThe harmonic mean of a data set.
HEX2BINThe number converted from hexadecimal to binary.
HEX2DECThe number converted from hexadecimal to decimal.
HEX2OCTThe number converted from hexadecimal to octal.
HLOOKUP(XLOOKUP) The value in the same column after finding a matching value in the first row.
HOURThe hour as an integer given a date serial number.
HYPERLINKThe hyperlink linked to a cell, document or webpage.
HYPGEOMDIST(HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only cumulative).
IFThe value based on whether a condition is True or False.
IMABSThe absolute value of a complex number.
IMAGINARYThe imaginary coefficient of a complex number.
IMARGUMENTThe theta argument in radians.
IMCONJUGATEThe complex conjugate of a complex number.
IMCOSThe cosine of a complex number.
IMDIVThe quotient of two complex numbers.
IMEXPThe exponential of a complex number.
IMLNThe natural logarithm of a complex number.
IMLOG10The base-10 logarithm of a complex number.
IMLOG2The base-2 logarithm of a complex number.
IMPOWERThe complex number raised to an integer number.
IMPRODUCTThe product of two or more complex numbers.
IMREALThe real coefficient of a complex number.
IMSINThe sine of a complex number.
IMSQRTThe square root of a complex number.
IMSUBThe difference of two complex numbers.
IMSUMThe sum of two or more complex numbers.
INDEXThe value from a cell range which is the intersection of a row AND a column.
INDIRECTThe value of a given cell reference specified by a text string.
INTThe number rounded down to the nearest integer.
INTERCEPTThe intersection with the y-axis using a linear regression plotted through known values.
INTRATEThe interest rate for a security held to maturity.
IPMTThe interest amount paid on a given period on a loan with fixed interest.
IRRThe interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
ISBLANKThe boolean True or False depending if the value is blank.
ISERRThe boolean True or False depending if the value is an error (excluding #N/A).
ISERRORThe boolean True or False depending if the value is an error.
ISEVENThe boolean True or False depending if the value is an even number.
ISFORMULAThe boolean True or False depending if the cell contains a formula.
ISLOGICALThe boolean True or False depending if the value is True or False.
ISNAThe boolean True or False depending if the value is #N/A.
ISNONTEXTThe boolean True or False depending if the value is non text.
ISNUMBERThe boolean True or False depending if the value is a number.
ISODDThe 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).
ISREFThe boolean True or False depending if the value is a cell reference.
ISTEXTThe boolean True or False depending if the value is text.
KURTThe kurtosis for a list or array of numbers.
LARGEThe kth largest numerical value.
LCMThe least common multiple of two or more numbers.
LEFTThe first or left most characters in a text string.
LENThe number of characters in a text string.
LINESTThe array of values for a straight line that best fits your data.
LNThe natural logarithm of a number.
LOGThe logarithm of a number to any base.
LOG10The logarithm of a number to the base 10.
LOGESTThe array of values for an exponential curve that best fits your data.
LOGINV(LOGNORM.INV) The inverse of the probability distribution function for a lognormal distribution.
LOGNORMDIST(LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative).
LOWERThe text string with all the characters converted to lowercase.
MATCH(XMATCH) The position of a value in a list, table or cell range.
MAXThe largest numerical value.
MAXAThe largest numerical value (including logical values and text).
MDETERMThe matrix determinant of an array.
MDURATIONThe modified duration for a security that pays interest periodically.
MEDIANThe number in the middle of a set of numbers.
MIDThe characters from the middle of a text string.
MINThe smallest numerical value.
MINAThe smallest numerical value (including logical values and text).
MINUTEThe minute as an integer given a date serial number.
MINVERSEThe inverse matrix of an array.
MIRRThe interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
MMULTThe matrix product of two arrays.
MODThe remainder after division.
MODE(MODE.SNGL) The first number that appears the most often in a set.
MONTHThe month as an integer given a date serial number.
MROUNDThe number rounded to the desired multiple.
MULTINOMIALThe number of permutations for a given number of items (with duplicates).
MUNITThe unit matrix or the specified dimension.
NThe value converted to a number.
NAThe 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.
NOMINALThe 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.
NOTThe opposite of a True or False value.
NOWThe date serial number of the current system date and time.
NPERThe number of periods for an investment.
NPVThe net present value of a series of unequal cash flows at regular intervals.
OCT2BINThe number converted from octal to binary.
OCT2DECThe number converted from octal to decimal.
OCT2HEXThe number converted from octal to hexadecimal.
ODDThe number rounded up to the nearest odd integer.
ODDFPRICEThe price per $100 face value of a security with an odd first period.
ODDFYIELDThe yield of a security with an odd first period.
ODDLPRICEThe price per $100 face value of a security with an odd last period.
ODDLYIELDThe yield of a security with an odd last period.
OFFSETThe value in a cell which is an offset from another cell.
ORThe boolean True or False depending on multiple conditions.
PEARSONThe 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).
PERMUTThe number of permutations for a subset of objects or events.
PERMUTATIONAThe number of permutations for a subset of objects or events (with repetition).
PHIThe value of the density function for a standard normal distribution.
PIThe number PI (3.141592).
PMTThe 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.
POWERThe number raised to a given power.
PPMTThe principal amount paid on a given period on a loan with fixed interest.
PRICEThe price of a security that pays periodic interest.
PRICEDISCThe price of a discounted security (no interest payments).
PRICEMATThe price of a security that pays interest at maturity.
PROBThe probability that the values in a data set are greater than a lower limit and less than an upper limit.
PRODUCTThe product of all the numerical values.
PROPERThe text string with the first letter of every word as a capital letter.
PVThe present value of a series of equal cash flows at regular intervals.
QUARTILE(QUARTILE.INC) The quartile of a data set (inclusive).
QUOTIENTThe integer portion after division.
RADIANSThe number of radians given the number of degrees.
RANDThe random number between zero and one (>=0 and <1).
RANDBETWEENThe random integer between two values (>=bottom and <=top).
RANK(RANK.EQ) The rank of a value in descending order (equal ranking).
RATEThe interest rate for a series of equal cash flows at regular intervals.
RECEIVEDThe amount received at the end when a security is held to maturity.
REPLACEThe text string after replacing characters in a specific location.
REPTThe text string repeated a number of times.
RIGHTThe last or right most characters in a text string.
ROMANThe text string converting a binary number to a roman numeral.
ROUNDThe number rounded to a specified number of digits.
ROUNDDOWNThe number rounded down to a specified number of digits.
ROUNDUPThe number rounded up to a specified number of digits.
ROWThe row number of a cell reference.
ROWSThe number of rows in a cell range or reference.
RRIThe equivalent interest rate for the growth of an investment.
RSQThe square of pearson product moment correlation coefficient through data points in known y's and known x's.
SEARCHThe starting position of a substring within a larger text string (not case sensitive).
SECONDThe number of seconds as an integer given a date serial number.
SERIESSUMThe sum of a power series based on a formula.
SHEETThe sheet number of the referenced sheet.
SHEETSThe number of sheets in a reference.
SIGNThe numerical value indicating if a number is positive or negative.
SINThe sine of a number.
SINHThe hyperbolic sine of a number.
SKEWThe number representing the skewness of a distribution based on a sample.
SLNThe depreciation of an asset in a single period (straight-line method).
SLOPEThe slope of a linear regression line through the given data points.
SMALLThe kth smallest numerical value.
SQRTThe positive square root of a number.
SQRTPIThe square root of a number multiplied by PI.
STANDARDIZEThe normalized value from a distributed characterised by a mean and a standard deviation.
STDEV(STDEV.S) The standard deviation based on a sample.
STDEVAThe standard deviation based on a sample (including logical values and text).
STDEVP(STDEV.P) The standard deviation based on an entire population.
STDEVPAThe standard deviation based on an entire population (including logical values and text).
STEYXThe standard error of a regression.
SUBSTITUTEThe text string after replacing instances of a substring.
SUBTOTAL(AGGREGATE) The choice of 11 different operations for numerical values (renamed).
SUMThe total of the numerical values.
SUMIF(SUMIFS) The total of the numerical values that satisfies one condition.
SUMPRODUCTThe sum of the product of one or more arrays of values.
SUMSQThe variation of a data set from its mean.
SUMX2MY2The sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2The sum of the sum of squares of corresponding values in two arrays.
SUMXMY2The sum of squares of differences of corresponding values in two arrays.
SYDThe depreciation of an asset in a single period (sum-of-years digits method).
TThe text string of the value given.
TANThe tangent of a number.
TANHThe hyperbolic tangent of a number.
TBILLEQThe yield (bond-equivalent) for a treasury bill.
TBILLPRICEThe price per $100 face value for a treasury bill.
TBILLYIELDThe yield for a treasury bill.
TDIST(T.DIST.2T) The percentage points probability for the t distribution.
TEXTThe number as a formatted text string.
TIMEThe time as a decimal given an hour, minute, second.
TIMEVALUEThe 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.
TODAYThe date serial number representing today's date.
TRANSPOSEThe array with its orientation changed.
TRENDThe y-values along a linear trend given a set of x-values.
TRIMThe text string with all extra spaces removed from the beginning, middle and end.
TRIMMEANThe mean of the interior of a data set.
TRUE(Compatibility) The logical value True.
TRUNCThe number with any decimal places removed.
TTEST(T.TEST) The probability value from a t distribution.
TYPEThe number indicating the data type of the value.
UPPERThe 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.
VARAThe variance based on a sample (including logical values and text).
VARP(VAR.P) The variance based on an entire population.
VARPAThe variance based on an entire population (including logical values and text).
VDBThe 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.
WEEKDAYThe day of the week for a given date.
WEEKNUMThe 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.
XIRRThe interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate).
XNPVThe net present value of a series of unequal cash flows at irregular intervals.
YEARThe year as an integer given a date serial number.
YEARFRACThe number of years as a decimal between two dates.
YIELDThe interest rate (annual) for a series of equal cash flows at regular intervals.
YIELDDISCThe interest rate (annual) for a discounted security (no interest payments).
YIELDMATThe 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