Math & Arithmetic

Formula Pro math functions with optional string concatenation support for formatted values.

---

ADD / PLUS

Adds numbers together. With enableStringConcatenation, concatenates strings when operands are non-numeric.

Syntax: ADD(operand1, operand2, ...) or PLUS(...)

Example:

ADD(5, 10, 15)

Result: 30

Example:

ADD(100, 50)

Result: 150

---

MINUS / SUBTRACT

Subtracts operands sequentially: first - second - third - ...

Syntax: MINUS(operand1, operand2, ...) or SUBTRACT(...)

Example:

MINUS(100, 30, 10)

Result: 60

---

MULTIPLY

Multiplies all operands. Returns product.

Syntax: MULTIPLY(operand1, operand2, ...)

Example:

MULTIPLY(5, 4, 2)

Result: 40

---

DIVIDE

Divides numbers. Wraps Formula.js DIVIDE (handles division by zero).

Syntax: DIVIDE(numerator, denominator)

Example:

DIVIDE(100, 4)

Result: 25

---

RAND_BETWEEN

Returns a random integer between min and max (inclusive).

Syntax: RAND_BETWEEN(min, max)

Example:

RAND_BETWEEN(1, 100)

Result: (varies) e.g. 42

---

Comparison Operators

Formula Pro provides comparison functions that work with both numbers and strings:

Function	Alias	Description
EQUAL	IS	a === b
NOT_EQUAL	IS_NOT	a !== b
LESS_THAN		a < b
LESS_THAN_OR_EQUAL		a <= b
GREATER_THAN		a > b
GREATER_THAN_OR_EQUAL		a >= b

Example:

IF(GREATER_THAN({item's Number}, 10), "High", "Low")

Example:

IF(IS({item's Status}, "Done"), "Complete", "Incomplete")

---

String Concatenation Mode

When enableStringConcatenation is enabled (in automation context), ADD and MINUS can concatenate strings:

• ADD with strings: concatenates without separator (e.g., "A" + "B" → "AB")

• MINUS with strings: joins with " - " (e.g., "A" - "B" → "A - B")

This supports formatted arithmetic patterns like "A - 5" where continued operations preserve the format.