Metrohm tiBase 1.1 - Manual (Page 48)

2.4 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
40 ￭￭￭￭￭￭￭￭
tiBase 1.1
Oper-
and1 Oper-
and2 Result Example Remark
Number Text Number 1.2 AND "1.2" --> 1
0 AND "1" --> 1
0 AND "0" --> 1
0 AND "" --> 0
Before the operation, the operand of the
type Number is converted to the type
Text, as a conversion from Text to Num-
ber is not advisable. During the second
operation, the 0 is therefore converted to
"0", which corresponds to the logical
value 1 (true), as every character string
that is not empty is interpreted as 1.
Text Number Number "Metrohm" AND 1.2 --> 1 The same rules apply here as for the previ-
ous operation.
Number Time Number 2.0 AND Time(1999;10;7) -->
1
0 AND Time(1999;10;07) --> 0
Before the operation, the operand of the
type Date/Time is converted to Number
and all data from December 30, 1899 are
interpreted as 1 (true).
Time Number Number Time(1999;10;7) AND 2.5 -->
1 The same rules apply here as for the previ-
ous operation.
Text Time Number "Metrohm" AND
Time(1999;10;7) --> 1
"" AND Time(1999;10;07) -->
0
Before execution of the operation, the
operand of the type Date/Time is conver-
ted to the type Text and every character
string that is not empty is interpreted as 1
(true).
Time Text Number Time(1999;10;7) AND
"Metrohm" --> 1 The same rules apply here as for the previ-
ous operation.
2.4.4.3.2 OR
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 OR 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 1
1 0 1
0 0 0
Examples
Operand1 Operand2 Result Example Remark
Operands of the same type: