User Manual

Formula editor 45
Operand1 Operand2 Result Example Remarks
the previous operation.
Text Time Number
"Metrohm" <> Time(1999;10;07)
--> 1
Before the operation an operand
of type
Date/Time is converted to
Text (i.e.: "1999-10-07 00:00:00
UTC+2"
) and then the texts are
compared according to the ASCII
table.
Time Text Number
Time(1999;10;7) <> "Metrohm" --
> 1
The same rules apply here as for
the previous operation.
Functions - Arithmetic
Exponential function
Syntax
y = exp(number)
Calculates e ^
Number. Another way of writing y = e
(number)
, where e is the
exponential (e = 2.71828...).
Parameter
Number Exponent
The parameter can either be entered directly as a number or as a Variable
of the type
Number. If the parameter does not correspond to the selected
type then it will be automatically converted to it (see Type conversion
"TextToNumber"). If this is not possible then "
invalid" will be returned as the
result of this operation.
Examples
Exp(1.5) = 4.48169
Exp('CV.MeanTemp') = potential of the exponent (Common variable) based
on e
Natural logarithm
Syntax
y = ln(number)
Returns the logarithm of the entered number based on e. Another way of
writing y = log
e
(Number), where e is the exponential (e = 2.71828...).
Parameter
Number >0
The parameter can either be entered directly as a number or as a Variable
of the type
Number. If the parameter does not correspond to the selected
type then it will be automatically converted to it (see Type conversion
"TextToNumber"). If this is not possible then "
invalid" will be returned as the
result of this operation.