Metrohm tiBase 1.1 - Manual (Page 50)

2.4 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
42 ￭￭￭￭￭￭￭￭
tiBase 1.1
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).
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
sequence is compared (see Chapter
2.4.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.4.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.4.4.10, page 66).
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) -->
0 Before the operation, the operand of the
type Date/Timeis converted to Number.
During execution of the operation, the exact
value is always used after this conversion,
even if maximum 5 places after the comma
can be displayed (see Chapter 2.4.4.7.5,
page 59).
Time Number Number Time(1999;10;7) = 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 00:00:00 UTC+2"),
afterwards the texts are compared according
to ASCII value (see Chapter 2.4.4.10, page
66).
Time Text Number Time(1999;10;07) =
"Metrohm" --> 0 The same rules apply here as for the previous
operation.