Excel Only
The following Excel functions are not available in Google Sheets.
| AGGREGATE | The choice of 19 different operations for numerical values (which can ignore hidden rows and errors). |
| AMORDEGRC | The depreciation of an asset in a single period (declining-balance method). |
| AREAS | The number of areas in a cell range or reference. |
| ARRAYTOTEXT | The contents of an array or cell range converted to text. |
| BAHTTEXT | The number converted to Thai text and appended with 'Baht'. |
| BESSELI | The Bessel function evaluated for purely imaginary arguments. |
| BESSELJ | The modified Bessel function represented by J(x). |
| BESSELK | The modified Bessel function represented by K(x). |
| BESSELY | The modified Bessel function represented by Y(x). |
| BINOM.DIST.RANGE | The probability of a trial result using a binomial distribution. |
| COPILOT | (365 Beta) The response based on your referenced data using an AI model. |
| CUBEKPIMEMBER | The name of a key performance indicator. |
| CUBEMEMBER | The member or tuple from a cube. |
| CUBEMEMBERPROPERTY | The value of a member property from a cube. |
| CUBERANKEDMEMBER | The nth or ranked member in a set 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. |
| DBCS | (Japanese) The text string converted from single byte to double byte characters. |
| DETECTLANGUAGE | (365) The language code for the text string provided. |
| DROP | (2024) The array without certain rows or columns. |
| EUROCONVERT | (Euro Currency Tools add-in) The number converted to euros. |
| EXPAND | (2024) The array expanded or padded to specific dimensions. |
| FIELDVALUE | (2024) The value in a particular field from a linked data type. |
| FILTERXML | The specific data from the xml content by using xpath. |
| FORECAST.ETS | The future value based on historical values. |
| FORECAST.ETS.CONFINT | The confidence interval for a future value. |
| FORECAST.ETS.SEASONALITY | The length of the repetitive seasonality pattern. |
| FORECAST.ETS.STAT | The statistical value for a future value. |
| GROUPBY | (365) The summary table after grouping and aggregating by row. |
| INFO | The text string returning useful information about the environment. |
| ISOMITTED | (2024) The boolean True or False depending whether the value in a LAMBDA is missing. |
| LET | The result of a formula that can use variables. |
| MAKEARRAY | (2024) The array calculated by applying a LAMBDA function. |
| NUMBERVALUE | The number that a text string represents (current locale). |
| ODDFPRICE | The price per $100 face value of a security with an odd first period. |
| ODDFYIELD | The yield of a security with an odd first period. |
| ODDLPRICE | The price per $100 face value of a security with an odd last period. |
| ODDLYIELD | The yield of a security with an odd last period. |
| PERCENTOF | (365) The percentage of a value compared to the total. |
| PHONETIC | The phonetic characters from a text string. |
| PIVOTBY | (365) The summary table after grouping and aggregating by row and column. |
| PY | (365) The value or object after running code in a Python Editor using the Microsoft Cloud runtime. |
| RTD | The real time data from a program that supports COM. |
| SHEET | The sheet number of the referenced sheet. |
| SHEETS | The number of sheets in a reference. |
| SORTBY | The array of data that has been sorted based on multiple columns. |
| STOCKHISTORY | (2024) The historical data about a financial instrument. |
| TAKE | (2024) The array from taking the intersection of specific rows and columns. |
| TEXTAFTER | (2024) The characters from the end of a text string after a delimiter. |
| TEXTBEFORE | (2024) The characters from the start of a text string before a delimiter. |
| TEXTSPLIT | (2024) The text string split into multiple columns using delimiters. |
| TOCOL | (2024) The array transformed into a single column. |
| TOROW | (2024) The array transformed into a single row. |
| TRANSLATE | (365) The text string translated into another language. |
| TRIMRANGE | (365) The array after excluding all empty rows and/or columns from the outer edges of a range. |
| VALUETOTEXT | The value converted to text. |
| WEBSERVICE | The results from a webservice. |
| WRAPCOLS | (2024) The array transformed into multiple columns. |
| WRAPROWS | (2024) The array transformed into multiple rows. |
| AGGREGATE The choice of 19 different operations for numerical values (which can ignore hidden rows and errors). |
| AMORDEGRC The depreciation of an asset in a single period (declining-balance method). |
| AREAS The number of areas in a cell range or reference. |
| ARRAYTOTEXT The contents of an array or cell range converted to text. |
| BAHTTEXT The number converted to Thai text and appended with 'Baht'. |
| BESSELI The Bessel function evaluated for purely imaginary arguments. |
| BESSELJ The modified Bessel function represented by J(x). |
| BESSELK The modified Bessel function represented by K(x). |
| BESSELY The modified Bessel function represented by Y(x). |
| BINOM.DIST.RANGE The probability of a trial result using a binomial distribution. |
| COPILOT (365 Beta) The response based on your referenced data using an AI model. |
| CUBEKPIMEMBER The name of a key performance indicator. |
| CUBEMEMBER The member or tuple from a cube. |
| CUBEMEMBERPROPERTY The value of a member property from a cube. |
| CUBERANKEDMEMBER The nth or ranked member in a set 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. |
| DBCS (Japanese) The text string converted from single byte to double byte characters. |
| DETECTLANGUAGE (365) The language code for the text string provided. |
| DROP (2024) The array without certain rows or columns. |
| EUROCONVERT (Euro Currency Tools add-in) The number converted to euros. |
| EXPAND (2024) The array expanded or padded to specific dimensions. |
| FIELDVALUE (2024) The value in a particular field from a linked data type. |
| FILTERXML The specific data from the xml content by using xpath. |
| FORECAST.ETS The future value based on historical values. |
| FORECAST.ETS.CONFINT The confidence interval for a future value. |
| FORECAST.ETS.SEASONALITY The length of the repetitive seasonality pattern. |
| FORECAST.ETS.STAT The statistical value for a future value. |
| GROUPBY (365) The summary table after grouping and aggregating by row. |
| INFO The text string returning useful information about the environment. |
| ISOMITTED (2024) The boolean True or False depending whether the value in a LAMBDA is missing. |
| LET The result of a formula that can use variables. |
| MAKEARRAY (2024) The array calculated by applying a LAMBDA function. |
| NUMBERVALUE The number that a text string represents (current locale). |
| ODDFPRICE The price per $100 face value of a security with an odd first period. |
| ODDFYIELD The yield of a security with an odd first period. |
| ODDLPRICE The price per $100 face value of a security with an odd last period. |
| ODDLYIELD The yield of a security with an odd last period. |
| PERCENTOF (365) The percentage of a value compared to the total. |
| PHONETIC The phonetic characters from a text string. |
| PIVOTBY (365) The summary table after grouping and aggregating by row and column. |
| PY (365) The value or object after running code in a Python Editor using the Microsoft Cloud runtime. |
| RTD The real time data from a program that supports COM. |
| SHEET The sheet number of the referenced sheet. |
| SHEETS The number of sheets in a reference. |
| SORTBY The array of data that has been sorted based on multiple columns. |
| STOCKHISTORY (2024) The historical data about a financial instrument. |
| TAKE (2024) The array from taking the intersection of specific rows and columns. |
| TEXTAFTER (2024) The characters from the end of a text string after a delimiter. |
| TEXTBEFORE (2024) The characters from the start of a text string before a delimiter. |
| TEXTSPLIT (2024) The text string split into multiple columns using delimiters. |
| TOCOL (2024) The array transformed into a single column. |
| TOROW (2024) The array transformed into a single row. |
| TRANSLATE (365) The text string translated into another language. |
| TRIMRANGE (365) The array after excluding all empty rows and/or columns from the outer edges of a range. |
| VALUETOTEXT The value converted to text. |
| WEBSERVICE The results from a webservice. |
| WRAPCOLS (2024) The array transformed into multiple columns. |
| WRAPROWS (2024) The array transformed into multiple rows. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext