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: