3 multiplication, Multiplication – Metrohm tiamo 2.3 Manual User Manual
Page 74
2.4 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
58
■■■■■■■■
tiamo 2.3
Operand1
Operand2
Result
Example
Remark
Time
Number
Number
Time(1999;10;7) - 2.5 =
36'437.917 (for UTC+2)
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.
2.4.4.2.3
Multiplication
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 = 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" = "MetrohmMe-
trohm"
-
Text
Number
Text
"Metrohm" * 2 = "MetrohmMe-
trohm"
-
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) =
invalid
This operation is not allowed.
Time
Text
Text
Time(1999;10;7) * "Metrohm" =
invalid
This operation is not allowed.