Supported Formulas in Windows Forms Calculation Engine

19 Aug 20214 minutes to read

The following are the list of formulas supported in Calculate library,

Database Function

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
DAVERAGE	yes	yes	yes	yes	yes	DAVERAGE
DCOUNT	yes	yes	yes	yes	yes	DCOUNT
DCOUNTA	yes	yes	yes	yes	yes	DCOUNTA
DGET	yes	yes	yes	yes	yes	DGET
DMAX	yes	yes	yes	yes	yes	DMAX
DMIN	yes	yes	yes	yes	yes	DMIN
DPRODUCT	yes	yes	yes	yes	yes	DPRODUCT
DSTDEVP	yes	yes	yes	yes	yes	DSTDEVP
DSTDEV	yes	yes	yes	yes	yes	DSTDEV
DSUM	yes	yes	yes	yes	yes	DSUM
DVAR	yes	yes	yes	yes	yes	DVAR
DVARP	yes	yes	yes	yes	yes	DVARP

Math Trigonometry Function

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
ABS	yes	yes	yes	yes	yes	ABS
ACOT	yes	yes	yes	yes	yes	ACOT
ACOTH	yes	yes	yes	yes	yes	ACOTH
ARABIC	yes	yes	yes	yes	yes	ARABIC
ACOS	yes	yes	yes	yes	yes	ACOS
ACOSH	yes	yes	yes	yes	yes	ACOSH
ASIN	yes	yes	yes	yes	yes	ASIN
ASINH	yes	yes	yes	yes	yes	ASINH
ATAN	yes	yes	yes	yes	yes	ATAN
ATAN2	yes	yes	yes	yes	yes	ATAN2
ATANH	yes	yes	yes	yes	yes	ATANH
BASE	yes	yes	yes	yes	yes	BASE
COMBIN	yes	yes	yes	yes	yes	COMBIN
COT	yes	yes	yes	yes	yes	COT
COTH	yes	yes	yes	yes	yes	COTH
CSC	yes	yes	yes	yes	yes	CSC
CSCH	yes	yes	yes	yes	yes	CSCH
COS	yes	yes	yes	yes	yes	COS
COSH	yes	yes	yes	yes	yes	COSH
COMBINA	yes	yes	yes	yes	yes	COMBINA
CEILING	yes	yes	yes	yes	yes	CEILING
CEILINGMATH	yes	yes	yes	yes	yes	CEILINGMATH
DECIMAL	yes	yes	yes	yes	yes	DECIMAL
DEGREES	yes	yes	yes	yes	yes	DEGREES
EVEN	yes	yes	yes	yes	yes	EVEN
EXP	yes	yes	yes	yes	yes	EXP
FACT	yes	yes	yes	yes	yes	FACT
FACTDOUBLE	yes	yes	yes	yes	yes	FACTDOUBLE
GCD	yes	yes	yes	yes	yes	GCD
INT	yes	yes	yes	yes	yes	INT
ISTEXT	yes	yes	yes	yes	yes	ISTEXT
LCM	yes	yes	yes	yes	yes	LCM
LN	yes	yes	yes	yes	yes	LN
LOG	yes	yes	yes	yes	yes	LOG
LOG10	yes	yes	yes	yes	yes	LOG10
MDETERM	yes	yes	yes	yes	yes	MDETERM
MINVERSE	yes	yes	yes	yes	yes	MINVERSE
MMULT	yes	yes	yes	yes	yes	MMULT
MUNIT	yes	yes	yes	yes	yes	MUNIT
MULTINOMIAL	yes	yes	yes	yes	yes	MULTINOMIAL
MOD	yes	yes	yes	yes	yes	MOD
MROUND	yes	yes	yes	yes	yes	MROUND
ODD	yes	yes	yes	yes	yes	ODD
POWER	yes	yes	yes	yes	yes	POWER
RADIANS	yes	yes	yes	yes	yes	RADIANS
RAND	yes	yes	yes	yes	yes	RAND
RANDBETWEEN	yes	yes	yes	yes	yes	RANDBETWEEN
SIGN	yes	yes	yes	yes	yes	SIGN
SEC	yes	yes	yes	yes	yes	SEC
SECH	yes	yes	yes	yes	yes	SECH
SERIESSUM	yes	yes	yes	yes	yes	SERIESSUM
SIN	yes	yes	yes	yes	yes	SIN
SINH	yes	yes	yes	yes	yes	SINH
SUBTOTAL	yes	yes	yes	yes	yes	SUBTOTAL
SQRTPI	yes	yes	yes	yes	yes	SQRTPI
PI	yes	yes	yes	yes	yes	PI
PRODUCT	yes	yes	yes	yes	yes	PRODUCT
QUOTIENT	yes	yes	yes	yes	yes	QUOTIENT
ROMAN	yes	yes	yes	yes	yes	ROMAN
ROUND	yes	yes	yes	yes	yes	ROUND
ROUNDUP	yes	yes	yes	yes	yes	ROUNDUP
ROUNDDOWN	yes	yes	yes	yes	yes	ROUNDDOWN
SQRT	yes	yes	yes	yes	yes	SQRT
SUMIF	yes	yes	yes	yes	yes	SUMIF
SUMIFS	yes	yes	yes	yes	yes	SUMIFS
SUMSQ	yes	yes	yes	yes	yes	SUMSQ
SUMX2MY2	yes	yes	yes	yes	yes	SUMX2MY2
SUMXMY2	yes	yes	yes	yes	yes	SUMXMY2
SUMX2PY2	yes	yes	yes	yes	yes	SUMX2PY2
SUMPRODUCT	yes	yes	yes	yes	yes	SUMPRODUCT
TAN	yes	yes	yes	yes	yes	TAN
TANH	yes	yes	yes	yes	yes	TANH
TRUNC	yes	yes	yes	yes	yes	TRUNC

Statistical Function

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
AVEDEV	yes	yes	yes	yes	yes	AVEDEV
AVERAGE	yes	yes	yes	yes	yes	AVERAGE
AVERAGEA	yes	yes	yes	yes	yes	AVERAGEA
AVERAGEIF	yes	yes	yes	yes	yes	AVERAGEIF
AVERAGEIFS	yes	yes	yes	yes	yes	AVERAGEIFS
BETA.DIST	yes	yes	yes	yes	yes	BETA.DIST
BETADIST	yes	yes	yes	yes	yes	BETADIST
BINOM.DIST	yes	yes	yes	yes	yes	BINOM.DIST
BINOMDIST	yes	yes	yes	yes	yes	BINOMDIST
BINOM.INV	yes	yes	yes	yes	yes	BINOM.INV
CHITEST	yes	yes	yes	yes	yes	CHITEST
CHIDIST	yes	yes	yes	yes	yes	CHIDIST
CHIINV	yes	yes	yes	yes	yes	CHIINV
CHISQ.TEST	yes	yes	yes	yes	yes	CHISQ.TEST
CHISQ.DIST	yes	yes	yes	yes	yes	CHISQ.DIST
CONFIDENCE.NORM	yes	yes	yes	yes	yes	CONFIDENCE.NORM
CONFIDENCE.T	yes	yes	yes	yes	yes	CONFIDENCE.T
COVAR	yes	yes	yes	yes	yes	COVAR
COVARIANCE.P	yes	yes	yes	yes	yes	COCOVARIANCE.P
COVARIANCE.S	yes	yes	yes	yes	yes	COCOVARIANCE.S
CHISQ.INV	yes	yes	yes	yes	yes	CHISQ.INV
CHISQ.DIST.RT	yes	yes	yes	yes	yes	CHISQ.DIST.RT
CHISQ.INV.RT	yes	yes	yes	yes	yes	CHISQ.INV.RT
CONFIDENCE	yes	yes	yes	yes	yes	CONFIDENCE
CORREL	yes	yes	yes	yes	yes	CORREL
COUNT	yes	yes	yes	yes	yes	COUNT
COUNTA	yes	yes	yes	yes	yes	COUNTA
COUNTBLANK	yes	yes	yes	yes	yes	COUNTBLANK
COUNTIF	yes	yes	yes	yes	yes	COUNTIF
CRITBINOM	yes	yes	yes	yes	yes	CRITBINOM
DEVSQ	yes	yes	yes	yes	yes	DEVSQ
EXPON.DIST	yes	yes	yes	yes	yes	EXPON.DIST
EXPONDIST	yes	yes	yes	yes	yes	EXPONDIST
F.DIST	yes	yes	yes	yes	yes	F.DIST
F.DIST.RT	yes	yes	yes	yes	yes	F.DIST.RT
F.INV.RT	yes	yes	yes	yes	yes	F.INV.RT
FDIST	yes	yes	yes	yes	yes	FDIST
FINV	yes	yes	yes	yes	yes	FINV
FISHER	yes	yes	yes	yes	yes	FISHER
FISHERINV	yes	yes	yes	yes	yes	FISHERINV
FORECAST	yes	yes	yes	yes	yes	FORECAST
GEOMEAN	yes	yes	yes	yes	yes	GEOMEAN
HARMEAN	yes	yes	yes	yes	yes	HARMEAN
INTERCEPT	yes	yes	yes	yes	yes	INTERCEPT
LARGE	yes	yes	yes	yes	yes	LARGE
LINEST	yes	yes	yes	yes	yes	LINEST
MAX	yes	yes	yes	yes	yes	MAX
MAXA	yes	yes	yes	yes	yes	MAXA
MEDIAN	yes	yes	yes	yes	yes	MEDIAN
MIN	yes	yes	yes	yes	yes	MIN
MINA	yes	yes	yes	yes	yes	MINA
GAMMA.DIST	yes	yes	yes	yes	yes	GAMMA.DIST
GAMMADIST	yes	yes	yes	yes	yes	GAMMADIST
GAMMA.INV	yes	yes	yes	yes	yes	GAMMA.INV
GAMMAINV	yes	yes	yes	yes	yes	GAMMAINV
GAMMALN	yes	yes	yes	yes	yes	GAMMALN
GAMMALN.PRECISE	yes	yes	yes	yes	yes	GAMMALN.PRECISE
GROWTH	yes	yes	yes	yes	yes	GROWTH
HYPGEOMDIST	yes	yes	yes	yes	yes	HYPGEOMDIST
HYPGEOM.DIST	yes	yes	yes	yes	yes	HYPGEOM.DIST
KURT	yes	yes	yes	yes	yes	KURT
LOGEST	yes	yes	yes	yes	yes	LOGEST
LOGINV	yes	yes	yes	yes	yes	LOGINV
LOGNORMDIST	yes	yes	yes	yes	yes	LOGNORMDIST
LOGNORM.DIST	yes	yes	yes	yes	yes	LOGNORM.DIST
LOGNORM.INV	yes	yes	yes	yes	yes	LOGNORM.INV
MAXIFS	yes	yes	yes	yes	yes	MAXIFS
MINIFS	yes	yes	yes	yes	yes	MINIFS
MODE	yes	yes	yes	yes	yes	MODE
MODE.MULT	yes	yes	yes	yes	yes	MODE.MULT
MODE.SNGL	yes	yes	yes	yes	yes	MODE.SNGL
NORM.DIST	yes	yes	yes	yes	yes	NORM.DIST
NORMDIST	yes	yes	yes	yes	yes	NORMDIST
NORMINV	yes	yes	yes	yes	yes	NORMINV
NORM.INV	yes	yes	yes	yes	yes	NORM.INV
NORMSDIST	yes	yes	yes	yes	yes	NORMSDIST
NORM.S.DIST	yes	yes	yes	yes	yes	NORM.S.DIST
NORMSINV	yes	yes	yes	yes	yes	NORMSINV
NORM.S.INV	yes	yes	yes	yes	yes	NORM.S.INV
NEGBINOMDIST	yes	yes	yes	yes	yes	NEGBINOMDIST
NEGBINOM.DIST	yes	yes	yes	yes	yes	NEGBINOM.DIST
PEARSON	yes	yes	yes	yes	yes	PEARSON
PERCENTILE	yes	yes	yes	yes	yes	PERCENTILE
PERCENTILE.EXC	yes	yes	yes	yes	yes	PERCENTILE.EXC
PERCENTILE.INC	yes	yes	yes	yes	yes	PERCENTILE.INC
PERCENTILE.RANK	yes	yes	yes	yes	yes	PERCENTILE.RANK
PERCENTRANK.INC	yes	yes	yes	yes	yes	PERCENTRANK.INC
PERCENTRANK.EXC	yes	yes	yes	yes	yes	PERCENTRANK.EXC
PERMUT	yes	yes	yes	yes	yes	PERMUT
PERMUTATIONA	yes	yes	yes	yes	yes	PERMUTATIONA
POISSON	yes	yes	yes	yes	yes	POISSON
POISSON.DIST	yes	yes	yes	yes	yes	POISSON.DIST
PROB	yes	yes	yes	yes	yes	PROB
QUARTILE	yes	yes	yes	yes	yes	QUARTILE
QUARTILE.EXC	yes	yes	yes	yes	yes	QUARTILE.EXC
QUARTILE.INC	yes	yes	yes	yes	yes	QUARTILE.INC
RANK	yes	yes	yes	yes	yes	RANK
RANK.EQ	yes	yes	yes	yes	yes	RANK.EQ
RANK.AVG	yes	yes	yes	yes	yes	RANK.AVG
RSQ	yes	yes	yes	yes	yes	RSQ
SKEW	yes	yes	yes	yes	yes	SKEW
SKEW.P	yes	yes	yes	yes	yes	SKEW.P
SLOPE	yes	yes	yes	yes	yes	SLOPE
SMALL	yes	yes	yes	yes	yes	SMALL
STANDARDIZE	yes	yes	yes	yes	yes	STANDARDIZE
STDEV	yes	yes	yes	yes	yes	STDEV
STDEV.P	yes	yes	yes	yes	yes	STDEV.P
STDEV.S	yes	yes	yes	yes	yes	STDEV.S
STDEVA	yes	yes	yes	yes	yes	STDEVA
STDEVPA	yes	yes	yes	yes	yes	STDEVPA
STEYX	yes	yes	yes	yes	yes	STEYX
T.DIST	yes	yes	yes	yes	yes	T.DIST
T.INV	yes	yes	yes	yes	yes	T.INV
TRIMMEAN	yes	yes	yes	yes	yes	TRIMMEAN
VAR	yes	yes	yes	yes	yes	VAR
VAR.P	yes	yes	yes	yes	yes	VAR.P
VARA	yes	yes	yes	yes	yes	VARA
VARPA	yes	yes	yes	yes	yes	VARPA
WEIBULL.DIST	yes	yes	yes	yes	yes	WEIBULL.DIST
ZTEST	yes	yes	yes	yes	yes	ZTEST
Z.TEST	yes	yes	yes	yes	yes	Z.TEST

Engineering Function

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
BESSELI	yes	yes	yes	yes	yes	BESSELI
BESSELJ	yes	yes	yes	yes	yes	BESSELJ
BESSELK	yes	yes	yes	yes	yes	BESSELK
BESSELY	yes	yes	yes	yes	yes	BESSELY
BIN2DEC	yes	yes	yes	yes	yes	BIN2DEC
BIN2HEX	yes	yes	yes	yes	yes	BIN2HEX
BIN2OCT	yes	yes	yes	yes	yes	BIN2OCT
BITAND	yes	yes	yes	yes	yes	BITAND
BITLSHIFT	yes	yes	yes	yes	yes	BITLSHIFT
BITOR	yes	yes	yes	yes	yes	BITOR
BITRSHIFT	yes	yes	yes	yes	yes	BITRSHIFT
BITXOR	yes	yes	yes	yes	yes	BITXOR
COMPLEX	yes	yes	yes	yes	yes	COMPLEX
CONVERT	yes	yes	yes	yes	yes	CONVERT
DEC2BIN	yes	yes	yes	yes	yes	DEC2BIN
DEC2OCT	yes	yes	yes	yes	yes	DEC2OCT
DEC2HEX	yes	yes	yes	yes	yes	DEC2HEX
DELTA	yes	yes	yes	yes	yes	DELTA
ERF	yes	yes	yes	yes	yes	ERF
ERF.PRECISE	yes	yes	yes	yes	yes	ERF.PRECISE
ERFC	yes	yes	yes	yes	yes	ERFC
ERFC.PRECISE	yes	yes	yes	yes	yes	ERFC.PRECISE
GESTEP	yes	yes	yes	yes	yes	GESTEP
HEX2BIN	yes	yes	yes	yes	yes	HEX2BIN
HEX2OCT	yes	yes	yes	yes	yes	HEX2OCT
HEX2DEC	yes	yes	yes	yes	yes	HEX2DEC
IMABS	yes	yes	yes	yes	yes	IMABS
IMARQUMENT	yes	yes	yes	yes	yes	IMARQUMENT
IMAGINARY	yes	yes	yes	yes	yes	IMAGINARY
IMCONJUGATE	yes	yes	yes	yes	yes	IMCONJUGATE
IMCOS	yes	yes	yes	yes	yes	IMCOS
IMCOSH	yes	yes	yes	yes	yes	IMCOSH
IMCOT	yes	yes	yes	yes	yes	IMCOT
IMCSC	yes	yes	yes	yes	yes	IMCSC
IMCSCH	yes	yes	yes	yes	yes	IMCSCH
IMDIV	yes	yes	yes	yes	yes	IMDIV
IMEXP	yes	yes	yes	yes	yes	IMEXP
IMLN	yes	yes	yes	yes	yes	IMLN
IMLOG10	yes	yes	yes	yes	yes	IMLOG10
IMLOG2	yes	yes	yes	yes	yes	IMLOG2
IMREAL	yes	yes	yes	yes	yes	IMREAL
IMPOWER	yes	yes	yes	yes	yes	IMPOWER
IMPRODUCT	yes	yes	yes	yes	yes	IMPRODUCT
IMSEC	yes	yes	yes	yes	yes	IMSEC
IMSECH	yes	yes	yes	yes	yes	IMSECH
IMSIN	yes	yes	yes	yes	yes	IMSIN
IMSINH	yes	yes	yes	yes	yes	IMSINH
IMSUB	yes	yes	yes	yes	yes	IMSUB
IMSQRT	yes	yes	yes	yes	yes	IMSQRT
IMSUM	yes	yes	yes	yes	yes	IMSUM
IMTAN	yes	yes	yes	yes	yes	IMTAN
OCT2BIN	yes	yes	yes	yes	yes	OCT2BIN
OCT2DEC	yes	yes	yes	yes	yes	OCT2DEC
OCT2HEX	yes	yes	yes	yes	yes	OCT2HEX

Date Time Function

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
DATE	yes	yes	yes	yes	yes	DATE
DATEDIF	yes	yes	yes	yes	yes	DATEDIF
DATEVALUE	yes	yes	yes	yes	yes	DATEVALUE
DAY	yes	yes	yes	yes	yes	DAY
DAYS	yes	yes	yes	yes	yes	DAYS
DAYS360	yes	yes	yes	yes	yes	DAYS360
EDATE	yes	yes	yes	yes	yes	EDATE
EOMONTH	yes	yes	yes	yes	yes	EOMONTH
HOUR	yes	yes	yes	yes	yes	HOUR
ISOWEEKNUM	yes	yes	yes	yes	yes	ISOWEEKNUM
MINUTE	yes	yes	yes	yes	yes	MINUTE
MONTH	yes	yes	yes	yes	yes	MONTH
NETWORKDAYS	yes	yes	yes	yes	yes	NETWORKDAYS
NETWORKDAYSINTL	yes	yes	yes	yes	yes	NETWORKDAYSINTL
NOW	yes	yes	yes	yes	yes	NOW
SECOND	yes	yes	yes	yes	yes	SECOND
TIME	yes	yes	yes	yes	yes	TIME
TIMEVALUE	yes	yes	yes	yes	yes	TIMEVALUE
TODAY	yes	yes	yes	yes	yes	TODAY
WEEKDAY	yes	yes	yes	yes	yes	WEEKDAY
WEEKNUM	yes	yes	yes	yes	yes	WEEKNUM
WORKDAY	yes	yes	yes	yes	yes	WORKDAY
WORKDAYINTL	yes	yes	yes	yes	yes	WORKDAYINTL

Text Function

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
ASC	yes	yes	yes	yes	yes	ASC
CHAR	yes	yes	yes	yes	yes	CHAR
CLEAN	yes	yes	yes	yes	yes	CLEAN
CODE	yes	yes	yes	yes	yes	CODE
CONCAT	yes	yes	yes	yes	yes	CONCAT
CONCATENATE	yes	yes	yes	yes	yes	CONCATENATE
EXACT	yes	yes	yes	yes	yes	EXACT
FIND	yes	yes	yes	yes	yes	FIND
FINDB	yes	yes	yes	yes	yes	FINDB
FIXED	yes	yes	yes	yes	yes	FIXED
JIS	yes	yes	yes	yes	yes	JIS
LEFT	yes	yes	yes	yes	yes	LEFT
LEFTB	yes	yes	yes	yes	yes	LEFTB
LEN	yes	yes	yes	yes	yes	LEN
LENB	yes	yes	yes	yes	yes	LENB
LOWER	yes	yes	yes	yes	yes	LOWER
MID	yes	yes	yes	yes	yes	MID
MIDB	yes	yes	yes	yes	yes	MIDB
NUMBERVALUE	yes	yes	yes	yes	yes	NUMBERVALUE
PROPER	yes	yes	yes	yes	yes	PROPER
REPLACE	yes	yes	yes	yes	yes	REPLACE
REPLACEB	yes	yes	yes	yes	yes	REPLACEB
REPT	yes	yes	yes	yes	yes	REPT
RIGHT	yes	yes	yes	yes	yes	RIGHT
RIGHTB	yes	yes	yes	yes	yes	RIGHTB
SEARCH	yes	yes	yes	yes	yes	SEARCH
SEARCHB	yes	yes	yes	yes	yes	SEARCHB
SUBSTITUTE	yes	yes	yes	yes	yes	SUBSTITUTE
T	yes	yes	yes	yes	yes	T
TEXT	yes	yes	yes	yes	yes	TEXT
TEXTJOIN	yes	yes	yes	yes	yes	TEXTJOIN
TRIM	yes	yes	yes	yes	yes	TRIM
UNICHAR	yes	yes	yes	yes	yes	UNICHAR
UNICODE	yes	yes	yes	yes	yes	UNICODE
UPPER	yes	yes	yes	yes	yes	UPPER
VALUE	yes	yes	yes	yes	yes	VALUE

Logical Function

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
AND	yes	yes	yes	yes	yes	AND
IF	yes	yes	yes	yes	yes	IF
IFS	yes	yes	yes	yes	yes	IFS
FALSE	yes	yes	yes	yes	yes	FALSE
IFERROR	yes	yes	yes	yes	yes	IFERROR
IFNA	yes	yes	yes	yes	yes	IFNA
NOT	yes	yes	yes	yes	yes	NOT
SWITCH	yes	yes	yes	yes	yes	SWITCH
TRUE	yes	yes	yes	yes	yes	TRUE
XOR	yes	yes	yes	yes	yes	XOR
OR	yes	yes	yes	yes	yes	OR

Lookup And Reference

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
ADDRESS	yes	yes	yes	yes	yes	ADDRESS
AREAS	yes	yes	yes	yes	yes	AREAS
CHOOSE	yes	yes	yes	yes	yes	CHOOSE
COLUMN	yes	yes	yes	yes	yes	COLUMN
COLUMNS	yes	yes	yes	yes	yes	COLUMNS
FORMULATEXT	yes	yes	yes	yes	yes	FORMULATEXT
HLOOKUP	yes	yes	yes	yes	yes	HLOOKUP
HYPERLINK	yes	yes	yes	yes	yes	HYPERLINK
INDEX	yes	yes	yes	yes	yes	INDEX
INDIRECT	yes	yes	yes	yes	yes	INDIRECT
OFFSET	yes	yes	yes	yes	yes	OFFSET
LOOKUP	yes	yes	yes	yes	yes	LOOKUP
TRANSPOSE	yes	yes	yes	yes	yes	TRANSPOSE
VLOOKUP	yes	yes	yes	yes	yes	VLOOKUP
ROW	yes	yes	yes	yes	yes	ROW
ROWS	yes	yes	yes	yes	yes	ROWS
SHEET	yes	yes	yes	yes	yes	SHEET
SHEETS	yes	yes	yes	yes	yes	SHEETS

Information Function

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
CELL	yes	yes	yes	yes	yes	CELL
ERROR.TYPE	yes	yes	yes	yes	yes	ERROR.TYPE
ISBLANK	yes	yes	yes	yes	yes	ISBLANK
ISERR	yes	yes	yes	yes	yes	ISERR
ISERROR	yes	yes	yes	yes	yes	ISERROR
ISLOGICAL	yes	yes	yes	yes	yes	ISLOGICAL
ISNA	yes	yes	yes	yes	yes	ISNA
ISNONTEXT	yes	yes	yes	yes	yes	ISNONTEXT
ISNUMBER	yes	yes	yes	yes	yes	ISNUMBER
INFO	yes	yes	yes	yes	yes	INFO
ISFORMULA	yes	yes	yes	yes	yes	ISFORMULA
ISODD	yes	yes	yes	yes	yes	ISODD
ISEVEN	yes	yes	yes	yes	yes	ISEVEN
ISREF	yes	yes	yes	yes	yes	ISREF
MATCH	yes	yes	yes	yes	yes	MATCH
N	yes	yes	yes	yes	yes	N
NA	yes	yes	yes	yes	yes	NA
TYPE	yes	yes	yes	yes	yes	TYPE

Web Function

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
EncodeURL	yes	yes	yes	-	-	EncodeURL
WEBSERVICE	yes	yes	yes	-	-	WEBSERVICE
FILTERXML	yes	yes	yes	-	-	FILTERXML

Financial Function

FORMULA	WinForms	WPF	UWP	Xamarin.Forms	.NET Core	Reference
ACCRINT	yes	yes	yes	yes	yes	ACCRINT
CUMIPMT	yes	yes	yes	yes	yes	CUMIPMT
CUMPRINC	yes	yes	yes	yes	yes	CUMPRINC
EFFECT	yes	yes	yes	yes	yes	EFFECT
DB	yes	yes	yes	yes	yes	DB
DDB	yes	yes	yes	yes	yes	DDB
DISC	yes	yes	yes	yes	yes	DISC
DOLLAR	yes	yes	yes	yes	yes	DOLLAR
DOLLARFR	yes	yes	yes	yes	yes	DOLLARFR
DURATION	yes	yes	yes	yes	yes	DURATION
FV	yes	yes	yes	yes	yes	FV
FVSCHEDULE	yes	yes	yes	yes	yes	FVSCHEDULE
IPMT	yes	yes	yes	yes	yes	IPMT
INRATE	yes	yes	yes	yes	yes	INRATE
ISPMT	yes	yes	yes	yes	yes	ISPMT
IRR	yes	yes	yes	yes	yes	IRR
MIRR	yes	yes	yes	yes	yes	MIRR
NPER	yes	yes	yes	yes	yes	NPER
NPV	yes	yes	yes	yes	yes	NPV
PMT	yes	yes	yes	yes	yes	PMT
PPMT	yes	yes	yes	yes	yes	PPMT
PV	yes	yes	yes	yes	yes	PV
RATE	yes	yes	yes	yes	yes	RATE
RECEIVED	yes	yes	yes	yes	yes	RECEIVED
RRI	yes	yes	yes	yes	yes	RRI
SLN	yes	yes	yes	yes	yes	SLN
SYD	yes	yes	yes	yes	yes	SYD
VDB	yes	yes	yes	yes	yes	VDB
XIRR	yes	yes	yes	yes	yes	XIRR