beautypg.com

Larger than or equal to – Metrohm tiamo 1.1 Manual User Manual

Page 69

background image

Formula editor

41

Operand1 Operand2 Result

Example

Remarks

Operands of different types:
Number Text

Number

1.2 > "Metrohm" --> 0
1.23 > "1.2" --> 1

Before the comparative opera-
tion 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.

Text Time Number

"Metrohm" > Time(1999;10;07)
--> 1

Before the operation an oper-
and of type

Date/Time

is con-

verted 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)