| Formula Field Syntax
| Description
| Equivalent LISP Syntax
|
| \ |
quoting character: x\-y --> x-y |
|
| ! |
lisp escape: !(foo bar) --> (foo bar) |
|
| ; |
comment |
|
| x = y |
assignment |
(setf x y) |
| x += y |
increment |
(incf x y) |
| x -= y |
decrement |
(decf x y) |
| x *= y |
multiply and store |
(setf x (* x y)) |
| x /= y |
divide and store |
(setf x (/ x y)) |
| x|y |
bitwise logical inclusive or |
(logior x y) |
| x^y |
bitwise logical exclusive or |
(logxor x y) |
| x&y |
bitwise logical and |
(logand x y) |
x<
| left shift |
(ash x y) |
|
| x>>y |
right shift |
(ash x (- y)) |
| ~x |
ones complement (unary) |
(lognot x) |
| x and y |
conjunction |
(and x y) |
| x && y |
conjunction |
(and x y) |
| x or y |
disjunction |
(or x y) |
| x || y |
disjunction |
(or x y) |
| not x |
negation |
(not x) |
| x^^y |
exponentiation |
(expt x y) |
| x,y |
sequence |
(progn x y) |
| (x,y) |
sequence |
(progn x y) |
| (x+y)/z |
parenthesis |
(/ (+ x y) z) |
| f(x,y) |
functions |
(f x y) |
| a[i,j] |
array reference |
(aref a i j) |
| x+y x*y |
arithmetic |
(+ x y) (* x y) |
| x-y x/y |
arithmetic |
(- x y) (/ x y) |
| -y |
value negation |
(- y) |
| x % y |
remainder |
(mod x y) |
| xy |
inequalities |
(< x y) (> x y) |
| x <= y x >= y |
inequalities |
(<= x y) (>= x y) |
| x == y |
equality |
(= x y) |
| x != y |
equality |
(not (= x y)) |
| if p then q |
conditional |
(when p q) |
| if p then q else r |
conditional |
(if p q r) |