Boolean logic functions, commonly used to manipulate the results of comparisons and tests.

Description

The And function returns true if all of its arguments are true. The && operator is equivalent to And.

The Or function returns true if any of its arguments are true. The || operator is equivalent to Or.

The Not function returns true if its argument is false; it returns false if its argument is true. The ! operator is equivalent to Not.

These functions work with logical values. They can't be passed a number or a string directly; instead a comparison or test must be made. For example, a comparison such as x > 1 is a logical formula that evaluates to the Boolean value true if x is greater than 1. If x is less than 1, the formula evaluates to false.

Syntax

And( LogicalFormula1, LogicalFormula2 [, LogicalFormula3, ... ] )
Or( LogicalFormula1, LogicalFormula2 [, LogicalFormula3, ... ] )
Not( LogicalFormula )

  • LogicalFormula(s) - Required. Logical formulas to evaluate and operate on.

Examples

Step by step

Use this function to determine whether a slider's value falls outside the 50 to 100 range:

Or(Slider1.Value < 50, Slider1.Value> 100)

If a table contained a Dept column and a Salary column, you could use this function in a Result column to show true in all rows in which the value in the Dept column was HR or the value in the Salary column was larger than 200000:

Or(Dept = HR, Salary >= 200000)

As an alternative, use the || operator to get the same results as what the previous formulas return:

Slider1.Value < 50 || Slider1.Value> 100

Dept = "HR" || Salary > 200000