The first parameter.
TRUE if, and only if, all parameters are TRUE and FALSE otherwise.
Returns TRUE if all parameters are TRUE and FALSE otherwise. AND(TRUE, TRUE, FALSE)AND(TRUE; TRUE; FALSE) returns FALSE, because not all parameters are TRUE, but AND(TRUE, TRUE, TRUE)AND(TRUE; TRUE; TRUE) 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 and Field2.ValueField2,Value is 40. Otherwise, 4 is returned. This example uses the && operator, which is specific to Calcapp, instead of the AND function.
Returns TRUE, because all elements of the array are TRUE.
Returns FALSE, because a single element of the array is FALSE.
Returns FALSE, because the second parameter is FALSE.
Returns TRUE only if all switch fields covered by the SwitchField1:SwitchField20SwitchField1:SwitchField20 range are toggled to their "on" positions.