Metrohm tiBase 1.1 - Manual (Page 42)

2.4 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
34 ￭￭￭￭￭￭￭￭
tiBase 1.1
Overview of the operators and functions
Operators Functions
Arithmetic:
￭ Addition (+)
￭ Subtraction (-)
￭ Multiplication (*)
￭ Division (/)
￭ Potentiation (^)
Arithmetic:
￭ Exponential function (Exp)
￭ Natural logarithm (Ln)
￭ Common logarithm (Log)
￭ Square root (Sqrt)
￭ Absolute value (Abs)
￭ Fraction (Frac)
￭ Integer (Int)
￭ Round integer (Round)
￭ Sign (Sign)
￭ Quantiles of the Student's t-distribution (Tinv)
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