9 miscellaneous functions, 1 case – Metrohm tiamo 2.3 Patch 1 User Manual
Page 105
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
tiamo 2.3 Patch 1
■■■■■■■■
89
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
transferred 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
transferred 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.