Excel Only

The following Excel functions are not available in LibreOffice Calc.

AGGREGATEThe choice of 19 different operations for numerical values which can ignore hidden rows and errors.
ARRAYTOTEXT(2021) New. The contents of an array or cell range converted to text.
ASC(Japanese) The text string converted from double byte to single byte characters.
AVERAGEIF(AVERAGEIFS) The arithmetic mean of the numerical values that satisfies one condition.
AVERAGEIFSThe arithmetic mean of the numerical values that satisfies multiple conditions.
BAHTTEXTThe number converted to a Thai text string and appends 'Baht'.
BETA.DISTThe probability distribution function OR the cumulative probability function for a beta distribution.
BETA.INVThe inverse of the cumulative probability function for a beta distribution.
BINOM.DISTThe probability of getting a specific number of successes using a binomial distribution.
BINOM.DIST.RANGEThe probability of a trial result using a binomial distribution.
BINOM.INVThe number of trials needed for a specific amount of success using a binomial distribution.
BITANDThe bitwise AND of two numbers.
BITLSHIFTThe number shifted left by a number of bits.
BITORThe bitwise OR of two numbers.
BITRSHIFTThe number shifted right by a number of bits.
BITXORThe bitwise Exclusive OR of two numbers.
BYCOL(2021) New. The results from applying a LAMBDA function to each column in an array.
BYROW(2021) New. The results from applying a LAMBDA function to each row in an array.
CEILING.MATHThe number rounded up to the nearest integer or significant figure (including negative).
CEILING.PRECISE(CEILING.MATH) The number rounded up to the nearest integer or significant figure.
CHISQ.DISTThe probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed).
CHISQ.DIST.RTThe probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHISQ.INVThe inverse of the probability distribution function for a chi-squared distribution (left tailed).
CHISQ.INV.RTThe inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHISQ.TESTThe probability value from a chi-squared distribution.
CHOOSECOLS(2022) New. The array with just a specific number of columns.
CHOOSEROWS(2022) New. The array with just a specifiic number of rows.
CONCAT(2019) New. The text string that is a concatenation of cell ranges and strings.
CONFIDENCE.NORMThe confidence interval for a population mean.
CONFIDENCE.TThe confidence interval for a population mean using a t distribution.
COUNTIFSThe number of numerical values that satisfies multiple conditions.
COVARIANCE.PThe covariance based on an entire population.
COVARIANCE.SThe covariance based on a sample.
CSCThe cosecant of a number.
CSCHThe hyperbolic cosecant of a number.
CUBEKPIMEMBERThe name of a key performance indicator.
CUBEMEMBERThe member or tuple from a cube.
CUBESETThe calculated members returned from a cube.
CUBESETCOUNTThe number of items in a set.
CUBEVALUEThe aggregated value from a cube.
DATEDIF(Compatibility) The number of days, months or years between two dates.
DBCS(Japanese) The text string converted from single byte to double byte characters.
DROP(2022) New. The array without certain rows or columns.
ECMA.CEILING(Compatibility) The number rounded up to the nearest multiple of significance.
ENCODEURLThe url encoded string.
ERF.PRECISEThe value of the error function integrated between 0 and a limit.
ERFC.PRECISEThe complementary error function integrated between a limit and infinity.
ERROR.TYPEThe number corresponding to a particular error value in a cell.
EUROCONVERT(Euro Currency Tools add-in) The number converted to euros.
EXPAND(2022) New. The array expanded or padded to specific dimensions.
EXPON.DISTThe probability distribution function OR the cumulative probability function for an exponential distribution.
F.DISTThe probability distribution function OR the cumulative probability function for an f distribution (left tailed).
F.DIST.RTThe probability distribution function for an f distribution (right tailed) (no cumulative).
F.INVThe inverse of the probability distribution function for an f distribution (left tailed).
F.INV.RTThe inverse of the probability distribution function for an f distribution (right tailed).
F.TESTThe probability value from an f distribution.
FIELDVALUE(2020) New. The value in a particular field from a linked data type.
FILTERXMLThe specific data from the xml content by using xpath.
FLOOR.MATHThe number rounded down to the nearest integer or significant figure (including negative).
FLOOR.PRECISE(FLOOR.MATH) The number rounded down to the nearest integer or significant figure.
FORECAST.ETSThe future value based on historical values.
FORECAST.LINEARThe future y-value along a linear trend using existing values.
FORMULATEXTThe formula from a particular cell.
GAMMAThe gamma function value.
GAMMA.DISTThe probability distribution function OR the cumulative probability function for a gamma distribution.
GAMMA.INVThe inverse of the cumulative probability function for a gamma distribution.
GAMMALN.PRECISEThe natural logarithm of the gamma function.
GETPIVOTDATAThe data obtained from a pivot table.
GROUPBY(2023) Preview. The grouping of your data along one axis and aggregates the associated values.
HSTACK(2022) New. The array after putting multiple arrays next to each other.
HYPGEOM.DISTThe probability distribution functon OR the cumulative probability function for a hypergeometric distribution.
IFERRORThe value or something else if it evaluates to an error.
IFNAThe value or something else if it evaluates to #N/A.
IFS(2019) New. The value based on multiple True or False conditions.
IMAGE(2022) New. The image from a web URL.
IMCOSHThe hyperbolic cosine of a complex number.
IMCOTThe cotangent of a complex number.
IMCSCThe cosecant of a complex number.
IMCSCHThe hyperbolic cosecant of a complex number.
IMSECThe secant of a complex number.
IMSECHThe hyperbolic secant of a complex number.
IMSINHThe hyperbolic sine of a complex number.
IMTANThe tangent of a complex number.
INFOThe text string returning useful information about the environment.
ISO.CEILING(CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed).
ISOMITTED(2021) New. The boolean True or False depending whether the value in a LAMBDA is missing.
ISOWEEKNUMThe number of the ISO week of the year for a given date.
JIS(Japanese) The text string converted from single byte to double byte characters (renamed).
LAMBDA(2020) New. The results of a formula added as a named range.
LOGNORM.DISTThe probability distribution function OR the cumulative probability function for a lognormal distribution.
LOGNORM.INVThe inverse of the probability distribution function for a lognormal distribution.
LOOKUPThe value in a row (or column) that matches a value in a column (or row).
MAKEARRAY(2021) New. The array calculated by applying a LAMBDA function.
MAP(2021) New. The array formed by applying a map using a LAMBDA function.
MAXIFS(2019) New. The largest numerical value that satisfies multiple conditions.
MINIFS(2019) New. The smallest numerical value that satisfies multiple conditions.
MODE.MULTThe array of all the numbers that appears the most often in a set.
MODE.SNGLThe first number that appears the most often in a set.
NEGBINOM.DISTThe probability distribution function OR the cumulative probability function for a negative binomial distribution.
NETWORKDAYS.INTLThe total number of working days between two dates excluding weekends and holidays.
NORM.DISTThe probability distribution function OR the cumulative probability function for a normal distribution.
NORM.INVThe inverse of the probability distribution function for a normal distribution.
NORM.S.DISTThe probability distribution function OR the cumulative probability function for a standard normal distribution.
NORM.S.INVThe inverse of the probability distribution function for a standard normal distribution.
NUMBERVALUEThe number that a text string represents (current locale).
PDURATIONThe number of periods required by an investment to reach a specified value.
PERCENTILE.EXCThe value from a data set that corresponds to a particular percentage (exclusive).
PERCENTILE.INCThe value from a data set that corresponds to a particular percentage (inclusive).
PERCENTRANK.EXCThe rank of a value as a percentage (exclusive).
PERCENTRANK.INCThe rank of a value as a percentage (inclusive).
PHONETICThe phonetic characters from a text string.
PIVOTBY(2023) Preview. The grouping of your data along two axis and aggregates the associated values.
POISSON.DISTThe probability distribution function OR the cumulative probability function for a poisson distribution.
PY(2023) New. The value or object after running code in a Python Editor using the Microsoft Cloud runtime.
QUARTILE.EXCThe quartile of a data set (exclusive).
QUARTILE.INCThe quartile of a data set (inclusive).
RANK.AVGThe rank of a value in descending order (average ranking).
RANK.EQThe rank of a value in descending order (equal ranking).
REDUCE(2021) New. The total value after reducing an array by applying a LAMBDA function.
RTDThe real time data from a program that supports COM.
SCAN(2021) New. The array after applying a LAMBDA function to each value and returns an array.
SECThe secant of a number.
SECHThe hyperbolic secant of a number.
SINGLE(2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column.
SKEW.PThe number representing the skewness of a distribution based on an entire population.
STDEV.PThe standard deviation based on an entire population.
STDEV.SThe standard deviation based on a sample.
STOCKHISTORY(2020) New. The historical data about a financial instrument.
SUMIFSThe total of the numerical values that satisfies multiple conditions.
SWITCH(2019) New. The value based on a list of exact matches.
T.DISTThe probability distribution function for a t distribution (left tailed).
T.DIST.2TThe probability distribution function for a two tailed distribution (no cumulative).
T.DIST.RTThe probability distribution function for a t distribution (right tailed) (no cumulative).
T.INVThe inverse of the probability distribution function for a t distribution (left tailed)
T.INV.2TThe inverse of the probability distribution function for a two tailed distribution.
T.TESTThe probability value from a t distribution.
TAKE(2022) New. The intersection of specific rows and columns in an array.
TEXTAFTER(2022) New. The characters from the end of a text string after a delimiter.
TEXTBEFORE(2022) New. The characters from the start of a text string before a delimiter.
TEXTJOIN(2019) New. The text string that is a concatenation of several strings with a delimiter.
TEXTSPLIT(2022) New. The text string split into multiple columns using delimiters.
TOCOL(2022) New. The array transformed into a single column.
TOROW(2022) New. The array transformed into a single row.
UNICHARThe character with the corresponding UNICODE character.
UNICODEThe unicode number for the first character in a text string.
VALUETOTEXT(2021) New. The value converted to text.
VAR.PThe variance based on an entire population.
VAR.SThe variance based on a sample.
VSTACK(2021) New. The array after putting multiple arrays on top of each other.
WEBSERVICEThe results from a webservice.
WEIBULL.DISTThe probability distribution function OR the cumulative probability function for a weibull distribution.
WORKDAY.INTLThe date serial number that is a given number of working days before or after a date.
WRAPCOLS(2022) New. The array transformed into multiple columns.
WRAPROWS(2022) New. The array transformed into multiple rows.
XORThe boolean True or False depending on multiple conditions.
Z.TESTThe probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values.
AGGREGATE
The choice of 19 different operations for numerical values which can ignore hidden rows and errors.
ARRAYTOTEXT
(2021) New. The contents of an array or cell range converted to text.
ASC
(Japanese) The text string converted from double byte to single byte characters.
AVERAGEIF
(AVERAGEIFS) The arithmetic mean of the numerical values that satisfies one condition.
AVERAGEIFS
The arithmetic mean of the numerical values that satisfies multiple conditions.
BAHTTEXT
The number converted to a Thai text string and appends 'Baht'.
BETA.DIST
The probability distribution function OR the cumulative probability function for a beta distribution.
BETA.INV
The inverse of the cumulative probability function for a beta distribution.
BINOM.DIST
The probability of getting a specific number of successes using a binomial distribution.
BINOM.DIST.RANGE
The probability of a trial result using a binomial distribution.
BINOM.INV
The number of trials needed for a specific amount of success using a binomial distribution.
BITAND
The bitwise AND of two numbers.
BITLSHIFT
The number shifted left by a number of bits.
BITOR
The bitwise OR of two numbers.
BITRSHIFT
The number shifted right by a number of bits.
BITXOR
The bitwise Exclusive OR of two numbers.
BYCOL
(2021) New. The results from applying a LAMBDA function to each column in an array.
BYROW
(2021) New. The results from applying a LAMBDA function to each row in an array.
CEILING.MATH
The number rounded up to the nearest integer or significant figure (including negative).
CEILING.PRECISE
(CEILING.MATH) The number rounded up to the nearest integer or significant figure.
CHISQ.DIST
The probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed).
CHISQ.DIST.RT
The probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHISQ.INV
The inverse of the probability distribution function for a chi-squared distribution (left tailed).
CHISQ.INV.RT
The inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative).
CHISQ.TEST
The probability value from a chi-squared distribution.
CHOOSECOLS
(2022) New. The array with just a specific number of columns.
CHOOSEROWS
(2022) New. The array with just a specifiic number of rows.
CONCAT
(2019) New. The text string that is a concatenation of cell ranges and strings.
CONFIDENCE.NORM
The confidence interval for a population mean.
CONFIDENCE.T
The confidence interval for a population mean using a t distribution.
COUNTIFS
The number of numerical values that satisfies multiple conditions.
COVARIANCE.P
The covariance based on an entire population.
COVARIANCE.S
The covariance based on a sample.
CSC
The cosecant of a number.
CSCH
The hyperbolic cosecant of a number.
CUBEKPIMEMBER
The name of a key performance indicator.
CUBEMEMBER
The member or tuple from a cube.
CUBESET
The calculated members returned from a cube.
CUBESETCOUNT
The number of items in a set.
CUBEVALUE
The aggregated value from a cube.
DATEDIF
(Compatibility) The number of days, months or years between two dates.
DBCS
(Japanese) The text string converted from single byte to double byte characters.
DROP
(2022) New. The array without certain rows or columns.
ECMA.CEILING
(Compatibility) The number rounded up to the nearest multiple of significance.
ENCODEURL
The url encoded string.
ERF.PRECISE
The value of the error function integrated between 0 and a limit.
ERFC.PRECISE
The complementary error function integrated between a limit and infinity.
ERROR.TYPE
The number corresponding to a particular error value in a cell.
EUROCONVERT
(Euro Currency Tools add-in) The number converted to euros.
EXPAND
(2022) New. The array expanded or padded to specific dimensions.
EXPON.DIST
The probability distribution function OR the cumulative probability function for an exponential distribution.
F.DIST
The probability distribution function OR the cumulative probability function for an f distribution (left tailed).
F.DIST.RT
The probability distribution function for an f distribution (right tailed) (no cumulative).
F.INV
The inverse of the probability distribution function for an f distribution (left tailed).
F.INV.RT
The inverse of the probability distribution function for an f distribution (right tailed).
F.TEST
The probability value from an f distribution.
FIELDVALUE
(2020) New. The value in a particular field from a linked data type.
FILTERXML
The specific data from the xml content by using xpath.
FLOOR.MATH
The number rounded down to the nearest integer or significant figure (including negative).
FLOOR.PRECISE
(FLOOR.MATH) The number rounded down to the nearest integer or significant figure.
FORECAST.ETS
The future value based on historical values.
FORECAST.LINEAR
The future y-value along a linear trend using existing values.
FORMULATEXT
The formula from a particular cell.
GAMMA
The gamma function value.
GAMMA.DIST
The probability distribution function OR the cumulative probability function for a gamma distribution.
GAMMA.INV
The inverse of the cumulative probability function for a gamma distribution.
GAMMALN.PRECISE
The natural logarithm of the gamma function.
GETPIVOTDATA
The data obtained from a pivot table.
GROUPBY
(2023) Preview. The grouping of your data along one axis and aggregates the associated values.
HSTACK
(2022) New. The array after putting multiple arrays next to each other.
HYPGEOM.DIST
The probability distribution functon OR the cumulative probability function for a hypergeometric distribution.
IFERROR
The value or something else if it evaluates to an error.
IFNA
The value or something else if it evaluates to #N/A.
IFS
(2019) New. The value based on multiple True or False conditions.
IMAGE
(2022) New. The image from a web URL.
IMCOSH
The hyperbolic cosine of a complex number.
IMCOT
The cotangent of a complex number.
IMCSC
The cosecant of a complex number.
IMCSCH
The hyperbolic cosecant of a complex number.
IMSEC
The secant of a complex number.
IMSECH
The hyperbolic secant of a complex number.
IMSINH
The hyperbolic sine of a complex number.
IMTAN
The tangent of a complex number.
INFO
The text string returning useful information about the environment.
ISO.CEILING
(CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed).
ISOMITTED
(2021) New. The boolean True or False depending whether the value in a LAMBDA is missing.
ISOWEEKNUM
The number of the ISO week of the year for a given date.
JIS
(Japanese) The text string converted from single byte to double byte characters (renamed).
LAMBDA
(2020) New. The results of a formula added as a named range.
LOGNORM.DIST
The probability distribution function OR the cumulative probability function for a lognormal distribution.
LOGNORM.INV
The inverse of the probability distribution function for a lognormal distribution.
LOOKUP
The value in a row (or column) that matches a value in a column (or row).
MAKEARRAY
(2021) New. The array calculated by applying a LAMBDA function.
MAP
(2021) New. The array formed by applying a map using a LAMBDA function.
MAXIFS
(2019) New. The largest numerical value that satisfies multiple conditions.
MINIFS
(2019) New. The smallest numerical value that satisfies multiple conditions.
MODE.MULT
The array of all the numbers that appears the most often in a set.
MODE.SNGL
The first number that appears the most often in a set.
NEGBINOM.DIST
The probability distribution function OR the cumulative probability function for a negative binomial distribution.
NETWORKDAYS.INTL
The total number of working days between two dates excluding weekends and holidays.
NORM.DIST
The probability distribution function OR the cumulative probability function for a normal distribution.
NORM.INV
The inverse of the probability distribution function for a normal distribution.
NORM.S.DIST
The probability distribution function OR the cumulative probability function for a standard normal distribution.
NORM.S.INV
The inverse of the probability distribution function for a standard normal distribution.
NUMBERVALUE
The number that a text string represents (current locale).
PDURATION
The number of periods required by an investment to reach a specified value.
PERCENTILE.EXC
The value from a data set that corresponds to a particular percentage (exclusive).
PERCENTILE.INC
The value from a data set that corresponds to a particular percentage (inclusive).
PERCENTRANK.EXC
The rank of a value as a percentage (exclusive).
PERCENTRANK.INC
The rank of a value as a percentage (inclusive).
PHONETIC
The phonetic characters from a text string.
PIVOTBY
(2023) Preview. The grouping of your data along two axis and aggregates the associated values.
POISSON.DIST
The probability distribution function OR the cumulative probability function for a poisson distribution.
PY
(2023) New. The value or object after running code in a Python Editor using the Microsoft Cloud runtime.
QUARTILE.EXC
The quartile of a data set (exclusive).
QUARTILE.INC
The quartile of a data set (inclusive).
RANK.AVG
The rank of a value in descending order (average ranking).
RANK.EQ
The rank of a value in descending order (equal ranking).
REDUCE
(2021) New. The total value after reducing an array by applying a LAMBDA function.
RTD
The real time data from a program that supports COM.
SCAN
(2021) New. The array after applying a LAMBDA function to each value and returns an array.
SEC
The secant of a number.
SECH
The hyperbolic secant of a number.
SINGLE
(2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column.
SKEW.P
The number representing the skewness of a distribution based on an entire population.
STDEV.P
The standard deviation based on an entire population.
STDEV.S
The standard deviation based on a sample.
STOCKHISTORY
(2020) New. The historical data about a financial instrument.
SUMIFS
The total of the numerical values that satisfies multiple conditions.
SWITCH
(2019) New. The value based on a list of exact matches.
T.DIST
The probability distribution function for a t distribution (left tailed).
T.DIST.2T
The probability distribution function for a two tailed distribution (no cumulative).
T.DIST.RT
The probability distribution function for a t distribution (right tailed) (no cumulative).
T.INV
The inverse of the probability distribution function for a t distribution (left tailed)
T.INV.2T
The inverse of the probability distribution function for a two tailed distribution.
T.TEST
The probability value from a t distribution.
TAKE
(2022) New. The intersection of specific rows and columns in an array.
TEXTAFTER
(2022) New. The characters from the end of a text string after a delimiter.
TEXTBEFORE
(2022) New. The characters from the start of a text string before a delimiter.
TEXTJOIN
(2019) New. The text string that is a concatenation of several strings with a delimiter.
TEXTSPLIT
(2022) New. The text string split into multiple columns using delimiters.
TOCOL
(2022) New. The array transformed into a single column.
TOROW
(2022) New. The array transformed into a single row.
UNICHAR
The character with the corresponding UNICODE character.
UNICODE
The unicode number for the first character in a text string.
VALUETOTEXT
(2021) New. The value converted to text.
VAR.P
The variance based on an entire population.
VAR.S
The variance based on a sample.
VSTACK
(2021) New. The array after putting multiple arrays on top of each other.
WEBSERVICE
The results from a webservice.
WEIBULL.DIST
The probability distribution function OR the cumulative probability function for a weibull distribution.
WORKDAY.INTL
The date serial number that is a given number of working days before or after a date.
WRAPCOLS
(2022) New. The array transformed into multiple columns.
WRAPROWS
(2022) New. The array transformed into multiple rows.
XOR
The boolean True or False depending on multiple conditions.
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