AND function
Returns TRUE (1) if all of the logical expressions supplied are TRUE. If any of the logical expressions are FALSE or 0, the AND function returns FALSE (0).
Syntax
|
AND(logical expression1,logical expression2,...,logical expressionN) | |
|
logical expression |
A combination of constants, operators, functions, and references to ShapeSheet cells that results in a value. Any expression that evaluates to a non-zero value is considered to be TRUE. |
Example
AND(Height > 1, PinX > 1)
Returns TRUE if both expressions are TRUE. Returns FALSE if either expression is FALSE.