beautypg.com

Operators - compare, Equal – Metrohm tiamo 1.1 Manual User Manual

Page 67

background image

Formula editor

39

Operand1 Operand2 Result

Example

Remarks

Text Number

Number

"Metrohm" OR 1.2 --> 1

The same rules apply here as
for the previous operation.

Number Time

Number

2.0 OR Time(1999;10;7) --> 1

0 OR Time(1964;02;03) --> 1

Before the operation an oper-

and of the type

Date/Time

is

converted to the type

Number

;

all dates from 30 December
1899 are interpreted as

1

(true).

Time Number

Number

Time(1999;10;7) OR 2.5 --> 1

The same rules apply here as
for the previous operation.

Text Time Number

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

Before the operation an oper-
and of the type

Date/Time

is

converted to the type

Text

and

each non-empty character
string is interpreted as 1 (true).

Time Text Number

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

The same rules apply here as
for the previous operation.

Operators - Compare

Equal

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 = 5 --> 1
4 = 5 --> 0

-

Text Text Number

"Metrohm" = "AG" --> 0

"aG" = "AG" --> 0

In a comparison between two
text 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

1.2 = "1.2" --> 1
1.2 = "Metrohm" --> 0

Before the comparative opera-
tion the

Number

is converted to

Text

and then the texts are

compared according to the

ASCII table.