Returns true if all inputs are true; returns false if at least one input is false.
and( value, … )
value: (Boolean Array) A value or array of values that must be true for the function to return true.
Boolean
Arguments are cast to Boolean before and() evaluates.
Multiple arguments are evaluated left-to-right.
As soon as the returned value of a value evaluation returns false, the function returns false.
By keeping common conditions on the left and complex edge cases on the right, you can improve function performance. That way, if an earlier, simple function returns false, evaluation of the later edge cases never occurs.
Null values that are part of input arrays are filtered out before evaluation.
Empty arrays evaluate to true.
Empty text strings in a text array evaluate to false, but empty text strings in an array with multiple data types are considered null values and are filtered out before evaluation.
You can experiment with this function in the test box below.
Test Input
Use functions to Pass Multiple Logical Values:
and(isleapyear(1996),isleapyear(1997)) returns false
Pass an Empty Array:
and({}) returns true
Pass an Array of Numbers:
and(1,2,"",3) returns true
and(0,1,2,"",3) returns false because 0 casts to false
On This Page
