Metrohm tiamo 2.2 (ProcessLab) - Manual (Page 78)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
62 ￭￭￭￭￭￭￭￭ tiamo 2.2 (ProcessLab)
Oper-
and1 Oper-
and2 Result Example Remark
Number Number Number 5 <= 4 --> 0
4 <= 5 --> 1
-
Text Text Number "Metrohm" <= "AG" --> 0 When making a comparison between two
texts the ASCII value of the character
sequence is compared (see Chapter
2.4.4.10, page 81). Attention: Uppercase
and lowercase letters have different values!
Time Time Number Time(1998;04;06) <=
Time(1964;02;03) --> 0 (see Chapter 2.4.4.6.2, page 69)
Operands of a different type:
Number Text Number 2 <= "1.2" --> 01.2 <=
"Metrohm" --> 1 Before the relational operation, the Num-
ber is converted to Text, afterwards the
texts are compared according to ASCII
value (see Chapter 2.4.4.10, page 81).
Text Number Number "Metrohm" <= 1.2 --> 0 The same rules apply here as for the previous
operation.
Number Time Number 2.0 <= Time(1999;10;07) -->
1 Before the comparison, the operand is con-
verted from the type Date/Time to a Num-
ber.
Time Number Number Time(1999;10;07) <= 2.0 -->
0 The same rules apply here as for the previous
operation.
Text Time Number "Metrohm" <=
Time(1999;10;07) --> 0 Before the operation, the operand is conver-
ted from the type Date/Time to Text (here
thus: "1999.10.07"), afterwards the texts
are compared according to ASCII value (see
Chapter 2.4.4.10, page 81).
Time Text Number Time(1999;10;7) <=
"Metrohm" --> 1 The same rules apply here as for the previous
operation.
2.4.4.4.6 Not 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 type Text, Number or Date/Time. The result type is always a number
(1 = true, 0 = false).