Export (0) Print
Expand All
Expand Minimize

AND Function

Published: July 16, 2012

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).

AND(logical expression1,logical expression2,...,logical expressionN)

Parameters

Name

Required/Optional

Data Type

Description

logical expression

Required

String

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.

AND(Height > 1, PinX > 1)

Returns TRUE if both expressions are TRUE. Returns FALSE if either expression is FALSE.

Community Additions

ADD
Show:
© 2014 Microsoft