---
title: "Formulas"
slug: "formulas-overview"
tags: ["data-integration", "formulas"]
updated: 2026-09-14T17:47:39Z
published: 2026-09-14T17:47:39Z
canonical: "docs.unqork.io/formulas-overview"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.unqork.io/llms.txt
> Use this file to discover all available pages before exploring further.

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

> [!NOTE]
> 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.

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

## Formula Categories

- [Excel Formulas](/unqorkai/docs/excel-formulas): Standard Excel-compatible formulas for math, text, logic, dates, and more.
- [Unqork Formulas](/unqorkai/docs/unqork-formulas): Formulas unique to Unqork, including data manipulation, encoding, formatting, and regex utilities not found in Excel.
- [Moment.js Formulas](/unqorkai/docs/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. |

A Property ID is the unique field ID used by Unqork to track and link components in your module.

A JavaScript date library that lets you parse, validate, manipulate, and reformat dates.