Metrohm tiamo 2.4 (process analysis) - Manual (Page 78)

2.4 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
62 ￭￭￭￭￭￭￭￭
tiamo 2.4 (for Process Analysis)
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: