### And operator

Basic and Crystal syntax.

##### Usage

`x And y`

Value of x | Value of y | x And y
--- | --- | ---
True | True | True
True | False | False
False | True | False
False | False | False

##### Examples

The following example is applicable to Crystal syntax:

If {file.CREDIT LIMIT} = 5000 and {file.SALESMAN} = "SP" Then
{file.AMOUNT}
Else
0

If the credit limit is 5000 and the salesman is SP (both conditions true), then returns the value in the {file.AMOUNT} field, otherwise return zero.

`A > B and B > C`

Returns TRUE, where A = 10, B = 6, and C = 3 (both conditions are true).

Returns FALSE, where A=10, B=6, and C=7 (only one of the two conditions are true).

`(A>B) and (A * C - D > E) and (E / D <= B)`

Returns TRUE, where A = 7, B = 5, C = 3, D = 2, E = 10 (all three of the conditions are true).

###### Related topics

Order of precedence (Basic syntax)

Order of precedence (Crystal syntax)

Formula 6

Formula 15

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com