AND Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

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.

Show: