4 division, Division – Metrohm viva 1.0 (process analysis) User Manual

Page 50

Advertising
background image

2.3 Formula editor

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

38

■■■■■■■■

viva 1.0 (for Process analysis)

Operand1

Operand2

Result

Example

Remark

Time

Number

Number

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

Result: Number of days calcu-
lated from December 1899,
dependent on the system time

Text

Time

Text

"Metrohm" * Time(1999;10;7) =
invalid

This operation is not allowed.

Time

Text

Text

Time(1999;10;7) * "Metrohm" =
invalid

This operation is not allowed.

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

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 in the summer time)

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

Operands of a different type: The operand which does not correspond to the result type is converted to the rele-
vant result type before the operation.

Number

Text

Text

1.2 / "Metrohm" = invalid

This operation is not allowed.

Text

Number

Text

"Metrohm" / 1.2 = invalid

This operation is not allowed.

Number

Time

Number

10,000 / Time(1999;10;7) = 0.274
(for UTC+2)

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

Time

Number

Number

Time(1999;02;17) / 10,000 = 3.621
(for UTC+1)

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

Text

Time

Text

"Metrohm" / Time(1999;10;7) =
invalid

This operation is not allowed.

Time

Text

Text

Time(1999;10;7) / "Metrohm" =
invalid

This operation is not allowed.

Advertising