AND
Syntax:
AND ( argument-list )
Description: Tests if all arguments in argument-list are TRUE.
Arguments:
Name |
Type |
Description |
|---|---|---|
argument-list |
logical, array, or cell reference |
The arguments in argument-list designate the values to be tested. For an array or cell reference, a cell that contains text or is empty shall be ignored. |
Return Type and Value: logical – TRUE if all arguments in argument-list are TRUE; otherwise, FALSE.
However, if no logical values are found, the return value is unspecified.
example: