Metrohm tiamo 1.0 Manual - Manual (Page 63)

Formula editor 39
Unequal
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
5 <> 5 --> 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!
Text Text Number "Metrohm" <> "AG" -->
1 dfg
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" --> 0
1.2 <> "Metrohm" --> 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) --> 1 Before the comparison the Date/Time is
converted to a Number (see Type conver-
sion "TimeToNumber").
Time Number Number Time(1999;10;07) <>
2.5 --> 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" --> 1 The same rules apply here as for the pre-
vious operation.