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 (straight-line, implicit coefficient). |
| AREAS | The number of areas in a cell range or reference. |
| ARRAYTOTEXT | (2024) 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. |
| 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. |
| DBCS | (Japanese) The text string converted from single byte to double byte characters. |
| DROP | (2024) The array without certain rows or columns. |
| EUROCONVERT | (Euro Currency Tools add-in) The number converted to euros. |
| 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. |
| 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 | (2021) 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. |
| PHONETIC | The phonetic characters from a text string. |
| REGEXTEST | (365) Preview. The boolean True or False depending if the regular expression matches any part of a text string. |
| 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 | (2021) The array of data that has been sorted based on multiple columns. |
| STOCKHISTORY | (2024) The historical data about a financial instrument. |
| 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. |
| VALUETOTEXT | (2024) 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 (straight-line, implicit coefficient). |
| AREAS The number of areas in a cell range or reference. |
| ARRAYTOTEXT (2024) 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. |
| 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. |
| DBCS (Japanese) The text string converted from single byte to double byte characters. |
| DROP (2024) The array without certain rows or columns. |
| EUROCONVERT (Euro Currency Tools add-in) The number converted to euros. |
| 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. |
| 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 (2021) 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. |
| PHONETIC The phonetic characters from a text string. |
| REGEXTEST (365) Preview. The boolean True or False depending if the regular expression matches any part of a text string. |
| 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 (2021) The array of data that has been sorted based on multiple columns. |
| STOCKHISTORY (2024) The historical data about a financial instrument. |
| 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. |
| VALUETOTEXT (2024) 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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext