5 arithmetical functions, 1 exponential function, Exponential function (exp) – Metrohm tiamo 2.4 Manual User Manual

Page 86

Advertising
background image

2.4 Formula editor

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

70

■■■■■■■■

tiamo 2.4

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
sequence is compared (see Chapter
2.4.4.10, page 88)
.
Attention: Upper-
case and lowercase letters have different
values!

Time

Time

Number

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

(see Chapter 2.4.4.6.2, page 76)

Operands of a different type:

Number

Text

Number

1.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.4.4.10, page 88).

Text

Number

Number

"Metrohm" <> 1.2 --> 1

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 the type Date/Time to a
Number.

Time

Number

Number

Time(1999;10;07) <> 2.5 -->
1

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

Text

Time

Number

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

Before the operation, the operand is con-
verted from the type Date/Time to Text
(here thus: "1999-10-07 00:00:00 UTC
+2"
), afterwards the texts are compared
according to ASCII value (see Chapter
2.4.4.10, page 88)
.

Time

Text

Number

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

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

2.4.4.5

Arithmetical functions

2.4.4.5.1

Exponential function

Dialog window: Formula editor

Operators/Functions

Syntax
y = Exp(number)

Calculates e ^ number. Other notation for y = e

(number)

, whereby e is the

Euler number (e = 2.71828…).

Advertising