3 logical operators, 1 and, Logic and – Metrohm tiBase 1.1 User Manual
Page 47
■■■■■■■■■■■■■■■■■■■■■■
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: