DriveWorks Solo 15: And [send feedback...]

Syntax

AND( [ LogicalExpression1], [ LogicalExpression2], [ LogicalExpression n] )

Each logical expression is a rule that, when evaluated, returns either TRUE or FALSE.

There can be 1 to 255 logical expressions in any one AND function.

If all logical expressions return TRUE, then the AND function will return TRUE.

If at least one of the logical expressions returns FALSE, then the AND function will return FALSE.

Examples

Rule

Meaning

AND(LengthTextBoxReturn>=6, WidthTextBoxReturn=<5)

Checks the return value of the LengthTextBox and the return value of the WidthTextBox.

If the LengthTextBoxReturn is greater than or equal to 6, that logical expression will return TRUE.

If the WidthTextBoxReturn is less than or equal to 5, then that logical expression will return TRUE.

If both logical expressions return TRUE, then the AND function will return TRUE. If either one of them returns FALSE, then the AND function will return FALSE.

Example Outcomes

LengthTextBoxReturn>=6

WidthTextBoxReturn<=5

Result of the AND function

TRUETRUETRUE
TRUEFALSEFALSE
FALSETRUEFALSE
FALSEFALSEFALSE

Comparing Values

Operator

Meaning
<Checks to see if the value on the left hand side of the operator is less than the value on the right hand side, and if so, returns TRUE, otherwise returns FALSE.
<=Checks to see if the value on the left hand side of the operator is less than, or equal to, the value on the right hand side, and if so, returns TRUE, otherwise returns FALSE.
>Checks to see if the value on the left hand side of the operator is greater than the value on the right hand side, and if so, returns TRUE, otherwise returns FALSE.
>=Checks to see if the value on the left hand side of the operator is greater than, or equal to, the value on the right hand side, and if so, returns TRUE, otherwise returns FALSE.
<>Checks to see if the value on the left hand side of the operator is not equal to the value on the right hand side, and if so, returns TRUE, otherwise returns FALSE.
=Checks to see if the value on the left hand side of the operator is the same as the value on the right hand side, and if so, returns TRUE, otherwise returns FALSE.

Table of Contents