Formulas

Unqork supports over 300 formulas in the Calculator component and Data Workflow formula operations. Formulas follow standard Excel syntax: they begin with = and use parentheses for arguments.

The formulas listed here are recognized by Unqork's formula engine. Most Excel-compatible formulas behave exactly as they do in Excel. Unqork-specific formulas should be verified in the environment before using in production — some might require Unqork's execution context to function correctly.

=SUM(field1, field2)
=IF(status="Active", "Yes", "No")
=DATEFORMAT(submittedDate, "MM/DD/YYYY")

Formula Categories

Excel Formulas: Standard Excel-compatible formulas for math, text, logic, dates, and more.
Unqork Formulas: Formulas unique to Unqork, including data manipulation, encoding, formatting, and regex utilities not found in Excel.
Moment.js Formulas: Date parsing, formatting, and arithmetic using the MOMENT() and DATEFORMAT() functions.

Syntax Rules

Formulas begin with =.
Arguments are separated by commas.
Text values are wrapped in double quotes: "value".
Field references use the component's Property ID directly: fieldName.
Nested formulas are supported: =ROUND(AVERAGE(score1, score2), 2).

All Formulas

Formula	Category
`ABS`	Excel — Math
`ACCRINT`	Excel — Financial
`ACOS`	Excel — Math
`ACOSH`	Excel — Math
`ACOT`	Excel — Math
`ACOTH`	Excel — Math
`ADD`	Excel — Math
`AGGREGATE`	Excel — Math
`ALPHARANGE`	Unqork
`AND`	Excel — Logical
`ARABIC`	Excel — Math
`ARGS2ARRAY`	Unqork
`ASIN`	Excel — Math
`ASINH`	Excel — Math
`ATAN`	Excel — Math
`ATAN2`	Excel — Math
`ATANH`	Excel — Math
`AVEDEV`	Excel — Statistical
`AVERAGE`	Excel — Statistical
`AVERAGEA`	Excel — Statistical
`AVERAGEIF`	Excel — Statistical
`AVERAGEIFS`	Excel — Statistical
`BASE`	Excel — Math
`BASE64`	Unqork
`BESSELI`	Excel — Engineering
`BESSELJ`	Excel — Engineering
`BESSELK`	Excel — Engineering
`BESSELY`	Excel — Engineering
`BETA.DIST`	Excel — Statistical
`BETA.INV`	Excel — Statistical
`BETADIST`	Excel — Statistical
`BETAINV`	Excel — Statistical
`BIN2DEC`	Excel — Engineering
`BIN2HEX`	Excel — Engineering
`BIN2OCT`	Excel — Engineering
`BINOM.DIST`	Excel — Statistical
`BINOM.DIST.RANGE`	Excel — Statistical
`BINOM.INV`	Excel — Statistical
`BINOMDIST`	Excel — Statistical
`BITAND`	Excel — Engineering
`BITLSHIFT`	Excel — Engineering
`BITOR`	Excel — Engineering
`BITRSHIFT`	Excel — Engineering
`BITXOR`	Excel — Engineering
`CEILING`	Excel — Math
`CEILINGMATH`	Excel — Math
`CEILINGPRECISE`	Excel — Math
`CHAR`	Excel — Text
`CHISQ.DIST`	Excel — Statistical
`CHISQ.DIST.RT`	Excel — Statistical
`CHISQ.INV`	Excel — Statistical
`CHISQ.INV.RT`	Excel — Statistical
`CHOOSE`	Excel — Lookup
`CLEAN`	Excel — Text
`CODE`	Excel — Text
`COLUMN`	Excel — Lookup
`COLUMNS`	Excel — Lookup
`COMBIN`	Excel — Math
`COMBINA`	Excel — Math
`COMPLEX`	Excel — Engineering
`CONCATENATE`	Excel — Text
`CONFIDENCE`	Excel — Statistical
`CONFIDENCE.NORM`	Excel — Statistical
`CONFIDENCE.T`	Excel — Statistical
`CONVERT`	Excel — Engineering
`CORREL`	Excel — Statistical
`COS`	Excel — Math
`COSH`	Excel — Math
`COT`	Excel — Math
`COTH`	Excel — Math
`COUNT`	Excel — Statistical
`COUNTA`	Excel — Statistical
`COUNTBLANK`	Excel — Statistical
`COUNTIF`	Excel — Statistical
`COUNTIFS`	Excel — Statistical
`COUNTIN`	Unqork
`COUNTUNIQUE`	Unqork
`COVARIANCE.P`	Excel — Statistical
`COVARIANCE.S`	Excel — Statistical
`CSC`	Excel — Math
`CSCH`	Excel — Math
`CUMIPMT`	Excel — Financial
`CUMPRINC`	Excel — Financial
`DATE`	Excel — Date & Time
`DATEADD`	Unqork
`DATEFORMAT`	Unqork
`DATEVALUE`	Excel — Date & Time
`DAY`	Excel — Date & Time
`DAYS`	Excel — Date & Time
`DAYS360`	Excel — Date & Time
`DB`	Excel — Financial
`DDB`	Excel — Financial
`DEC2BIN`	Excel — Engineering
`DEC2HEX`	Excel — Engineering
`DEC2OCT`	Excel — Engineering
`DECIMAL`	Excel — Math
`DEGREES`	Excel — Math
`DELTA`	Excel — Engineering
`DEVSQ`	Excel — Statistical
`DIVIDE`	Excel — Math
`DOLLAR`	Excel — Text
`DOLLARDE`	Excel — Financial
`DOLLARFR`	Excel — Financial
`DURATION`	Excel — Financial
`E`	Excel — Math
`EDATE`	Excel — Date & Time
`EFFECT`	Excel — Financial
`EOMONTH`	Excel — Date & Time
`EQ`	Excel — Logical
`ERF`	Excel — Engineering
`ERFC`	Excel — Engineering
`EVEN`	Excel — Math
`EXACT`	Excel — Text
`EXP`	Excel — Math
`EXPON.DIST`	Excel — Statistical
`EXPONDIST`	Excel — Statistical
`F.DIST`	Excel — Statistical
`F.DIST.RT`	Excel — Statistical
`F.INV`	Excel — Statistical
`F.INV.RT`	Excel — Statistical
`FACT`	Excel — Math
`FACTDOUBLE`	Excel — Math
`FALSE`	Excel — Logical
`FDIST`	Excel — Statistical
`FDISTRT`	Excel — Statistical
`FIND`	Excel — Text
`FINV`	Excel — Statistical
`FINVRT`	Excel — Statistical
`FISHER`	Excel — Statistical
`FISHERINV`	Excel — Statistical
`FIXED`	Excel — Text
`FLATTEN`	Unqork
`FLOOR`	Excel — Math
`FORECAST`	Excel — Statistical
`FREQUENCY`	Excel — Statistical
`FROMBASE64`	Unqork
`FV`	Excel — Financial
`FVSCHEDULE`	Excel — Financial
`GAMMA`	Excel — Statistical
`GAMMA.DIST`	Excel — Statistical
`GAMMA.INV`	Excel — Statistical
`GAMMADIST`	Excel — Statistical
`GAMMAINV`	Excel — Statistical
`GAMMALN`	Excel — Statistical
`GAMMALN.PRECISE`	Excel — Statistical
`GAUSS`	Excel — Statistical
`GCD`	Excel — Math
`GEOMEAN`	Excel — Statistical
`GESTEP`	Excel — Engineering
`GET`	Unqork
`GROUPBY`	Unqork
`GROWTH`	Excel — Statistical
`GTE`	Excel — Logical
`HARMEAN`	Excel — Statistical
`HEX2BIN`	Excel — Engineering
`HEX2DEC`	Excel — Engineering
`HEX2OCT`	Excel — Engineering
`HOUR`	Excel — Date & Time
`HTML2TEXT`	Unqork
`HYPGEOM.DIST`	Excel — Statistical
`HYPGEOMDIST`	Excel — Statistical
`IF`	Excel — Logical
`IMABS`	Excel — Engineering
`IMAGINARY`	Excel — Engineering
`IMARGUMENT`	Excel — Engineering
`IMCONJUGATE`	Excel — Engineering
`IMCOS`	Excel — Engineering
`IMCOSH`	Excel — Engineering
`IMCOT`	Excel — Engineering
`IMCSC`	Excel — Engineering
`IMCSCH`	Excel — Engineering
`IMDIV`	Excel — Engineering
`IMEXP`	Excel — Engineering
`IMLN`	Excel — Engineering
`IMLOG10`	Excel — Engineering
`IMLOG2`	Excel — Engineering
`IMPOWER`	Excel — Engineering
`IMPRODUCT`	Excel — Engineering
`IMREAL`	Excel — Engineering
`IMSEC`	Excel — Engineering
`IMSECH`	Excel — Engineering
`IMSIN`	Excel — Engineering
`IMSINH`	Excel — Engineering
`IMSQRT`	Excel — Engineering
`IMSUB`	Excel — Engineering
`IMSUM`	Excel — Engineering
`IMTAN`	Excel — Engineering
`INITIAL`	Unqork
`INT`	Excel — Math
`INTERCEPT`	Excel — Statistical
`INTERVAL`	Unqork
`IPMT`	Excel — Financial
`IRR`	Excel — Financial
`ISBINARY`	Unqork
`ISBLANK`	Excel — Information
`ISEVEN`	Excel — Information
`ISLOGICAL`	Excel — Information
`ISNONTEXT`	Excel — Information
`ISNUMBER`	Excel — Information
`ISODD`	Excel — Information
`ISOWEEKNUM`	Excel — Date & Time
`ISPMT`	Excel — Financial
`ISTEXT`	Excel — Information
`JOIN`	Unqork
`JOINKEYVALUE`	Unqork
`JOINKEYVALUEARRAY`	Unqork
`JSONPARSE`	Unqork
`KEYSARRAY`	Unqork
`KURT`	Excel — Statistical
`LABELVALUEARRAY`	Unqork
`LARGE`	Excel — Statistical
`LCM`	Excel — Math
`LEFT`	Excel — Text
`LEN`	Excel — Text
`LINEST`	Excel — Statistical
`LINKHEADERPARSE`	Unqork
`LN`	Excel — Math
`LODASH`	Unqork
`LOG`	Excel — Math
`LOG10`	Excel — Math
`LOGEST`	Excel — Statistical
`LOGNORM.DIST`	Excel — Statistical
`LOGNORM.INV`	Excel — Statistical
`LOGNORMDIST`	Excel — Statistical
`LOGNORMINV`	Excel — Statistical
`LOWER`	Excel — Text
`LT`	Excel — Logical
`LTE`	Excel — Logical
`MATCH`	Excel — Lookup
`MAX`	Excel — Statistical
`MAXA`	Excel — Statistical
`MEDIAN`	Excel — Statistical
`MID`	Excel — Text
`MIN`	Excel — Statistical
`MINA`	Excel — Statistical
`MINUS`	Excel — Math
`MINUTE`	Excel — Date & Time
`MIRR`	Excel — Financial
`MOD`	Excel — Math
`MODE.MULT`	Excel — Statistical
`MODE.SNGL`	Excel — Statistical
`MODEMULT`	Excel — Statistical
`MODESNGL`	Excel — Statistical
`MOMENT`	Moment.js
`MONTH`	Excel — Date & Time
`MROUND`	Excel — Math
`MULTINOMIAL`	Excel — Math
`MULTIPLY`	Excel — Math
`NE`	Excel — Logical
`NEGBINOM.DIST`	Excel — Statistical
`NEGBINOMDIST`	Excel — Statistical
`NETWORKDAYS`	Excel — Date & Time
`NOMINAL`	Excel — Financial
`NORM.DIST`	Excel — Statistical
`NORM.INV`	Excel — Statistical
`NORM.S.DIST`	Excel — Statistical
`NORM.S.INV`	Excel — Statistical
`NORMDIST`	Excel — Statistical
`NORMINV`	Excel — Statistical
`NORMSDIST`	Excel — Statistical
`NORMSINV`	Excel — Statistical
`NOT`	Excel — Logical
`NOW`	Excel — Date & Time
`NPER`	Excel — Financial
`NPV`	Excel — Financial
`NUMBERS`	Unqork
`NUMERAL`	Unqork
`OCT2BIN`	Excel — Engineering
`OCT2DEC`	Excel — Engineering
`OCT2HEX`	Excel — Engineering
`ODD`	Excel — Math
`OR`	Excel — Logical
`PDURATION`	Excel — Financial
`PEARSON`	Excel — Statistical
`PERCENTILEEXC`	Excel — Statistical
`PERCENTILEINC`	Excel — Statistical
`PERCENTRANKEXC`	Excel — Statistical
`PERCENTRANKINC`	Excel — Statistical
`PERMUT`	Excel — Math
`PERMUTATIONA`	Excel — Math
`PHI`	Excel — Statistical
`PHONENUMBER`	Unqork
`PI`	Excel — Math
`PMT`	Excel — Financial
`POISSON.DIST`	Excel — Statistical
`POISSONDIST`	Excel — Statistical
`POW`	Excel — Math
`POWER`	Excel — Math
`PPMT`	Excel — Financial
`PROB`	Excel — Statistical
`PRODUCT`	Excel — Math
`PROPER`	Excel — Text
`PV`	Excel — Financial
`QUARTILE.EXC`	Excel — Statistical
`QUARTILE.INC`	Excel — Statistical
`QUARTILEEXC`	Excel — Statistical
`QUARTILEINC`	Excel — Statistical
`QUOTIENT`	Excel — Math
`RADIANS`	Excel — Math
`RAND`	Excel — Math
`RANDBETWEEN`	Excel — Math
`RANK.AVG`	Excel — Statistical
`RANK.EQ`	Excel — Statistical
`RANKAVG`	Excel — Statistical
`RANKEQ`	Excel — Statistical
`RATE`	Excel — Financial
`REFERENCE`	Unqork
`REGEXEXTRACT`	Unqork
`REGEXMATCH`	Unqork
`REGEXREPLACE`	Unqork
`REPLACE`	Excel — Text
`REPT`	Excel — Text
`REST`	Unqork
`RIGHT`	Excel — Text
`ROMAN`	Excel — Text
`ROUND`	Excel — Math
`ROUNDDOWN`	Excel — Math
`ROUNDUP`	Excel — Math
`ROW`	Excel — Lookup
`ROWS`	Excel — Lookup
`RRI`	Excel — Financial
`RSQ`	Excel — Statistical
`SEARCH`	Excel — Text
`SEC`	Excel — Math
`SECH`	Excel — Math
`SECOND`	Excel — Date & Time
`SERIESSUM`	Excel — Math
`SIGN`	Excel — Math
`SIN`	Excel — Math
`SINH`	Excel — Math
`SKEW`	Excel — Statistical
`SKEW.P`	Excel — Statistical
`SKEWP`	Excel — Statistical
`SLN`	Excel — Financial
`SLOPE`	Excel — Statistical
`SMALL`	Excel — Statistical
`SPELLNUMBER`	Unqork
`SPLIT`	Unqork
`SQRT`	Excel — Math
`SQRTPI`	Excel — Math
`STANDARDIZE`	Excel — Statistical
`STDEV.P`	Excel — Statistical
`STDEV.S`	Excel — Statistical
`STDEVA`	Excel — Statistical
`STDEVP`	Excel — Statistical
`STDEVPA`	Excel — Statistical
`STDEVS`	Excel — Statistical
`STEYX`	Excel — Statistical
`STRINGIFY`	Unqork
`SUBSTITUTE`	Excel — Text
`SUBTOTAL`	Excel — Math
`SUM`	Excel — Math
`SUMIF`	Excel — Math
`SUMIFS`	Excel — Math
`SUMPRODUCT`	Excel — Math
`SUMSQ`	Excel — Math
`SUMX2MY2`	Excel — Math
`SUMX2PY2`	Excel — Math
`SUMXMY2`	Excel — Math
`SWITCH`	Excel — Logical
`SYD`	Excel — Financial
`T`	Excel — Text
`T.DIST`	Excel — Statistical
`T.DIST.2T`	Excel — Statistical
`T.DIST.RT`	Excel — Statistical
`T.INV`	Excel — Statistical
`T.INV.2T`	Excel — Statistical
`TAN`	Excel — Math
`TANH`	Excel — Math
`TBILLEQ`	Excel — Financial
`TBILLPRICE`	Excel — Financial
`TBILLYIELD`	Excel — Financial
`TDIST`	Excel — Statistical
`TDIST2T`	Excel — Statistical
`TDISTRT`	Excel — Statistical
`TEXT`	Excel — Text
`TEXTJOIN`	Excel — Text
`TIME`	Excel — Date & Time
`TIMEVALUE`	Excel — Date & Time
`TINV`	Excel — Statistical
`TINV2T`	Excel — Statistical
`TOBASE64`	Unqork
`TODAY`	Excel — Date & Time
`TRANSPOSE`	Excel — Lookup
`TREND`	Excel — Statistical
`TRIM`	Excel — Text
`TRIMMEAN`	Excel — Statistical
`TRUE`	Excel — Logical
`TRUNC`	Excel — Math
`UNICHAR`	Excel — Text
`UNICODE`	Excel — Text
`UNIQUE`	Unqork
`UPPER`	Excel — Text
`URLPARSE`	Unqork
`VALUE`	Excel — Text
`VAR.P`	Excel — Statistical
`VAR.S`	Excel — Statistical
`VARA`	Excel — Statistical
`VARP`	Excel — Statistical
`VARPA`	Excel — Statistical
`VARS`	Excel — Statistical
`WEEKDAY`	Excel — Date & Time
`WEEKNUM`	Excel — Date & Time
`WEIBULL.DIST`	Excel — Statistical
`WEIBULLDIST`	Excel — Statistical
`WORDWRAP`	Unqork
`WORDWRAPARRAY`	Unqork
`WORKDAY`	Excel — Date & Time
`XIRR`	Excel — Financial
`XNPV`	Excel — Financial
`XOR`	Excel — Logical
`YEAR`	Excel — Date & Time
`YEARFRAC`	Excel — Date & Time

Changelog

Date	Change
—	Initial publication.