Metrohm tiamo 1.0 Manual - Manual (Page 59)

Formula editor 35
Larger than
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
"Aarau" > "Zug" --> 0
In a comparison between two texts the
ASCII values (see ASCII table) of the char-
acter strings are compared. Note: upper
and lower case letters have different val-
ues!
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 > "Metrohm" --> 0
1.23 > "1.2" --> 1 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 pre-
vious operation.
Number Time Number 2.0 > Time(1999;10;07) -
-> 0 Before the comparison the Date/Time is
converted to a Number (see Type conver-
sion "TimeToNumber").
Time Number Number Time(1999;10;07) > 2.0 -
-> 1 The same rules apply here as for the pre-
vious 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 ta-
ble.
Time Text Number Time(1999;10;7) >
"Metrohm" --> 0 The same rules apply here as for the pre-
vious operation.