4 division, Division, Division (/) – Metrohm tiamo 2.1 Manual User Manual

Page 62

Advertising
background image

2.4 Formula editor

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

48

■■■■■■■■

tiamo 2.1

Examples

Operand1

Operand2

Result

Example

Remark

Operands of the same type:

Number

Number

Number

1.2 * 3 = 3.6

-

Text

Text

Text

"Metrohm" * "AG" = invalid

This operation is not allowed.

Time

Time

Number

Time(1998;05;06) * Time(1902;02;03)
= 27'478'004.545
(for UTC+1 or +2 for
summer time)

Result: Number of days calcula-
ted from December 1899,
dependent on the system time

Operand of different type: The operand which does not correspond to the result type is converted to the relevant
result type before the operation.

Number

Text

Text

2 * "Metrohm" = "MetrohmMetrohm"

-

Text

Number

Text

"Metrohm" * 2 = "MetrohmMetrohm"

-

Number

Time

Number

2.0 * Time(1999;10;7) = 72'879.833
(for UTC+2)

Result: Number of days calcula-
ted from December 1899,
dependent on the system time

Time

Number

Number

Time(1999;10;7) * 2.0 = 72'879.833
(for UTC+2)

Result: Number of days calcula-
ted from December 1899,
dependent on the system time

Text

Time

Text

"Metrohm" * Time(1999;10;7) = inva-
lid

This operation is not allowed.

Time

Text

Text

Time(1999;10;7) * "Metrohm" = inva-
lid

This operation is not allowed.

2.4.4.2.4

Division

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 type Text, Number or Date/Time.

Examples

Operand1

Operand2

Result

Example

Remark

Operands of the same type:

Number

Number

Number

1.2 / 3 = 0.4

Operand2 must not be zero!

Text

Text

Text

"Metrohm" / "AG" = invalid

This operation is not allowed.

Time

Time

Number

Time(1998;04;06) /
Time(1964;02;03) = 1.533
(for UTC
+1 or +2 for summer time)

Result: Number of days calculated
from December 1899, dependent
on the system time

Advertising