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