Logical Operators

These operators are widely used in Formulas. For example, in an IF formula, you can use = to check whether one variable is equal to another or to a constant value and take an action based on this, or you can use > to check whether one value is greater than another.

• = Equal to: This operator checks whether two values are equal. If the values are equal, it returns true; otherwise, it returns false.

• <> Not equal to: This operator checks whether two values are different. If the values are different, it returns true; otherwise, it returns false.

• Operators used for Numerical Comparisons:

  • >= Greater than or equal to: checks that the value on the left is greater than or equal to the value on the right

  • > Greater than: checks that the value on the left is strictly greater than the value on the right

  • <= Less than or equal to: checks if the value on the left is less than or equal to the value on the right

  • < Less than: checks if the value on the left is strictly less than the value on the right.

Usage example:

= Equal to:

<> Not equal to:

>= Greater than or equal to:

> Greater than:

<= Less than or equal to:

< Less than: