Type3 function support

The legacy Type3 service type supports a large number of Excel functions, but not the ones listed below. Excel functions introduced after April 6th 2022 are not included in this list.

Please note that the Type3 engine is no longer being developed. There are no plans to implement these functions in this service type in the future.

Please refer to Neuron function support for more information about which functions are supported by Neuron.

Type3 Unsupported Functions

Category	FunctIon
Add-in and Automation	CALL
	EUROCONVERT
	REGISTER.ID
Compatibility	BETADIST
	BETAINV
	FDIST
	FINV
	HYPGEOMDIST
	NEGBINOMDIST
	TDIST
	TINV
	TTEST
Cube	CUBEKPIMEMBER
	CUBEMEMBER
	CUBEMEMBERPROPERTY
	CUBERANKEDMEMBER
	CUBESET
	CUBESETCOUNT
	CUBEVALUE
Database	GETPIVOTDATA
Engineering	BESSELI
	BESSELJ
	BESSELK
	BESSELY
	COMPLEX
	ERF
	ERF.PRECISE
	ERFC
	ERFC.PRECISE
	IMABS
	IMAGINARY
	IMARGUMENT
	IMCONJUGATE
	IMCOS
	IMCOSH
	IMCOT
	IMCSC
	IMCSCH
	IMDIV
	IMEXP
	IMLN
	IMLOG10
	IMLOG2
	IMPOWER
	IMPRODUCT
	IMREAL
	IMSEC
	IMSECH
	IMSIN
	IMSINH
	IMSQRT
	IMSUB
	IMSUM
	IMTAN
Financial	AMORDEGRC
	AMORLINC
	DISC
	FVSCHEDULE
	INTRATE
	ISPMT
	ODDFPRICE
	ODDFYIELD
	ODDLPRICE
	ODDLYIELD
	PRICE
	PRICEDISC
	PRICEMAT
	RECEIVED
	STOCKHISTORY
	TBILLEQ
	TBILLPRICE
	TBILLYIELD
	VDB
	YIELDDISC
	YIELDMAT
Information	INFO
	ISOMITTED
Logical	BYCOL
	BYROW
	IFS
	LAMBDA
	LET
	MAKEARRAY
	MAP
	REDUCE
	SCAN
	SWITCH
Lookup and reference	ARRAYTOTEXT
	CHOOSECOLS
	CHOOSEROWS
	DROP
	EXPAND
	FILTER
	FORMULATEXT
	GETPIVOTDATA
	HSTACK
	RTD
	SORT
	SORTBY
	TAKE
	TOCOL
	TOROW
	UNIQUE
	VSTACK
	WRAPCOLS
	WRAPROWS
	XLOOKUP
	XMATCH
Math and trigonometry	MDETERM
	MINVERSE
	RANDARRAY
	SEQUENCE
Statistical	BETA.DIST
	BETA.INV
	BINOM.DIST.RANGE
	BINOM.INV
	CHISQ.DIST
	CHISQ.INV
	CONFIDENCE.T
	COVARIANCE.S
	CRITBINOM
	F.DIST
	F.DIST.RT
	F.INV
	F.INV.RT
	F.TEST
	FORECAST.ETS
	FORECAST.ETS.CONFINT
	FORECAST.ETS.SEASONALITY
	FORECAST.ETS.STAT
	FORECAST.LINEAR
	FTEST
	GAMMA
	GAMMALN.PRECISE
	GAUSS
	GROWTH
	HYPGEOM.DIST
	LOGNORM.DIST
	LOGNORMDIST
	MAXIFS
	MINIFS
	MODE.MULT
	NEGBINOM.DIST
	NORM.S.DIST
	PERCENTRANK.EXC
	PHI
	PROB
	SKEW.P
	T.DIST
	T.DIST.2T
	T.DIST.RT
	T.INV
	T.INV.2T
	T.TEST
	TREND
	TRIMMEAN
	WEIBULL.DIST
Text	ASC
	BAHTTEXT
	CONCAT
	DBCS
	JIS
	NUMBERVALUE
	PHONETIC
	TEXTAFTER
	TEXTBEFORE
	TEXTJOIN
	TEXTSPLIT
	VALUETOTEXT
Web	ENCODEURL
	FILTERXML
	WEBSERVICE