Excel Only
The following functions are only available in Microsoft Excel.
| 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