Metrohm tiBase 1.1 - Manual (Page 44)

2.4 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
36 ￭￭￭￭￭￭￭￭
tiBase 1.1
2.4.4.2.2 Subtraction
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
both operands of the same type:
Number Number Number 1.2 - 3 = -1.8 -
Text Text Text "Metrohm" - "AG" = invalid This operation is not allowed.
Time Time Number Time(1998;01;06) -
Time(1964;12;03) = 12'087.00 (for
UTC+1) Result: Number of days calculated
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 1.2 - "Metrohm" = invalid This operation is not allowed.
Text Number Text "Metrohm" - 1.2 = not valid This operation is not allowed.
Number Time Number 2.0 - Time(1999;10;7) =
-36'437.917 (for UTC+2) Result: Number of days calculated
from December 1899, dependent
on the system time
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.