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(number)
Returns the absolute value of a number.
CEILING(number, significance)
Rounds a number up to the closest multiple of significance.
DECIMAL(text)
Converts text representation of a number to a decimal.
EVEN(number)
Rounds a number to the nearest even integer.
FACT(number)
Returns the factorial of a number.
FLOOR(number, significance)
Rounds a number down to the closest multiple of significance.
INT(number)
Rounds a number down to the nearest integer (less than or equal).
LOG(number, base)
Logarithm of a number for a provided base.
MOD(number, divisor)
Modulo of a number.
ODD(number)
Rounds a number to the nearest odd integer.
POWER(number, power)
Raises a number to a power.
PRODUCT(number, number2, ...)
Multiplies the arguments together.
ROUND(number, places)
Rounds a number to the closest value for a given number of decimal places.
ROUNDDOWN(number, places)
Rounds a number down for a given number of decimal places.
ROUNDUP(number, places)
Rounds a number up for a given number of decimal places.
SIGN(number)
Returns the sign of a number:
-1 if the number is negative
0 if zero
1 if positive
SQRT(number)
Returns the positive square root of a positive number.
SUM(number, number2, ...)
Sums the arguments.
TRUNC(number)
Returns the integer component of a number.
Examples — see "Calculations"
Last updated
Was this helpful?
Was this helpful?
