Math operators

Reference for all math and numeric operators supported in Noloco formula fields, including +, -, *, /, ABS, CEILING, FLOOR, ROUND, ROUNDUP, ROUNDDOWN, INT, EVEN, ODD, MOD, POWER, SQRT, LOG, FACT, SIGN

All math and numeric operators supported in Noloco formulas. Use these for arithmetic, rounding, powers, and aggregation.

Available operators: +, -, /, *, ABS, CEILING, DECIMAL, EVEN, FACT, FLOOR, INT, LOG, MOD, ODD, POWER, PRODUCT, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SQRT, SUM, TRUNC.

---

+

value1 + value2

Adds the values on either side.

Example: 10 + 2

-

value1 - value2

Subtracts the values on either side.

Example: 10 - 2

*

value1 * value2

Multiplies the values on either side.

Example: 10 * 2

/

value1 / value2

Divides the values on either side.

Example: 10 / 2

ABS

ABS(number)

Returns the absolute value of a number.

CEILING

CEILING(number, significance)

Rounds a number up to the closest multiple of significance.

DECIMAL

DECIMAL(text)

Converts text representation of a number to a decimal.

EVEN

EVEN(number)

Rounds a number to the nearest even integer.

FACT

FACT(number)

Returns the factorial of a number.

FLOOR

FLOOR(number, significance)

Rounds a number down to the closest multiple of significance.

INT

INT(number)

Rounds a number down to the nearest integer (less than or equal).

LOG

LOG(number, base)

Logarithm of a number for a provided base.

MOD

MOD(number, divisor)

Modulo of a number.

ODD

ODD(number)

Rounds a number to the nearest odd integer.

POWER

POWER(number, power)

Raises a number to a power.

PRODUCT

PRODUCT(number, number2, ...)

Multiplies the arguments together.

ROUND

ROUND(number, places)

Rounds a number to the closest value for a given number of decimal places.

ROUNDDOWN

ROUNDDOWN(number, places)

Rounds a number down for a given number of decimal places.

ROUNDUP

ROUNDUP(number, places)

Rounds a number up for a given number of decimal places.

SIGN

SIGN(number)

Returns the sign of a number:

• -1 if the number is negative

• 0 if zero

• 1 if positive

SQRT

SQRT(number)

Returns the positive square root of a positive number.

SUM

SUM(number, number2, ...)

Sums the arguments.

TRUNC

TRUNC(number)

Returns the integer component of a number.

---

Related

• Formulas overview

• Examples — see "Calculations"

• Date & time operators

• Logic operators

• Text operators