User Manual

Formula editor 43
Operand1 Operand2 Result Example Remarks
ASCII table.
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
Date/Time is converted to a
Number (see Type conversion
"TimeToNumber").
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 an oper-
and of type
Date/Time is con-
verted to
Text (i.e.: "1999-10-07
00:00:00 UTC+2"
) and then the
texts are compared according
to the ASCII table.
Time Text Number
Time(1999;10;7) < "Metrohm" -
-> 1
The same rules apply here as
for the previous operation.
Smaller than or equal to
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 <= 4 --> 0
4 <= 5 --> 1
-
Text Text Number
"Metrohm" <= "AG" --> 0
In a comparison between two
texts 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
2 <= "1.2" --> 0
1.2 <= "Metrohm" --> 1
Before the comparative opera-
tion the
Number is converted to
Text and then the texts are
compared according to the
ASCII table.
Text Number Number
"Metrohm" <= 1.2 --> 0
The same rules apply here as
for the previous operation.