Metrohm viva 1.0 (process analysis) - Manual (Page 54)

2.3 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
42 ￭￭￭￭￭￭￭￭
viva 1.0 (for Process analysis)
Operand1 Operand2 Result Example Remark
Number Time Number 2.0 OR Time(1999;10;7) --> 1
0 OR Time(1964;02;03) --> 1
Before the operation, the operand of
the Date/Time type is converted to
Number and all dates since December
30, 1899 are interpreted as 1 (true).
Time Number Number Time(1999;10;7) OR 2.5 --> 1 The same rules apply here as for the pre-
vious operation.
Text Time Number "Metrohm" OR
Time(1999;10;7) --> 1 Before the operation is carried out, the
operand of the Date/Time type is con-
verted to the Text type, and every non-
empty character string is interpreted as
1 (true).
Time Text Number Time(1999;10;7) OR
"Metrohm" --> 1 The same rules apply here as for the pre-
vious operation.
2.3.4.4 Relational operators
2.3.4.4.1 Equal to
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 = Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type. The result type is always a num-
ber (1 = true, 0 = false).
Examples
Oper-
and1 Oper-
and2 Result Example Remark
Operands of the same type:
Number Number Number 5 = 5 --> 1
4 = 5 --> 0
–
Text Text Number "Metrohm" = "AG" --> 0
"aG" = "AG" --> 0
When making a comparison between two
texts, the ASCII value of the character string
is compared (see Chapter 2.3.4.10, page
66). Attention: Uppercase and lowercase
letters have different values!
Time Time Number Time(1998;04;06) =
Time(1964;02;03) --> 0 (see Chapter 2.3.4.6.2, page 54)
Operands of a different type:
Number Text Number 1.2 = "1.2" --> 11.2 =
"Metrohm" --> 0 Before the relational operation, the Number
is converted to Text, afterwards the texts are
compared according to ASCII value (see
Chapter 2.3.4.10, page 66).