--- title: "Additional Formulas" slug: "additional-formulas" updated: 2025-09-25T19:00:14Z published: 2025-09-25T19:00:14Z canonical: "docs.unqork.io/additional-formulas" --- > ## 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. # Additional Formulas Unqork logic components let you use formulas in your configuration. [Components](/v1/docs/module-builder-component-library) that support formulas are the [Calculator](/v1/docs/calculator-component), [Initializer](/v1/docs/initializer-component), and [Data Workflow](/v1/docs/data-workflow-component) components. You can enter formulas into the Output table of the Calculator and Initializer components. Using formulas in the Data Workflow operator depends on the operators you configure. For example, the [Formula](//docs/formula-operator) operator supports formula configuration. Below is a list of Hot-Formula-Parser, Lodash, Moment.js, and VBA (Visual Basic for Applications) formulas. ## Hot-Formula-Parser Formulas The following formulas only exist in the hot-formula-parser library. They are not based on any Excel or VBA formulas. > [!TIP] > To learn more about the hot-formula-parser library, see the following documentation: ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D) [https://www.npmjs.com/package/hot-formula-parser](https://www.npmjs.com/package/hot-formula-parser) | Formula | Description | Syntax | Reference | | --- | --- | --- | --- | | ADD | Combines specified values and returns a new value. | **ADD**(number1, number2) | | | ARGS2ARRAY | Creates an array from individual fields or an object. This formula is useful for converting an object to a single-row table in a [Data Workflow](/v1/docs/data-workflow-component). | **ARGS2ARRAY**(value1, [value2], ...) | | | COUNTIN | Counts how many times a specified value exists in an array. | **COUNTIN**(array, value) | | | COUNTUNIQUE | Counts the number of unique values in a list of specified values and ranges. | **COUNTUNIQUE**(value1, [value2], ...) | | | DIVIDE | Divides one value by another value and returns the result. | **DIVIDE**(number1, number2) | | | E | Returns Euler's number (**e**). This value is approximately 2.71828. | **E**() | | | EQ | Determines whether a value is equal to the specified value. | **EQ**(value1, value2) | | | FLATTEN | Flattens a nested array. | **FLATTEN**(array1, [array2], ...) | | | GTE | Determines whether a number is greater than or equal to another number. | **GTE**(number1, number2) | | | HTML2TEXT | Converts an HTML string into plain text. | **HTML2TEXT**(value) | | | INTERVAL | Specifies the intervals on the horizontal axis of a chart. | **INTERVAL**(second) | | | ISBINARY | Returns true if the value is a binary type. | **ISBINARY**(value) | | | LT | Determines whether a value is less than the specified value. | **LT**(number1, number2) | | | LTE | Determines whether a value is less than or equal to the specified value. | **LTE**(number1, number2) | | | MINUS | Subtracts one or more values from the specified value. | **MINUS**(number1, number2) | | | MULTIPLY | Multiplies two values and returns the result. | **MULTIPLY**(number1, number2) | | | NE | Determines whether a value is not equal to the specified value. | **NE**(value1, value2) | | | NUMBERS | Filters numbers from an array. | **NUMBERS**(value1, [value2], ...) | | | POW | Raises a number to the base power and returns the result. | **POW**(base, exponent) | | | REFERENCE | References to a specific cell at a fixed row and column. | **REFERENCE**(context, reference) | | | REGEXEXTRACT | Extracts matching text strings based on a regular expression. | **REGEXEXTRACT**(text, regex_pattern, [re_flags]) | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D) [REGEXEXTRACT Function](/v1/docs/how-to-use-the-regexextract-regular-expression-formula) | | REGEXMATCH | Determines whether part of a text string matches a regular expression. | **REGEXMATCH**(text, regex_pattern, [full], [re_flags]) | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D) [REGEXMATCH Function](/v1/docs/how-to-use-the-regexmatch-regular-expression-formula) | | REGEXREPLACE | Replaces part of a text string with a different text string. | **REGEXREPLACE**(text, regex_pattern, replacement, [re_flags]) | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D) [Regex in Unqork](/v1/docs/using-regex-in-unqork) | | VARS | Estimates variance based on a sample. | **VARS**(value1, [value2], ...) | | ## Lodash Formulas | Formula | Description | Syntax | Reference | | --- | --- | --- | --- | | LODASH | JavaScript library containing utility functions for programming. | **LODASH**(method, arg1, [arg2], ...) | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D) [Using Lodash in Unqork](/v1/docs/using-lodash-in-unqork) ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D) [Lodash Documentation](https://lodash.com/docs/4.17.21) | ## Moment.js Formulas | Formula | Description | Syntax | Reference | | --- | --- | --- | --- | | MOMENT | JavaScript date library for parsing, validating, formatting, and manipulating dates. | **MOMENT**(moment_obj, method, arg1, [arg2], ...) | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D) [Manipulating Dates With Moment.js](/v1/docs/manipulating-dates-with-momentjs) ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D) [Moment.js Documentation](https://momentjs.com/docs/) | ## VBA (Visual Basic for Applications) Formulas | Formula | Description | Syntax | Reference | | --- | --- | --- | --- | | JOIN | Joins elements separated by a delimiter. | **JOIN**(array, delimiter) | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D) [JOIN Function](https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/join-function) | | RIGHT | Extracts a given number of characters from the right side of a text string. | **RIGHT**(text, number) | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D)[RIGHT Function](https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/right-function) | | SPLIT | Divides text by a specified number of characters or string, adding each part to a separate cell. | **SPLIT**(text, index) | ![](https://cdn.us.document360.io/15548f06-2fba-434c-b0c1-5df88317dbd7/Images/Documentation/link_out_icon(4).png?sv=2026-02-06&spr=https&st=2026-10-27T12%3A36%3A37Z&se=2026-10-27T13%3A36%3A37Z&sr=c&sp=r&sig=iXo5Qf9gjKDmlhdm3kAeGh9ye0bJBkKtOqNmiW6hC9U%3D)[SPLIT Function](https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/split-function) | HTML (Hyper Text Markup Language) is the standard markup language for for achieving font, color, graphic, and hyperlink effects when creating web pages. JavaScript is an object-oriented computer programming language. It is most-commonly used for interactive effects in the browser.