Excel Only
The following Excel functions are not available in Google Sheets.
| AGGREGATE | AGGREGATE - The choice of 19 different operations for numerical values (which can ignore hidden rows and errors). |
| AMORDEGRC | AMORDEGRC - The depreciation of an asset in a single period (declining-balance method). |
| AREAS | AREAS - The number of areas in a cell range or reference. |
| ARRAYTOTEXT | ARRAYTOTEXT - The contents of an array or cell range converted to text. |
| BAHTTEXT | BAHTTEXT - The number converted to Thai text and appended with 'Baht'. |
| BESSELI | BESSELI - The Bessel function evaluated for purely imaginary arguments. |
| BESSELJ | BESSELJ - The modified Bessel function represented by J(x). |
| BESSELK | BESSELK - The modified Bessel function represented by K(x). |
| BESSELY | BESSELY - The modified Bessel function represented by Y(x). |
| BINOM.DIST.RANGE | BINOM.DIST.RANGE - The probability of a trial result using a binomial distribution. |
| COPILOT | COPILOT - (365 Beta) The response based on your referenced data using an AI model. |
| 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. |
| 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. |
| EUROCONVERT | EUROCONVERT - (Euro Currency Tools add-in) The number converted to euros. |
| EXPAND | EXPAND - (2024) The array expanded or padded to specific dimensions. |
| 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. |
| 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. |
| GROUPBY | GROUPBY - (365) The summary table after grouping and aggregating by row. |
| INFO | INFO - The text string returning useful information about the environment. |
| ISOMITTED | ISOMITTED - (2024) The boolean True or False depending whether the value in a LAMBDA is missing. |
| LET | LET - The result of a formula that can use variables. |
| MAKEARRAY | MAKEARRAY - (2024) The array calculated by applying a LAMBDA function. |
| NUMBERVALUE | NUMBERVALUE - The number that a text string represents (current locale). |
| ODDFPRICE | ODDFPRICE - The price per $100 face value of a security with an odd first period. |
| ODDFYIELD | ODDFYIELD - The yield of a security with an odd first period. |
| ODDLPRICE | ODDLPRICE - The price per $100 face value of a security with an odd last period. |
| ODDLYIELD | ODDLYIELD - The yield of a security with an odd last period. |
| PERCENTOF | PERCENTOF - (365) The percentage of a value compared to the total. |
| PHONETIC | PHONETIC - The phonetic characters from a text string. |
| PIVOTBY | PIVOTBY - (365) The summary table after grouping and aggregating by row and column. |
| PY | PY - (365) The value or object after running code in a Python Editor using the Microsoft Cloud runtime. |
| RTD | RTD - The real time data from a program that supports COM. |
| SHEET | SHEET - The sheet number of the referenced sheet. |
| SHEETS | SHEETS - The number of sheets in a reference. |
| SORTBY | SORTBY - The array of data that has been sorted based on multiple columns. |
| STOCKHISTORY | STOCKHISTORY - (365) The historical data about a financial instrument. |
| 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. |
| 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. |
| VALUETOTEXT | VALUETOTEXT - The value converted to text. |
| WEBSERVICE | WEBSERVICE - The results from a webservice. |
| WRAPCOLS | WRAPCOLS - (2024) The array transformed into multiple columns. |
| WRAPROWS | WRAPROWS - (2024) The array transformed into multiple rows. |
| AGGREGATE AGGREGATE - The choice of 19 different operations for numerical values (which can ignore hidden rows and errors). |
| AMORDEGRC AMORDEGRC - The depreciation of an asset in a single period (declining-balance method). |
| AREAS AREAS - The number of areas in a cell range or reference. |
| ARRAYTOTEXT ARRAYTOTEXT - The contents of an array or cell range converted to text. |
| BAHTTEXT BAHTTEXT - The number converted to Thai text and appended with 'Baht'. |
| BESSELI BESSELI - The Bessel function evaluated for purely imaginary arguments. |
| BESSELJ BESSELJ - The modified Bessel function represented by J(x). |
| BESSELK BESSELK - The modified Bessel function represented by K(x). |
| BESSELY BESSELY - The modified Bessel function represented by Y(x). |
| BINOM.DIST.RANGE BINOM.DIST.RANGE - The probability of a trial result using a binomial distribution. |
| COPILOT COPILOT - (365 Beta) The response based on your referenced data using an AI model. |
| 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. |
| 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. |
| EUROCONVERT EUROCONVERT - (Euro Currency Tools add-in) The number converted to euros. |
| EXPAND EXPAND - (2024) The array expanded or padded to specific dimensions. |
| 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. |
| 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. |
| GROUPBY GROUPBY - (365) The summary table after grouping and aggregating by row. |
| INFO INFO - The text string returning useful information about the environment. |
| ISOMITTED ISOMITTED - (2024) The boolean True or False depending whether the value in a LAMBDA is missing. |
| LET LET - The result of a formula that can use variables. |
| MAKEARRAY MAKEARRAY - (2024) The array calculated by applying a LAMBDA function. |
| NUMBERVALUE NUMBERVALUE - The number that a text string represents (current locale). |
| ODDFPRICE ODDFPRICE - The price per $100 face value of a security with an odd first period. |
| ODDFYIELD ODDFYIELD - The yield of a security with an odd first period. |
| ODDLPRICE ODDLPRICE - The price per $100 face value of a security with an odd last period. |
| ODDLYIELD ODDLYIELD - The yield of a security with an odd last period. |
| PERCENTOF PERCENTOF - (365) The percentage of a value compared to the total. |
| PHONETIC PHONETIC - The phonetic characters from a text string. |
| PIVOTBY PIVOTBY - (365) The summary table after grouping and aggregating by row and column. |
| PY PY - (365) The value or object after running code in a Python Editor using the Microsoft Cloud runtime. |
| RTD RTD - The real time data from a program that supports COM. |
| SHEET SHEET - The sheet number of the referenced sheet. |
| SHEETS SHEETS - The number of sheets in a reference. |
| SORTBY SORTBY - The array of data that has been sorted based on multiple columns. |
| STOCKHISTORY STOCKHISTORY - (365) The historical data about a financial instrument. |
| 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. |
| 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. |
| VALUETOTEXT VALUETOTEXT - The value converted to text. |
| WEBSERVICE WEBSERVICE - The results from a webservice. |
| WRAPCOLS WRAPCOLS - (2024) The array transformed into multiple columns. |
| WRAPROWS WRAPROWS - (2024) The array transformed into multiple rows. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext