and()

Read(2417) Label: and,

Description:

Perform bitwise operation on integers.

Syntax:

and(xi,…)

and(A)

Note:

The function performs bitwise operation on integers. It supports the decimal data without the fractional part.

Parameter:

A

A sequence.

xi

The numerical expression based on which you perform the bitwise AND operation.

Return value:

Integer

Example:

 

A

 

1

=and(6,11)

2.

2

=and([11,13,15])

9.

3

=and(decimal(6),11)

2, which is the decimal type.

4

=and(decimal(6),decimal(11))

2, which is the decimal type.