beautypg.com

6 not equal to, Not equal to, Not equal to (<>) – Metrohm viva 1.0 Manual User Manual

Page 58

background image

2.3 Formula editor

■■■■■■■■■■■■■■■■■■■■■■

46

■■■■■■■■

viva 1.0

Oper-
and1

Oper-
and2

Result

Example

Remark

Number

Text

Number

2 <= "1.2" --> 01.2 <=
"Metrohm" --> 1

Before the relational operation, the Num-
ber
is converted to Text, afterwards the
texts are compared according to ASCII
value
(see Chapter 2.3.4.10, page 65).

Text

Number

Number

"Metrohm" <= 1.2 --> 0

The same rules apply here as for the previ-
ous operation.

Number

Time

Number

2.0 <= Time(1999;10;07) -->
1

Before the comparison, the operand is con-
verted from Date/Time to a Number.

Time

Number

Number

Time(1999;10;07) <= 2.0 -->
0

The same rules apply here as for the previ-
ous operation.

Text

Time

Number

"Metrohm" <=
Time(1999;10;07) --> 0

Before the operation, the operand is con-
verted from Date/Time to Text (in this
example: "1999.10.07"), afterwards the
texts are compared according to ASCII
value
(see Chapter 2.3.4.10, page 65).

Time

Text

Number

Time(1999;10;7) <=
"Metrohm" --> 1

The same rules apply here as for the previ-
ous operation.

2.3.4.4.6

Not equal to

Dialog window: Formula editor

Operators/Functions

Syntax
Operand1 <> Operand2

The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type. The result type is always a num-
ber (1 = true, 0 = false).

Examples

Oper-
and1

Oper-
and2

Result

Example

Remark

Operands of the same type:

Number

Number

Number

5 <> 4 --> 1

5 <> 5 --> 0

Text

Text

Number

"Metrohm" <> "AG" --> 1

When making a comparison between two
texts, the ASCII value of the character
string is compared (see Chapter 2.3.4.10,
page 65)
. Attention: Uppercase and
lowercase letters have different values!

Time

Time

Number

Time(1998;04;06) <>
Time(1964;02;03) --> 1

(see Chapter 2.3.4.6.2, page 53)

Operands of a different type: