Excel Only
The following Excel functions are not available in Google Sheets.
AGGREGATE | The aggregate of values in a list, table or cell range. |
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 | (Microsoft 365) The contents of an array or cell ranges converted into text. |
BAHTTEXT | The number converted to a Thai text string and appends '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 | (2013) The probability of a trial result using a binomial 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. |
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 | (2013) The text string converted from single byte to double byte characters. |
DROP | (Microsoft 365) The array without certain rows or columns. |
EUROCONVERT | The number converted to euros. |
FIELDVALUE | (Microsoft 365) The value in a particular field from a linked data type. |
FILTERXML | (2013) The specific data from the xml content by using xpath. |
FORECAST.ETS | (2016) The future value based on historical values. |
HSTACK | (Microsoft 365) The array after putting multiple arrays next to each other. |
INFO | The text string returning useful information about the environment. |
ISOMITTED | (Microsoft 365) 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 | (Microsoft 365) The array calculated by applying a LAMBDA function. |
NUMBERVALUE | (2013) 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. |
RTD | The real time data from a program that supports COM. |
SHEET | (2013) The sheet number of the referenced sheet. |
SHEETS | (2013) The number of sheets in a reference. |
SORTBY | (2021) The array of data that has been sorted based on multiple columns. |
STOCKHISTORY | (Microsoft 365) The historical data about a financial instrument. |
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. |
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. |
VALUETOTEXT | (Microsoft 365) The value converted to text. |
VSTACK | (Microsoft 365) The array after putting multiple arrays on top of each other. |
WEBSERVICE | (2013) The results from a webservice. |
WRAPCOLS | (Microsoft 365) The array transformed into multiple columns. |
WRAPROWS | (Microsoft 365) The array transformed into multiple rows. |
AGGREGATE The aggregate of values in a list, table or cell range. |
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 (Microsoft 365) The contents of an array or cell ranges converted into text. |
BAHTTEXT The number converted to a Thai text string and appends '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 (2013) The probability of a trial result using a binomial 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. |
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 (2013) The text string converted from single byte to double byte characters. |
DROP (Microsoft 365) The array without certain rows or columns. |
EUROCONVERT The number converted to euros. |
FIELDVALUE (Microsoft 365) The value in a particular field from a linked data type. |
FILTERXML (2013) The specific data from the xml content by using xpath. |
FORECAST.ETS (2016) The future value based on historical values. |
HSTACK (Microsoft 365) The array after putting multiple arrays next to each other. |
INFO The text string returning useful information about the environment. |
ISOMITTED (Microsoft 365) 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 (Microsoft 365) The array calculated by applying a LAMBDA function. |
NUMBERVALUE (2013) 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. |
RTD The real time data from a program that supports COM. |
SHEET (2013) The sheet number of the referenced sheet. |
SHEETS (2013) The number of sheets in a reference. |
SORTBY (2021) The array of data that has been sorted based on multiple columns. |
STOCKHISTORY (Microsoft 365) The historical data about a financial instrument. |
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. |
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. |
VALUETOTEXT (Microsoft 365) The value converted to text. |
VSTACK (Microsoft 365) The array after putting multiple arrays on top of each other. |
WEBSERVICE (2013) The results from a webservice. |
WRAPCOLS (Microsoft 365) The array transformed into multiple columns. |
WRAPROWS (Microsoft 365) The array transformed into multiple rows. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext