Excel Only
The following Excel functions are not available in LibreOffice Calc.
| AGGREGATE | AGGREGATE - The choice of 19 different operations for numerical values (which can ignore hidden rows and errors). |
| ARRAYTOTEXT | ARRAYTOTEXT - The contents of an array or cell range converted to text. |
| ASC | ASC - (Japanese) The text string converted from double byte to single byte characters. |
| AVERAGEIF | AVERAGEIF - (AVERAGEIFS) The arithmetic mean of the numerical values that satisfies one condition. |
| AVERAGEIFS | AVERAGEIFS - The arithmetic mean of the numerical values that satisfies multiple conditions. |
| BAHTTEXT | BAHTTEXT - The number converted to Thai text and appended with 'Baht'. |
| BETA.DIST | BETA.DIST - The probability distribution function OR the cumulative probability function for a beta distribution. |
| BETA.INV | BETA.INV - The inverse of the cumulative probability function for a beta distribution. |
| BINOM.DIST | BINOM.DIST - The probability of getting a specific number of successes using a binomial distribution. |
| BINOM.DIST.RANGE | BINOM.DIST.RANGE - The probability of a trial result using a binomial distribution. |
| BINOM.INV | BINOM.INV - The number of trials needed for a specific amount of success using a binomial distribution. |
| BITAND | BITAND - The bitwise AND of two numbers. |
| BITLSHIFT | BITLSHIFT - The number shifted left by a number of bits. |
| BITOR | BITOR - The bitwise OR of two numbers. |
| BITRSHIFT | BITRSHIFT - The number shifted right by a number of bits. |
| BITXOR | BITXOR - The bitwise Exclusive OR of two numbers. |
| BYCOL | BYCOL - (2024) The results from applying a LAMBDA function to each column in an array. |
| BYROW | BYROW - (2024) The results from applying a LAMBDA function to each row in an array. |
| CEILING.MATH | CEILING.MATH - The number rounded up (by default) to the nearest integer or multiple. |
| CEILING.PRECISE | CEILING.PRECISE - (CEILING.MATH) The number rounded to the nearest integer or multiple (renamed). |
| CHISQ.DIST | CHISQ.DIST - The probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed). |
| CHISQ.DIST.RT | CHISQ.DIST.RT - The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHISQ.INV | CHISQ.INV - The inverse of the probability distribution function for a chi-squared distribution (left tailed). |
| CHISQ.INV.RT | CHISQ.INV.RT - The inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHISQ.TEST | CHISQ.TEST - The probability value from a chi-squared distribution. |
| CHOOSECOLS | CHOOSECOLS - (2024) The array with just a specific number of columns. |
| CHOOSEROWS | CHOOSEROWS - (2024) The array with just a specific number of rows. |
| CONCAT | CONCAT - The text string that is a concatenation of cell ranges and strings. |
| CONFIDENCE.NORM | CONFIDENCE.NORM - The confidence interval for a population mean. |
| CONFIDENCE.T | CONFIDENCE.T - The confidence interval for a population mean using a t distribution. |
| COPILOT | COPILOT - (365 Beta) The response based on your referenced data using an AI model. |
| COUNTIFS | COUNTIFS - The number of numerical values that satisfies multiple conditions. |
| COVARIANCE.P | COVARIANCE.P - The covariance based on an entire population. |
| COVARIANCE.S | COVARIANCE.S - The covariance based on a sample. |
| CSC | CSC - The cosecant ratio of an angle. |
| CSCH | CSCH - The hyperbolic cosecant ratio of an angle. |
| CUBEKPIMEMBER | CUBEKPIMEMBER - The name of a key performance indicator. |
| CUBEMEMBER | CUBEMEMBER - The member or tuple from a cube. |
| CUBEMEMBERPROPERTY | CUBEMEMBERPROPERTY - The value of a member property from a cube. |
| CUBERANKEDMEMBER | CUBERANKEDMEMBER - The nth or ranked member in a set from a cube. |
| CUBESET | CUBESET - The calculated members returned from a cube. |
| CUBESETCOUNT | CUBESETCOUNT - The number of items in a set. |
| CUBEVALUE | CUBEVALUE - The aggregated value from a cube. |
| DATEDIF | DATEDIF - (Compatibility) The number of days, months or years between two dates. |
| DBCS | DBCS - (Japanese) The text string converted from single byte to double byte characters. |
| DETECTLANGUAGE | DETECTLANGUAGE - (365) The language code for the text string provided. |
| DROP | DROP - (2024) The array without certain rows or columns. |
| ECMA.CEILING | ECMA.CEILING - (CEILING.MATH) The number rounded up by default to a certain multiple (renamed). |
| ENCODEURL | ENCODEURL - The url encoded string. |
| ERF.PRECISE | ERF.PRECISE - The value of the error function integrated between 0 and a limit. |
| ERFC.PRECISE | ERFC.PRECISE - The complementary error function integrated between a limit and infinity. |
| ERROR.TYPE | ERROR.TYPE - The number corresponding to a particular error value in a cell. |
| EUROCONVERT | EUROCONVERT - (Euro Currency Tools add-in) The number converted to euros. |
| EXPAND | EXPAND - (2024) The array expanded or padded to specific dimensions. |
| EXPON.DIST | EXPON.DIST - The probability distribution function OR the cumulative probability function for an exponential distribution. |
| F.DIST | F.DIST - The probability distribution function OR the cumulative probability function for an f distribution (left tailed). |
| F.DIST.RT | F.DIST.RT - The probability distribution function for an f distribution (right tailed) (no cumulative). |
| F.INV | F.INV - The inverse of the probability distribution function for an f distribution (left tailed). |
| F.INV.RT | F.INV.RT - The inverse of the probability distribution function for an f distribution (right tailed). |
| F.TEST | F.TEST - The probability value from an f distribution. |
| FIELDVALUE | FIELDVALUE - (2024) The value in a particular field from a linked data type. |
| FILTERXML | FILTERXML - The specific data from the xml content by using xpath. |
| FLOOR.MATH | FLOOR.MATH - The number rounded down (by default) to the nearest integer or multiple. |
| FLOOR.PRECISE | FLOOR.PRECISE - (FLOOR.MATH) The number rounded to the nearest integer or multiple (renamed). |
| FORECAST.ETS | FORECAST.ETS - The future value based on historical values. |
| FORECAST.ETS.CONFINT | FORECAST.ETS.CONFINT - The confidence interval for a future value. |
| FORECAST.ETS.SEASONALITY | FORECAST.ETS.SEASONALITY - The length of the repetitive seasonality pattern. |
| FORECAST.ETS.STAT | FORECAST.ETS.STAT - The statistical value for a future value. |
| FORECAST.LINEAR | FORECAST.LINEAR - The future y-value along a linear trend using existing values. |
| FORMULATEXT | FORMULATEXT - The formula from a particular cell. |
| GAMMA | GAMMA - The gamma function value. |
| GAMMA.DIST | GAMMA.DIST - The probability distribution function OR the cumulative probability function for a gamma distribution. |
| GAMMA.INV | GAMMA.INV - The inverse of the cumulative probability function for a gamma distribution. |
| GAMMALN.PRECISE | GAMMALN.PRECISE - The natural logarithm of the gamma function. |
| GETPIVOTDATA | GETPIVOTDATA - The data obtained from a pivot table. |
| GROUPBY | GROUPBY - (365) The summary table after grouping and aggregating by row. |
| HSTACK | HSTACK - (2024) The array after putting multiple arrays next to each other. |
| HYPGEOM.DIST | HYPGEOM.DIST - The probability distribution function OR the cumulative probability function for a hypergeometric distribution. |
| IFERROR | IFERROR - The value or something else if it evaluates to an error. |
| IFNA | IFNA - The value or something else if it evaluates to #N/A. |
| IFS | IFS - The value based on multiple True or False conditions. |
| IMAGE | IMAGE - (2024) The image from a web URL. |
| IMCOSH | IMCOSH - The hyperbolic cosine ratio of a complex number. |
| IMCOT | IMCOT - The cotangent ratio of a complex number. |
| IMCSC | IMCSC - The cosecant ratio of a complex number. |
| IMCSCH | IMCSCH - The hyperbolic cosecant ratio of a complex number. |
| IMSEC | IMSEC - The secant ratio of a complex number. |
| IMSECH | IMSECH - The hyperbolic secant ratio of a complex number. |
| IMSINH | IMSINH - The hyperbolic sine ratio of a complex number. |
| IMTAN | IMTAN - The tangent ratio of a complex number. |
| INFO | INFO - The text string returning useful information about the environment. |
| ISO.CEILING | ISO.CEILING - (CEILING.MATH) The number rounded up by default to a certain multiple (renamed). |
| ISOMITTED | ISOMITTED - (2024) The boolean True or False depending whether the value in a LAMBDA is missing. |
| ISOWEEKNUM | ISOWEEKNUM - The week number in the year for a given date (based on European convention). |
| LAMBDA | LAMBDA - (2024) The results of a formula added as a named range. |
| LOGNORM.DIST | LOGNORM.DIST - The probability distribution function OR the cumulative probability function for a lognormal distribution. |
| LOGNORM.INV | LOGNORM.INV - The inverse of the probability distribution function for a lognormal distribution. |
| LOOKUP | LOOKUP - The value in a row (or column) that matches a value in a column (or row). |
| MAKEARRAY | MAKEARRAY - (2024) The array calculated by applying a LAMBDA function. |
| MAP | MAP - (2024) The array formed by mapping each value to a new value using a LAMBDA function. |
| MAXIFS | MAXIFS - The largest numerical value that satisfies multiple conditions. |
| MINIFS | MINIFS - The smallest numerical value that satisfies multiple conditions. |
| MODE.MULT | MODE.MULT - The array of all the numbers that appears the most often in a set. |
| MODE.SNGL | MODE.SNGL - The first number that appears the most often in a set. |
| NEGBINOM.DIST | NEGBINOM.DIST - The probability distribution function OR the cumulative probability function for a negative binomial distribution. |
| NETWORKDAYS.INTL | NETWORKDAYS.INTL - The number of working days between two dates excluding weekends and holidays. |
| NORM.DIST | NORM.DIST - The probability distribution function OR the cumulative probability function for a normal distribution. |
| NORM.INV | NORM.INV - The inverse of the probability distribution function for a normal distribution. |
| NORM.S.DIST | NORM.S.DIST - The probability distribution function OR the cumulative probability function for a standard normal distribution. |
| NORM.S.INV | NORM.S.INV - The inverse of the probability distribution function for a standard normal distribution. |
| NUMBERVALUE | NUMBERVALUE - The number that a text string represents (current locale). |
| PDURATION | PDURATION - The number of periods required by an investment to reach a specified value. |
| PERCENTILE.EXC | PERCENTILE.EXC - The value from a data set that corresponds to a particular percentage (exclusive). |
| PERCENTILE.INC | PERCENTILE.INC - The value from a data set that corresponds to a particular percentage (inclusive). |
| PERCENTOF | PERCENTOF - (365) The percentage of a value compared to the total. |
| PERCENTRANK.EXC | PERCENTRANK.EXC - The rank of a value as a percentage (exclusive). |
| PERCENTRANK.INC | PERCENTRANK.INC - The rank of a value as a percentage (inclusive). |
| PHONETIC | PHONETIC - The phonetic characters from a text string. |
| PIVOTBY | PIVOTBY - (365) The summary table after grouping and aggregating by row and column. |
| POISSON.DIST | POISSON.DIST - The probability distribution function OR the cumulative probability function for a poisson distribution. |
| PY | PY - (365) The value or object after running code in a Python Editor using the Microsoft Cloud runtime. |
| QUARTILE.EXC | QUARTILE.EXC - The quartile of a data set (exclusive). |
| QUARTILE.INC | QUARTILE.INC - The quartile of a data set (inclusive). |
| RANK.AVG | RANK.AVG - The rank of a value in descending order (average ranking). |
| RANK.EQ | RANK.EQ - The rank of a value in descending order (equal ranking). |
| REDUCE | REDUCE - (2024) The total value after reducing an array by applying a LAMBDA function. |
| REGEXEXTRACT | REGEXEXTRACT - (365) The characters that match a regular expression. |
| REGEXREPLACE | REGEXREPLACE - (365) The text string after replacing characters that match a regular expression. |
| REGEXTEST | REGEXTEST - (365) The boolean True or False depending if the regular expression matches any part of a text string. |
| RTD | RTD - The real time data from a program that supports COM. |
| SCAN | SCAN - (2024) The array after applying a LAMBDA function to each value and returns an array. |
| SEC | SEC - The secant ratio of an angle. |
| SECH | SECH - The hyperbolic secant ratio of an angle. |
| SKEW.P | SKEW.P - The number representing the skewness of a distribution based on an entire population. |
| STDEV.P | STDEV.P - The standard deviation based on an entire population. |
| STDEV.S | STDEV.S - The standard deviation based on a sample. |
| STOCKHISTORY | STOCKHISTORY - (365) The historical data about a financial instrument. |
| SUMIFS | SUMIFS - The total of the numerical values that satisfies multiple conditions. |
| SWITCH | SWITCH - The value based on a list of exact matches. |
| T.DIST | T.DIST - The probability distribution function for a t distribution (left tailed). |
| T.DIST.2T | T.DIST.2T - The probability distribution function for a two tailed distribution (no cumulative). |
| T.DIST.RT | T.DIST.RT - The probability distribution function for a t distribution (right tailed) (no cumulative). |
| T.INV | T.INV - The inverse of the probability distribution function for a t distribution (left tailed). |
| T.INV.2T | T.INV.2T - The inverse of the probability distribution function for a two tailed distribution. |
| T.TEST | T.TEST - The probability value from a t distribution. |
| TAKE | TAKE - (2024) The array from taking the intersection of specific rows and columns. |
| TEXTAFTER | TEXTAFTER - (2024) The characters from the end of a text string after a delimiter. |
| TEXTBEFORE | TEXTBEFORE - (2024) The characters from the start of a text string before a delimiter. |
| TEXTJOIN | TEXTJOIN - The text string that is a concatenation of several strings with a delimiter. |
| TEXTSPLIT | TEXTSPLIT - (2024) The text string split into multiple columns using delimiters. |
| TOCOL | TOCOL - (2024) The array transformed into a single column. |
| TOROW | TOROW - (2024) The array transformed into a single row. |
| TRANSLATE | TRANSLATE - (365) The text string translated into another language. |
| TRIMRANGE | TRIMRANGE - (365) The array after excluding all empty rows and/or columns from the outer edges of a range. |
| UNICHAR | UNICHAR - The character with the corresponding UNICODE character. |
| UNICODE | UNICODE - The unicode number for the first character in a text string. |
| VALUETOTEXT | VALUETOTEXT - The value converted to text. |
| VAR.P | VAR.P - The variance based on an entire population. |
| VAR.S | VAR.S - The variance based on a sample. |
| VSTACK | VSTACK - (2024) The array after putting multiple arrays on top of each other. |
| WEBSERVICE | WEBSERVICE - The results from a webservice. |
| WEIBULL.DIST | WEIBULL.DIST - The probability distribution function OR the cumulative probability function for a weibull distribution. |
| WORKDAY.INTL | WORKDAY.INTL - The date serial number that is a given number of working days before or after a date. |
| WRAPCOLS | WRAPCOLS - (2024) The array transformed into multiple columns. |
| WRAPROWS | WRAPROWS - (2024) The array transformed into multiple rows. |
| XOR | XOR - The boolean True or False depending on multiple conditions. |
| Z.TEST | Z.TEST - The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
| AGGREGATE AGGREGATE - The choice of 19 different operations for numerical values (which can ignore hidden rows and errors). |
| ARRAYTOTEXT ARRAYTOTEXT - The contents of an array or cell range converted to text. |
| ASC ASC - (Japanese) The text string converted from double byte to single byte characters. |
| AVERAGEIF AVERAGEIF - (AVERAGEIFS) The arithmetic mean of the numerical values that satisfies one condition. |
| AVERAGEIFS AVERAGEIFS - The arithmetic mean of the numerical values that satisfies multiple conditions. |
| BAHTTEXT BAHTTEXT - The number converted to Thai text and appended with 'Baht'. |
| BETA.DIST BETA.DIST - The probability distribution function OR the cumulative probability function for a beta distribution. |
| BETA.INV BETA.INV - The inverse of the cumulative probability function for a beta distribution. |
| BINOM.DIST BINOM.DIST - The probability of getting a specific number of successes using a binomial distribution. |
| BINOM.DIST.RANGE BINOM.DIST.RANGE - The probability of a trial result using a binomial distribution. |
| BINOM.INV BINOM.INV - The number of trials needed for a specific amount of success using a binomial distribution. |
| BITAND BITAND - The bitwise AND of two numbers. |
| BITLSHIFT BITLSHIFT - The number shifted left by a number of bits. |
| BITOR BITOR - The bitwise OR of two numbers. |
| BITRSHIFT BITRSHIFT - The number shifted right by a number of bits. |
| BITXOR BITXOR - The bitwise Exclusive OR of two numbers. |
| BYCOL BYCOL - (2024) The results from applying a LAMBDA function to each column in an array. |
| BYROW BYROW - (2024) The results from applying a LAMBDA function to each row in an array. |
| CEILING.MATH CEILING.MATH - The number rounded up (by default) to the nearest integer or multiple. |
| CEILING.PRECISE CEILING.PRECISE - (CEILING.MATH) The number rounded to the nearest integer or multiple (renamed). |
| CHISQ.DIST CHISQ.DIST - The probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed). |
| CHISQ.DIST.RT CHISQ.DIST.RT - The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHISQ.INV CHISQ.INV - The inverse of the probability distribution function for a chi-squared distribution (left tailed). |
| CHISQ.INV.RT CHISQ.INV.RT - The inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHISQ.TEST CHISQ.TEST - The probability value from a chi-squared distribution. |
| CHOOSECOLS CHOOSECOLS - (2024) The array with just a specific number of columns. |
| CHOOSEROWS CHOOSEROWS - (2024) The array with just a specific number of rows. |
| CONCAT CONCAT - The text string that is a concatenation of cell ranges and strings. |
| CONFIDENCE.NORM CONFIDENCE.NORM - The confidence interval for a population mean. |
| CONFIDENCE.T CONFIDENCE.T - The confidence interval for a population mean using a t distribution. |
| COPILOT COPILOT - (365 Beta) The response based on your referenced data using an AI model. |
| COUNTIFS COUNTIFS - The number of numerical values that satisfies multiple conditions. |
| COVARIANCE.P COVARIANCE.P - The covariance based on an entire population. |
| COVARIANCE.S COVARIANCE.S - The covariance based on a sample. |
| CSC CSC - The cosecant ratio of an angle. |
| CSCH CSCH - The hyperbolic cosecant ratio of an angle. |
| CUBEKPIMEMBER CUBEKPIMEMBER - The name of a key performance indicator. |
| CUBEMEMBER CUBEMEMBER - The member or tuple from a cube. |
| CUBEMEMBERPROPERTY CUBEMEMBERPROPERTY - The value of a member property from a cube. |
| CUBERANKEDMEMBER CUBERANKEDMEMBER - The nth or ranked member in a set from a cube. |
| CUBESET CUBESET - The calculated members returned from a cube. |
| CUBESETCOUNT CUBESETCOUNT - The number of items in a set. |
| CUBEVALUE CUBEVALUE - The aggregated value from a cube. |
| DATEDIF DATEDIF - (Compatibility) The number of days, months or years between two dates. |
| DBCS DBCS - (Japanese) The text string converted from single byte to double byte characters. |
| DETECTLANGUAGE DETECTLANGUAGE - (365) The language code for the text string provided. |
| DROP DROP - (2024) The array without certain rows or columns. |
| ECMA.CEILING ECMA.CEILING - (CEILING.MATH) The number rounded up by default to a certain multiple (renamed). |
| ENCODEURL ENCODEURL - The url encoded string. |
| ERF.PRECISE ERF.PRECISE - The value of the error function integrated between 0 and a limit. |
| ERFC.PRECISE ERFC.PRECISE - The complementary error function integrated between a limit and infinity. |
| ERROR.TYPE ERROR.TYPE - The number corresponding to a particular error value in a cell. |
| EUROCONVERT EUROCONVERT - (Euro Currency Tools add-in) The number converted to euros. |
| EXPAND EXPAND - (2024) The array expanded or padded to specific dimensions. |
| EXPON.DIST EXPON.DIST - The probability distribution function OR the cumulative probability function for an exponential distribution. |
| F.DIST F.DIST - The probability distribution function OR the cumulative probability function for an f distribution (left tailed). |
| F.DIST.RT F.DIST.RT - The probability distribution function for an f distribution (right tailed) (no cumulative). |
| F.INV F.INV - The inverse of the probability distribution function for an f distribution (left tailed). |
| F.INV.RT F.INV.RT - The inverse of the probability distribution function for an f distribution (right tailed). |
| F.TEST F.TEST - The probability value from an f distribution. |
| FIELDVALUE FIELDVALUE - (2024) The value in a particular field from a linked data type. |
| FILTERXML FILTERXML - The specific data from the xml content by using xpath. |
| FLOOR.MATH FLOOR.MATH - The number rounded down (by default) to the nearest integer or multiple. |
| FLOOR.PRECISE FLOOR.PRECISE - (FLOOR.MATH) The number rounded to the nearest integer or multiple (renamed). |
| FORECAST.ETS FORECAST.ETS - The future value based on historical values. |
| FORECAST.ETS.CONFINT FORECAST.ETS.CONFINT - The confidence interval for a future value. |
| FORECAST.ETS.SEASONALITY FORECAST.ETS.SEASONALITY - The length of the repetitive seasonality pattern. |
| FORECAST.ETS.STAT FORECAST.ETS.STAT - The statistical value for a future value. |
| FORECAST.LINEAR FORECAST.LINEAR - The future y-value along a linear trend using existing values. |
| FORMULATEXT FORMULATEXT - The formula from a particular cell. |
| GAMMA GAMMA - The gamma function value. |
| GAMMA.DIST GAMMA.DIST - The probability distribution function OR the cumulative probability function for a gamma distribution. |
| GAMMA.INV GAMMA.INV - The inverse of the cumulative probability function for a gamma distribution. |
| GAMMALN.PRECISE GAMMALN.PRECISE - The natural logarithm of the gamma function. |
| GETPIVOTDATA GETPIVOTDATA - The data obtained from a pivot table. |
| GROUPBY GROUPBY - (365) The summary table after grouping and aggregating by row. |
| HSTACK HSTACK - (2024) The array after putting multiple arrays next to each other. |
| HYPGEOM.DIST HYPGEOM.DIST - The probability distribution function OR the cumulative probability function for a hypergeometric distribution. |
| IFERROR IFERROR - The value or something else if it evaluates to an error. |
| IFNA IFNA - The value or something else if it evaluates to #N/A. |
| IFS IFS - The value based on multiple True or False conditions. |
| IMAGE IMAGE - (2024) The image from a web URL. |
| IMCOSH IMCOSH - The hyperbolic cosine ratio of a complex number. |
| IMCOT IMCOT - The cotangent ratio of a complex number. |
| IMCSC IMCSC - The cosecant ratio of a complex number. |
| IMCSCH IMCSCH - The hyperbolic cosecant ratio of a complex number. |
| IMSEC IMSEC - The secant ratio of a complex number. |
| IMSECH IMSECH - The hyperbolic secant ratio of a complex number. |
| IMSINH IMSINH - The hyperbolic sine ratio of a complex number. |
| IMTAN IMTAN - The tangent ratio of a complex number. |
| INFO INFO - The text string returning useful information about the environment. |
| ISO.CEILING ISO.CEILING - (CEILING.MATH) The number rounded up by default to a certain multiple (renamed). |
| ISOMITTED ISOMITTED - (2024) The boolean True or False depending whether the value in a LAMBDA is missing. |
| ISOWEEKNUM ISOWEEKNUM - The week number in the year for a given date (based on European convention). |
| LAMBDA LAMBDA - (2024) The results of a formula added as a named range. |
| LOGNORM.DIST LOGNORM.DIST - The probability distribution function OR the cumulative probability function for a lognormal distribution. |
| LOGNORM.INV LOGNORM.INV - The inverse of the probability distribution function for a lognormal distribution. |
| LOOKUP LOOKUP - The value in a row (or column) that matches a value in a column (or row). |
| MAKEARRAY MAKEARRAY - (2024) The array calculated by applying a LAMBDA function. |
| MAP MAP - (2024) The array formed by mapping each value to a new value using a LAMBDA function. |
| MAXIFS MAXIFS - The largest numerical value that satisfies multiple conditions. |
| MINIFS MINIFS - The smallest numerical value that satisfies multiple conditions. |
| MODE.MULT MODE.MULT - The array of all the numbers that appears the most often in a set. |
| MODE.SNGL MODE.SNGL - The first number that appears the most often in a set. |
| NEGBINOM.DIST NEGBINOM.DIST - The probability distribution function OR the cumulative probability function for a negative binomial distribution. |
| NETWORKDAYS.INTL NETWORKDAYS.INTL - The number of working days between two dates excluding weekends and holidays. |
| NORM.DIST NORM.DIST - The probability distribution function OR the cumulative probability function for a normal distribution. |
| NORM.INV NORM.INV - The inverse of the probability distribution function for a normal distribution. |
| NORM.S.DIST NORM.S.DIST - The probability distribution function OR the cumulative probability function for a standard normal distribution. |
| NORM.S.INV NORM.S.INV - The inverse of the probability distribution function for a standard normal distribution. |
| NUMBERVALUE NUMBERVALUE - The number that a text string represents (current locale). |
| PDURATION PDURATION - The number of periods required by an investment to reach a specified value. |
| PERCENTILE.EXC PERCENTILE.EXC - The value from a data set that corresponds to a particular percentage (exclusive). |
| PERCENTILE.INC PERCENTILE.INC - The value from a data set that corresponds to a particular percentage (inclusive). |
| PERCENTOF PERCENTOF - (365) The percentage of a value compared to the total. |
| PERCENTRANK.EXC PERCENTRANK.EXC - The rank of a value as a percentage (exclusive). |
| PERCENTRANK.INC PERCENTRANK.INC - The rank of a value as a percentage (inclusive). |
| PHONETIC PHONETIC - The phonetic characters from a text string. |
| PIVOTBY PIVOTBY - (365) The summary table after grouping and aggregating by row and column. |
| POISSON.DIST POISSON.DIST - The probability distribution function OR the cumulative probability function for a poisson distribution. |
| PY PY - (365) The value or object after running code in a Python Editor using the Microsoft Cloud runtime. |
| QUARTILE.EXC QUARTILE.EXC - The quartile of a data set (exclusive). |
| QUARTILE.INC QUARTILE.INC - The quartile of a data set (inclusive). |
| RANK.AVG RANK.AVG - The rank of a value in descending order (average ranking). |
| RANK.EQ RANK.EQ - The rank of a value in descending order (equal ranking). |
| REDUCE REDUCE - (2024) The total value after reducing an array by applying a LAMBDA function. |
| REGEXEXTRACT REGEXEXTRACT - (365) The characters that match a regular expression. |
| REGEXREPLACE REGEXREPLACE - (365) The text string after replacing characters that match a regular expression. |
| REGEXTEST REGEXTEST - (365) The boolean True or False depending if the regular expression matches any part of a text string. |
| RTD RTD - The real time data from a program that supports COM. |
| SCAN SCAN - (2024) The array after applying a LAMBDA function to each value and returns an array. |
| SEC SEC - The secant ratio of an angle. |
| SECH SECH - The hyperbolic secant ratio of an angle. |
| SKEW.P SKEW.P - The number representing the skewness of a distribution based on an entire population. |
| STDEV.P STDEV.P - The standard deviation based on an entire population. |
| STDEV.S STDEV.S - The standard deviation based on a sample. |
| STOCKHISTORY STOCKHISTORY - (365) The historical data about a financial instrument. |
| SUMIFS SUMIFS - The total of the numerical values that satisfies multiple conditions. |
| SWITCH SWITCH - The value based on a list of exact matches. |
| T.DIST T.DIST - The probability distribution function for a t distribution (left tailed). |
| T.DIST.2T T.DIST.2T - The probability distribution function for a two tailed distribution (no cumulative). |
| T.DIST.RT T.DIST.RT - The probability distribution function for a t distribution (right tailed) (no cumulative). |
| T.INV T.INV - The inverse of the probability distribution function for a t distribution (left tailed). |
| T.INV.2T T.INV.2T - The inverse of the probability distribution function for a two tailed distribution. |
| T.TEST T.TEST - The probability value from a t distribution. |
| TAKE TAKE - (2024) The array from taking the intersection of specific rows and columns. |
| TEXTAFTER TEXTAFTER - (2024) The characters from the end of a text string after a delimiter. |
| TEXTBEFORE TEXTBEFORE - (2024) The characters from the start of a text string before a delimiter. |
| TEXTJOIN TEXTJOIN - The text string that is a concatenation of several strings with a delimiter. |
| TEXTSPLIT TEXTSPLIT - (2024) The text string split into multiple columns using delimiters. |
| TOCOL TOCOL - (2024) The array transformed into a single column. |
| TOROW TOROW - (2024) The array transformed into a single row. |
| TRANSLATE TRANSLATE - (365) The text string translated into another language. |
| TRIMRANGE TRIMRANGE - (365) The array after excluding all empty rows and/or columns from the outer edges of a range. |
| UNICHAR UNICHAR - The character with the corresponding UNICODE character. |
| UNICODE UNICODE - The unicode number for the first character in a text string. |
| VALUETOTEXT VALUETOTEXT - The value converted to text. |
| VAR.P VAR.P - The variance based on an entire population. |
| VAR.S VAR.S - The variance based on a sample. |
| VSTACK VSTACK - (2024) The array after putting multiple arrays on top of each other. |
| WEBSERVICE WEBSERVICE - The results from a webservice. |
| WEIBULL.DIST WEIBULL.DIST - The probability distribution function OR the cumulative probability function for a weibull distribution. |
| WORKDAY.INTL WORKDAY.INTL - The date serial number that is a given number of working days before or after a date. |
| WRAPCOLS WRAPCOLS - (2024) The array transformed into multiple columns. |
| WRAPROWS WRAPROWS - (2024) The array transformed into multiple rows. |
| XOR XOR - The boolean True or False depending on multiple conditions. |
| Z.TEST Z.TEST - The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext