Operators - compare, Equal – Metrohm tiamo 1.1 Manual User Manual
Page 67

Formula editor
39
Operand1 Operand2 Result
Example
Remarks
Text Number
Number
"Metrohm" OR 1.2 --> 1
The same rules apply here as
for the previous operation.
Number Time
Number
2.0 OR Time(1999;10;7) --> 1
0 OR Time(1964;02;03) --> 1
Before the operation an oper-
and 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 oper-
and 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 opera-
tion the
Number
is converted to
Text
and then the texts are
compared according to the
ASCII table.