I didn't find the help file very useful for experssions, I've rewritten it for how they really seem work in v6.20
Code: Select all
Definitions:
true not 0
false 0
Functions
PI 3.1415926535897932385
COS(x) Cosine of x degrees
SIN(x) Sine of x degrees
TAN(x) Tangent of x degrees
ACOS(x) Arc cosine of x degrees
ASIN(x) Arc sine of x degrees
ATAN(x) Arc tangent of x degrees
ATAN2(x,y) ATAN(x/y)
EXP(x) e^x
LN(x) log_ex
LOG(x) log_10x
SQRT(x) √x
ABS(x) |x|
MAX(x,y) Returns largest value of x and y
MIN(x,y) Returns smallest value of x and y
CEIL(x) Rounds x off to closest higher whole number
CEIL2(x,y) Rounds x off to closest higher number divisible by y
ROUND(x) Rounds x off to closest whole number
ROUND2(x,y) Rounds x off to closest number divisible by y
FLOOR(x) Rounds x off to closest lower whole number
FLOOR2(x,y) Rounds x off to closest lower number divisible by y
Logic (Logical functions and comparisons return 1 when true, and 0 when false)
Functions
AND(x,y) x and y are true
OR(x,y) x or y is true
NOT(x) x is not true
WHEN(x,y,z) Returns y if x is true, z if x is false
Comparison
x==y x is equal to y
x>=y x is larger than or equal to y
x>y x is larger than y
x<=y x is smaller than or equal to y
x<y x is smaller than y
x!=y x is not equal to y
Code: Select all
and(x,y,z)
but this does:
Code: Select all
and(x,(and(y,z))