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.
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	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) 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	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	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.
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 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) 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 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 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.