Boolean logic functions, commonly used to manipulate the results of comparisons and tests.
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.
And( LogicalFormula1, LogicalFormula2 [, LogicalFormula3, ... ] )
Or( LogicalFormula1, LogicalFormula2 [, LogicalFormula3, ... ] )
Not( LogicalFormula )
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