Metrohm tiamo 1.2 Manual - Handbuch (Seite 65)

Formula editor 39
Operand1 Operand2 Result Example Remarks
Number Time Number 2.0 > Time(1999;10;07) --> 0 Before the comparison the
Date/Time
is converted to a Number (see Type
conversion "TimeToNumber").
Time Number Number Time(1999;10;07) > 2.0 --> 1 The same rules apply here as for the
previous operation.
Text Time Number "Metrohm" >
Time(1999;10;07) --> 1 Before the operation an operand of
type
Date/Time is converted 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" --> 0 The same rules apply here as for the
previous operation.
Larger 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 --> 1
4 >= 5 --> 0 -
Text Text Number "Metrohm" >= "AG" --> 1 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) --> 1 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 according to
the ASCII table.
Text Number Number "Metrohm" >= 1.2 --> 1 The same rules apply here as for the
previous operation.
Number Time Number 2.0 >= Time(1999;10;07) -->
0 Before the comparison the Date/Time
is converted to a Number (see Type
conversion "TimeToNumber").
Time Number Number Time(1999;10;07) >= 2.0 -->
1 The same rules apply here as for the
previous operation.