[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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:

AND(TRUE) results in TRUE
AND(TRUE,FALSE) results in FALSE
AND(10>5,3=1+2,5) results in TRUE
AND({10,5,6,7},TRUE,E6:F6) results in TRUE, when E6 contains TRUE and F6 contains 10

end example]