Excel Only
The following Excel functions are not available in LibreOffice Calc.
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. |
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