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 | (2024) 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 Thai text and appended with '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 | (2024) The results from applying a LAMBDA function to each column in an array. |
| BYROW | (2024) 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 | (2024) The array with just a specific number of columns. |
| CHOOSEROWS | (2024) The array with just a specifiic number of rows. |
| CONCAT | (2019) 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 | (2024) 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 | (2024) 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 | (2024) 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 | (365) Preview. The grouping of your data along one axis and aggregates the associated values. |
| HSTACK | (2024) 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) The value based on multiple True or False conditions. |
| IMAGE | (2024) 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 | (2024) 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 | (2024) 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 | (2024) The array calculated by applying a LAMBDA function. |
| MAP | (2024) The array formed by applying a map using a LAMBDA function. |
| MAXIFS | (2019) The largest numerical value that satisfies multiple conditions. |
| MINIFS | (2019) 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 | (365) 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 | (365) 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 | (2024) The total value after reducing an array by applying a LAMBDA function. |
| RTD | The real time data from a program that supports COM. |
| SCAN | (2024) 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 | (2024) The historical data about a financial instrument. |
| SUMIFS | The total of the numerical values that satisfies multiple conditions. |
| SWITCH | (2019) 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 | (2024) The intersection of specific rows and columns in an array. |
| TEXTAFTER | (2024) The characters from the end of a text string after a delimiter. |
| TEXTBEFORE | (2024) The characters from the start of a text string before a delimiter. |
| TEXTJOIN | (2019) The text string that is a concatenation of several strings with a delimiter. |
| TEXTSPLIT | (2024) The text string split into multiple columns using delimiters. |
| TOCOL | (2024) The array transformed into a single column. |
| TOROW | (2024) 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 | (2024) The value converted to text. |
| VAR.P | The variance based on an entire population. |
| VAR.S | The variance based on a sample. |
| VSTACK | (2024) 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 | (2024) The array transformed into multiple columns. |
| WRAPROWS | (2024) 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 (2024) 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 Thai text and appended with '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 (2024) The results from applying a LAMBDA function to each column in an array. |
| BYROW (2024) 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 (2024) The array with just a specific number of columns. |
| CHOOSEROWS (2024) The array with just a specifiic number of rows. |
| CONCAT (2019) 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 (2024) 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 (2024) 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 (2024) 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 (365) Preview. The grouping of your data along one axis and aggregates the associated values. |
| HSTACK (2024) 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) The value based on multiple True or False conditions. |
| IMAGE (2024) 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 (2024) 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 (2024) 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 (2024) The array calculated by applying a LAMBDA function. |
| MAP (2024) The array formed by applying a map using a LAMBDA function. |
| MAXIFS (2019) The largest numerical value that satisfies multiple conditions. |
| MINIFS (2019) 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 (365) 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 (365) 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 (2024) The total value after reducing an array by applying a LAMBDA function. |
| RTD The real time data from a program that supports COM. |
| SCAN (2024) 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 (2024) The historical data about a financial instrument. |
| SUMIFS The total of the numerical values that satisfies multiple conditions. |
| SWITCH (2019) 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 (2024) The intersection of specific rows and columns in an array. |
| TEXTAFTER (2024) The characters from the end of a text string after a delimiter. |
| TEXTBEFORE (2024) The characters from the start of a text string before a delimiter. |
| TEXTJOIN (2019) The text string that is a concatenation of several strings with a delimiter. |
| TEXTSPLIT (2024) The text string split into multiple columns using delimiters. |
| TOCOL (2024) The array transformed into a single column. |
| TOROW (2024) 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 (2024) The value converted to text. |
| VAR.P The variance based on an entire population. |
| VAR.S The variance based on a sample. |
| VSTACK (2024) 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 (2024) The array transformed into multiple columns. |
| WRAPROWS (2024) 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