Using mathematical functions 177
XPON Exponent of value.
XPON(value)
Example:
XPON(123.4) returns 2
Test functions
The test functions are logical operators that always return
either 1 (true) or 0 (false).
< Less than. Returns 1 if true, 0 if false.
value1<value2
≤ Less than or equal to. Returns 1 if true, 0 if false.
value1≤value2
= = Equals (logical test). Returns 1 if true, 0 if false.
value1==value2
≠ Not equal to. Returns 1 if true, 0 if false.
value1≠value2
> Greater than. Returns 1 if true, 0 if false.
value1>value2
≥ Greater than or equal to. Returns 1 if true, 0 if false.
value1≥value2
AND Compares value1 and value2. Returns 1 if they are both
non-zero, otherwise returns 0.
value1 AND value2
IFTE If expression is true, do the trueclause; if not, do the
falseclause.
IFTE(expression, trueclause, falseclause)
Example:
IFTE(X>0,X
2
,X
3
)with x=-2 returns -8
NOT Returns 1 if value is zero, otherwise returns 0.
NOT value