English
GermanLogical
assignif
Assigns a result if a conditional expression is true
-
cond: is a conditional expression evaluated for each item
-
if: is the result returned if the condition is true
empty
determines if a cell in a collection is empty
exists
determines if a cell in a collection exists or is empty
filter
Returns a result depending on a conditional expression.
-
cond: is a conditional expression evaluated for each item
-
if: is the result returned if the condition is true
-
else: is the value returned if the condition is false
ifexists
Returns the argument. All empty cells of the argument are replaced by a given value.
inrange
Returns the first argument if it is inside a given range otherwise produces an error.
-
value: is the argument to be tested
-
min: is the lower bound of the valid range
-
max: is the upper bound of the valid range
inside
returns true for all values that lie inside a given range.
-
val: is the value to be tested.
-
l: is the lower limit of the range.
-
r: is the upper limit of the range.
-
excl: defines if the lower or upper limit values belong to the interval or not. Possible values are: 0= [l;r] 1= ]l;r] 2= [l;r[ 3= ]l;r[
isnothing
returns true, if argument x does not exist (NIL pointer).
maskerror
Filters values with error states from a given argument. Optionally, values with error states (e.g. #inf) can be replaced by an alternative value.
oneof
returns true for all values that are contained in a given set of values.
-
val: is the value to be tested.
-
set: is a collection of valid values. This can be a reference to a tensor on a worksheet or an array, e.g. array(1,2,5,7)
outside
returns true for all values that lie outside a given range.