Metrohm tiamo 1.2 Manual - Handbuch (Seite 63)

Formula editor 37
Operand1 Operand2 Result Example Remarks
Number Time Number 2.0 OR Time(1999;10;7) --> 1
0 OR Time(1964;02;03) --> 1
Before the operation an operand of
the type Date/Time is converted to
the type Number ; all dates from 30
December 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
previous operation.
Text Time Number "Metrohm" OR
Time(1999;10;7) --> 1 Before the operation an operand of
the type
Date/Time is converted to
the type Text and each 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
previous operation.
Operators - Compare
Equal
Syntax
Operand1 = Operand2
The operands can either be entered 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).
Examples
Operand1 Operand2 Result Example Remarks
Operands of the same type:
Number Number Number 5 = 5 --> 1
4 = 5 --> 0 -
Text Text Number "Metrohm" = "AG" --> 0
"aG" = "AG" --> 0
In a comparison between two text
the ASCII values (see ASCII table) of
the character strings are compared.
Note: upper and lower case letters
have different values!
Time Time Number Time(1998;04;06) =
Time(1964;02;03) --> 0 Time() : see function Time(Date)
Operands of different types:
Number Text Number 1.2 = "1.2" --> 1
1.2 = "Metrohm" --> 0 Before the comparative operation
the
Number is converted to Text and
then the texts are compared accord-
ing to the ASCII table.
Text Number Number "Metrohm" = 1.2 --> 0 The same rules apply here as for the
previous operation.