3 logical operators, 1 and, Logic and – Metrohm tiamo 2.3 Patch 1 (process analysis) User Manual

Page 79

Advertising
background image

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

2 General program functions

tiamo 2.3 Patch 1 (for Process Analysis)

■■■■■■■■

63

Examples

Operand1

Operand2

Result

Example

Remark

Operands of the same type:

Number

Number

Number

1.2 ^ 3 = 1.728

Complex results (which com-
prise +bi, i.e. a real and an
imaginary component) are dis-
played as an error.

Text

Text

Text

"Metrohm" ^ "AG" = invalid

This operation is not allowed.

Time

Time

Number

Time(1900;01;05) ^
Time(1900;01;02) = 196.371
(for UTC
+1)

Result: Number of days calcula-
ted from December 1899,
dependent on the system time

Operand of different type: The operand which does not correspond to the result type is converted to the relevant
result type before the operation.

Number

Text

Text

1.2 ^ "Metrohm" = invalid

This operation is not allowed.

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

Advertising