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

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
80 ￭￭￭￭￭￭￭￭ tiamo 2.2 (ProcessLab)
2.4.4.9 Miscellaneous functions
2.4.4.9.1 Case
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Case(Condition ; value_true ; value_false)
y = Case(Condition ; value_true ; value_false ; value_error)
Gives value_true if the condition is true. Otherwise value_false is given.
If an error occurs in the condition (result invalid), value_error is given.
Parameters
Condition
Number
Any variable (type Number) can be entered here, or a relational or logic
operation can be performed whose operators can be transferred either
directly or as a variable. These can be of the type Text, Number or Date/
Time.
Value_true
If condition <> 0, this parameter is saved as a result of the function. This
parameter can be transferred either directly or as a variable and can be of
the type Text, Number or Date/Time. Entire operations can also be trans-
ferred here.
Value_false
If condition = 0, this parameter is saved as a result of the function. This
parameter can be transferred either directly or as a variable and can be of
the type Text, Number or Date/Time. Entire operations can also be trans-
ferred here.
Value_error
If condition = invalid, this parameter is saved as a result of the function.
This parameter can be transferred either directly or as a variable and can be
of the type Text, Number or Date/Time. Entire operations can also be
transferred here.
Examples
Case('MV.ID1' = "";"ID1 empty";"ID1 not empty") = if no entry has
been made for ID1 in the run window, the text ID1 empty, otherwise ID1
not emptywill be saved in the result.
Case( 'DET pH 1.EP{1}.VOL';'DET pH 1.EP{1}.VOL';0;0) = If an end-
point has been found in the titration DET pH 1, for which the volume is not
0 (value_true), this will be saved as a result. If the EP1 is exactly 0, 0 will
be given. If no endpoint has been found, 0 will also be saved as a result for
this function.