Metrohm tiamo 2.2 (ProcessLab) - Manual (Page 66)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
50 ￭￭￭￭￭￭￭￭ tiamo 2.2 (ProcessLab)
Operators Functions
Logic:
￭ AND
￭ OR
Date/Time:
￭ Time()
￭ Time(Date)
￭ Time(Date+Time)
Comparison:
￭ Equal to (=)
￭ Greater than (>)
￭ Greater than or equal to (>=)
￭ Less than (<)
￭ Less than or equal to (<=)
￭ Not equal to (<>)
Type conversion:
￭ NumberToText
￭ NumberToTime
￭ TextToNumber
￭ TextToTime
￭ TimeToNumber
￭ TimeToText
Text:
￭ TextPosition
￭ SubText
￭ Trim
Miscellaneous:
￭ Error
￭ Case
Priority rules of the operators
The operators are evaluated in the order in which they are listed in the table
below. In order to attain the required order, it may be necessary to place
operators in parentheses.
Operators
Arithmetic ^
*, /
+, -
Comparison <, <=, >, >=
Logic AND, OR
2.4.4.2 Arithmetical operators
2.4.4.2.1 Addition
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.