The first parameter.
TRUE if, and only if, one or more parameters are TRUE and FALSE otherwise.
Returns TRUE if one or more values are TRUE and FALSE otherwise. OR(FALSE, FALSE, FALSE)OR(FALSE; FALSE; FALSE) returns FALSE, as not a single parameter is TRUE, but OR(FALSE, TRUE, FALSE)OR(FALSE; TRUE; FALSE) returns TRUE.
The formula can also be written using the Calcapp-specific || operator:
|| is written between the values to test, instead of before
them, which can make formulas easier to read.
Returns 2 only if Field1.ValueField1,Value is 20 or Field2.ValueField2,Value is 40. Otherwise, 4 is returned. This example uses the || operator, which is specific to Calcapp, instead of the OR function.
Returns TRUE, because at least one element of the array is TRUE.
Returns FALSE, because no array element is TRUE.
Returns TRUE, because the third parameter is TRUE.
Returns whether one or more switch fields in the SwitchField1:SwitchField20SwitchField1:SwitchField20 range are toggled to their "on" positions.