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

Page 46

Advertising
background image

2.4 Formula editor

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

38

■■■■■■■■

tiBase 1.0

Operand1

Operand2

Result

Example

Remark

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 number
(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:

Advertising