beautypg.com

3 logical operators, 1 and, Logic and – Metrohm tiBase 1.1 User Manual

Page 47

background image

■■■■■■■■■■■■■■■■■■■■■■

2 General program functions

tiBase 1.1

■■■■■■■■

39

Operand1

Operand2

Result

Example

Remark

Text

Number

Text

"Metrohm" ^ 1.2 = invalid

This operation is not allowed.

Number

Time

Number

1.2 ^ Time(1900;02;03) = 586.198
(for UTC+1)

-

Time

Number

Number

Time(1999;10;7) ^ 2.5 =
253479847878.04
(for UTC+2)

-

Text

Time

Text

"Metrohm" ^ Time(1999;10;7) =
invalid

This operation is not allowed.

Time

Text

Text

Time(1999;10;7) ^ "Metrohm" =
invalid

This operation is not allowed.

2.4.4.3

Logical operators

2.4.4.3.1

AND

Dialog window: Formula editor

Operators/Functions

Syntax
Operand1 AND Operand2

The operands can be entered either directly or as a variable and can be of
the type Text, Number or Date/Time. The result type is always a num-
ber (1 = true, 0 = false). The following cases are possible:

Operand1

Operand2

Result

1

1

1

0

1

0

1

0

0

0

0

0

Examples

Oper-
and1

Oper-
and2

Result

Example

Remark

Operands of the same type:

Number

Number

Number

5 AND 4 --> 1

4 AND 0 --> 0

Numbers greater than 0 are interpreted as
1 (true).

Text

Text

Number

"Metrohm" AND "AG" --> 1

"" AND "AG" --> 0

An empty character string ("") is interpre-
ted as 0 (false), everything else as 1 (true).
The first operation therefore corresponds
to 1 AND 1 --> 1.

Time

Time

Number

Time(1999;10;07) AND
Time(1999;10;07) --> 1

Time(): see Time(Date)

Operands of a different type: