Determines if the specified logical expressions are true.
And( [LogicalExpression1], [LogicalExpression2], [LogicalExpression n] )
Where:
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.
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. |
LengthTextBoxReturn>=6 | WidthTextBoxReturn<=5 | Result of the AND function |
|---|---|---|
| TRUE | TRUE | TRUE |
| TRUE | FALSE | FALSE |
| FALSE | TRUE | FALSE |
| FALSE | FALSE | FALSE |
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. |