Excel Only
The following Excel functions are not available in LibreOffice Calc.
| AGGREGATE | The aggregate of values in a list, table or cell range. |
| ARRAYTOTEXT | (Microsoft 365) The contents of an array or cell ranges converted into text. |
| ASC | The text string converted from double byte to single byte characters. |
| AVERAGEIF | (AVERAGEIFS) The arithmetic mean of the values in a list, table or cell range that satisfies one condition. |
| AVERAGEIFS | The arithmetic mean of the values in a list, table or cell range that satisfies multiple conditions. |
| BAHTTEXT | The number converted to a Thai text string and appends 'Baht'. |
| BETA.DIST | The probability of getting a specific value between 0 and 1 for different distribution shapes. |
| 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 | (2013) 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 | (2013) The bitwise AND of two numbers. |
| BITLSHIFT | (2013) The number shifted left by a number of bits. |
| BITOR | (2013) The bitwise OR of two numbers. |
| BITRSHIFT | (2013) The number shifted right by a number of bits. |
| BITXOR | (2013) The bitwise Exclusive OR of two numbers. |
| BYCOL | (Microsoft 365) The results from applying a LAMBDA function to each column in an array. |
| BYROW | (Microsoft 365) The results from applying a LAMBDA function to each row in an array. |
| CEILING.MATH | (2013) 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 | (Microsoft 365) The array with just a specific number of columns. |
| CHOOSEROWS | (Microsoft 365) 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 in a list, table or cell range that satisfies multiple conditions. |
| COVARIANCE.P | The covariance based on an entire population. |
| COVARIANCE.S | The covariance based on a sample. |
| CSC | (2013) The cosecant of a number. |
| CSCH | (2013) 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 | (2013) The text string converted from single byte to double byte characters. |
| DROP | (Microsoft 365) The array without certain rows or columns. |
| ECMA.CEILING | (Compatibility) The number rounded up to the nearest multiple of significance. |
| ENCODEURL | (2013) 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 | The number converted to euros. |
| EXPAND | (Microsoft 365) 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 | (Microsoft 365) The value in a particular field from a linked data type. |
| FILTER | (2021) The array after filtering data that satisfies multiple conditions. |
| FILTERXML | (2013) The specific data from the xml content by using xpath. |
| FLOOR.MATH | (2013) 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 | (2016) The future value based on historical values. |
| FORECAST.LINEAR | (2016) The future y-value along a linear trend using existing values. |
| FORMULATEXT | (2013) The formula from a particular cell. |
| GAMMA | (2013) 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 | (Microsoft 365) The grouping of your data along one axis and aggregates the associated values. |
| HSTACK | (Microsoft 365) 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 | (2013) The value or something else if it evaluates to #N/A. |
| IFS | (2019) The value based on multiple True or False conditions. |
| IMAGE | (Microsoft 365) The image from a web URL. |
| IMCOSH | (2013) The hyperbolic cosine of a complex number. |
| IMCOT | (2013) The cotangent of a complex number. |
| IMCSC | (2013) The cosecant of a complex number. |
| IMCSCH | (2013) The hyperbolic cosecant of a complex number. |
| IMSEC | (2013) The secant of a complex number. |
| IMSECH | (2013) The hyperbolic secant of a complex number. |
| IMSINH | (2013) The hyperbolic sine of a complex number. |
| IMTAN | (2013) 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 | (Microsoft 365) The boolean True or False depending whether the value in a LAMBDA is missing. |
| ISOWEEKNUM | (2013) The number of the ISO week of the year for a given date. |
| JIS | (DBCS) The text string converted from single byte to double byte characters (renamed). |
| LAMBDA | (Microsoft 365) The results of a formula added as a named range. |
| LET | (2021) The result of a formula that can use variables. |
| 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 | (Microsoft 365) The array calculated by applying a LAMBDA function. |
| MAP | (Microsoft 365) The array formed by applying a map using a LAMBDA function. |
| MAXIFS | (2019) The largest value in a list, table or cell range that satisfies multiple conditions. |
| MINIFS | (2019) The smallest value in a list, table or cell range 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 | (2013) The number that a text string represents (current locale). |
| PDURATION | (2013) 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 | (Microsoft 365) 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 | (Microsoft 365) 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). |
| RANDARRAY | (2021) The array of random numbers between 0 and 1. |
| 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 | (Microsoft 365) The total value after reducing an array by applying a LAMBDA function. |
| RTD | The real time data from a program that supports COM. |
| SCAN | (Microsoft 365) The array after applying a LAMBDA function to each value and returns an array. |
| SEC | (2013) The secant of a number. |
| SECH | (2013) The hyperbolic secant of a number. |
| SEQUENCE | (2021) The array of sequential numbers. |
| SINGLE | (2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column. |
| SKEW.P | (2013) The number representing the skewness of a distribution based on an entire population. |
| SORT | (2021) The array of data that has been sorted by one column. |
| SORTBY | (2021) The array of data that has been sorted based on multiple columns. |
| STDEV.P | The standard deviation based on an entire population. |
| STDEV.S | The standard deviation based on a sample. |
| STOCKHISTORY | (Microsoft 365) The historical data about a financial instrument. |
| SUMIFS | The total of the numerical values in a list, table or cell range 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 | (Microsoft 365) The intersection of specific rows and columns in an array. |
| TEXTAFTER | (Microsoft 365) The characters from the end of a text string after a delimiter. |
| TEXTBEFORE | (Microsoft 365) 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 | (Microsoft 365) The text string split into multiple columns using delimiters. |
| TOCOL | (Microsoft 365) The array transformed into a single column. |
| TOROW | (Microsoft 365) The array transformed into a single row. |
| UNICHAR | (2013) The character with the corresponding UNICODE character. |
| UNICODE | (2013) The unicode number for the first character in a text string. |
| UNIQUE | (2021) The array of unique values in a list, table or cell range. |
| VALUETOTEXT | (Microsoft 365) The value converted to text. |
| VAR.P | The variance based on an entire population. |
| VAR.S | The variance based on a sample. |
| VSTACK | (Microsoft 365) The array after putting multiple arrays on top of each other. |
| WEBSERVICE | (2013) 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 | (Microsoft 365) The array transformed into multiple columns. |
| WRAPROWS | (Microsoft 365) The array transformed into multiple rows. |
| XLOOKUP | (2021) The value in the same row after finding a matching value in any column. |
| XMATCH | (2021) The position of a value in a list, table or cell range. |
| XOR | (2013) The logical exclusive OR for any number of arguments. |
| Z.TEST | The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
| AGGREGATE The aggregate of values in a list, table or cell range. |
| ARRAYTOTEXT (Microsoft 365) The contents of an array or cell ranges converted into text. |
| ASC The text string converted from double byte to single byte characters. |
| AVERAGEIF (AVERAGEIFS) The arithmetic mean of the values in a list, table or cell range that satisfies one condition. |
| AVERAGEIFS The arithmetic mean of the values in a list, table or cell range that satisfies multiple conditions. |
| BAHTTEXT The number converted to a Thai text string and appends 'Baht'. |
| BETA.DIST The probability of getting a specific value between 0 and 1 for different distribution shapes. |
| 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 (2013) 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 (2013) The bitwise AND of two numbers. |
| BITLSHIFT (2013) The number shifted left by a number of bits. |
| BITOR (2013) The bitwise OR of two numbers. |
| BITRSHIFT (2013) The number shifted right by a number of bits. |
| BITXOR (2013) The bitwise Exclusive OR of two numbers. |
| BYCOL (Microsoft 365) The results from applying a LAMBDA function to each column in an array. |
| BYROW (Microsoft 365) The results from applying a LAMBDA function to each row in an array. |
| CEILING.MATH (2013) 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 (Microsoft 365) The array with just a specific number of columns. |
| CHOOSEROWS (Microsoft 365) 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 in a list, table or cell range that satisfies multiple conditions. |
| COVARIANCE.P The covariance based on an entire population. |
| COVARIANCE.S The covariance based on a sample. |
| CSC (2013) The cosecant of a number. |
| CSCH (2013) 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 (2013) The text string converted from single byte to double byte characters. |
| DROP (Microsoft 365) The array without certain rows or columns. |
| ECMA.CEILING (Compatibility) The number rounded up to the nearest multiple of significance. |
| ENCODEURL (2013) 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 The number converted to euros. |
| EXPAND (Microsoft 365) 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 (Microsoft 365) The value in a particular field from a linked data type. |
| FILTER (2021) The array after filtering data that satisfies multiple conditions. |
| FILTERXML (2013) The specific data from the xml content by using xpath. |
| FLOOR.MATH (2013) 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 (2016) The future value based on historical values. |
| FORECAST.LINEAR (2016) The future y-value along a linear trend using existing values. |
| FORMULATEXT (2013) The formula from a particular cell. |
| GAMMA (2013) 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 (Microsoft 365) The grouping of your data along one axis and aggregates the associated values. |
| HSTACK (Microsoft 365) 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 (2013) The value or something else if it evaluates to #N/A. |
| IFS (2019) The value based on multiple True or False conditions. |
| IMAGE (Microsoft 365) The image from a web URL. |
| IMCOSH (2013) The hyperbolic cosine of a complex number. |
| IMCOT (2013) The cotangent of a complex number. |
| IMCSC (2013) The cosecant of a complex number. |
| IMCSCH (2013) The hyperbolic cosecant of a complex number. |
| IMSEC (2013) The secant of a complex number. |
| IMSECH (2013) The hyperbolic secant of a complex number. |
| IMSINH (2013) The hyperbolic sine of a complex number. |
| IMTAN (2013) 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 (Microsoft 365) The boolean True or False depending whether the value in a LAMBDA is missing. |
| ISOWEEKNUM (2013) The number of the ISO week of the year for a given date. |
| JIS (DBCS) The text string converted from single byte to double byte characters (renamed). |
| LAMBDA (Microsoft 365) The results of a formula added as a named range. |
| LET (2021) The result of a formula that can use variables. |
| 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 (Microsoft 365) The array calculated by applying a LAMBDA function. |
| MAP (Microsoft 365) The array formed by applying a map using a LAMBDA function. |
| MAXIFS (2019) The largest value in a list, table or cell range that satisfies multiple conditions. |
| MINIFS (2019) The smallest value in a list, table or cell range 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 (2013) The number that a text string represents (current locale). |
| PDURATION (2013) 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 (Microsoft 365) 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 (Microsoft 365) 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). |
| RANDARRAY (2021) The array of random numbers between 0 and 1. |
| 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 (Microsoft 365) The total value after reducing an array by applying a LAMBDA function. |
| RTD The real time data from a program that supports COM. |
| SCAN (Microsoft 365) The array after applying a LAMBDA function to each value and returns an array. |
| SEC (2013) The secant of a number. |
| SECH (2013) The hyperbolic secant of a number. |
| SEQUENCE (2021) The array of sequential numbers. |
| SINGLE (2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column. |
| SKEW.P (2013) The number representing the skewness of a distribution based on an entire population. |
| SORT (2021) The array of data that has been sorted by one column. |
| SORTBY (2021) The array of data that has been sorted based on multiple columns. |
| STDEV.P The standard deviation based on an entire population. |
| STDEV.S The standard deviation based on a sample. |
| STOCKHISTORY (Microsoft 365) The historical data about a financial instrument. |
| SUMIFS The total of the numerical values in a list, table or cell range 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 (Microsoft 365) The intersection of specific rows and columns in an array. |
| TEXTAFTER (Microsoft 365) The characters from the end of a text string after a delimiter. |
| TEXTBEFORE (Microsoft 365) 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 (Microsoft 365) The text string split into multiple columns using delimiters. |
| TOCOL (Microsoft 365) The array transformed into a single column. |
| TOROW (Microsoft 365) The array transformed into a single row. |
| UNICHAR (2013) The character with the corresponding UNICODE character. |
| UNICODE (2013) The unicode number for the first character in a text string. |
| UNIQUE (2021) The array of unique values in a list, table or cell range. |
| VALUETOTEXT (Microsoft 365) The value converted to text. |
| VAR.P The variance based on an entire population. |
| VAR.S The variance based on a sample. |
| VSTACK (Microsoft 365) The array after putting multiple arrays on top of each other. |
| WEBSERVICE (2013) 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 (Microsoft 365) The array transformed into multiple columns. |
| WRAPROWS (Microsoft 365) The array transformed into multiple rows. |
| XLOOKUP (2021) The value in the same row after finding a matching value in any column. |
| XMATCH (2021) The position of a value in a list, table or cell range. |
| XOR (2013) The logical exclusive OR for any number of arguments. |
| 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