LOGICAL FUNCTIONS

Checks whether every item in a series of conditions (logical arguments) is true.

If all the arguments are true, then AND returns TRUE.

If any of the arguments is false, then AND returns FALSE.

Syntax

AND (Logical1, [Logical2],...)

Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.

Data Types of the Arguments

True/False

Data Type of the Result

True/False

Example

Determine if both Beam length properties (Length Left and Length Right) exceed a given length.

Expression

AND (Length Left > 480 cm, Length Right > 480 cm)

Result

True or False. True for all Beams where both Beam lengths exceed the value, otherwise False.

Note

The AND function examines a series of arguments. Within the parentheses, each item must be a logical argument that can be either true or false.