# 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. |

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. |

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext