Filter
Top Products
Using mathematical functions 13-19
Test functions
The test functions are logical operators that always return
either a 1 (true) or a 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
)
NOT Returns 1 if value is zero, otherwise returns 0.
NOT value
OR Returns 1 if either value1 or value2 is non-zero, otherwise
returns 0.
value1 OR value2
hp40g+.book Page 19 Friday, December 9, 2005 1:03 AM