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