1. Home
  2. /
  3. Fields
  4. /
  5. Create Formula Field
  6. /
  7. Use the Formula Operators

Use the Formula Operators

Operator Description
Add Calculates the sum of two values.
Substract Calculates the difference of two values.
Multiply Multiplies its values.
MAX Display the highest value of the field you selected.
MIN Display the lowest value of the field you selected.
Divide Divides its values.
Exponentiation Raises a number to a power of a specified number.
Open Parenthesis Specifies that the expressions within the open parenthesis is evaluated first.
Close Parenthesis Specifies that the expressions within the close parenthesis is evaluated the last.
Abs Calculates the absolute value of a number. The absolute value of a number is the number without its positive or negative sign.
Equals Evaluates if two values are equivalent.
Not Equal To Evaluates if two values are not equivalent.
Less Than Evaluates if a value is less than the value that follows this symbol.
Greater Than Evaluates if a value is greater than the value that follows this symbol.
Less Or Equal Evaluates if a value is less than or equal to the value that follows this symbol.
And Evaluates if two values or expressions are both true. Use this operator as an alternative to the logical function AND.
Or Evaluates if at least one of multiple values or expressions is true. Use this operator as an alternative to the logical function OR.

Was this article helpful to you? No Yes

How can we help?