You may use any number of user-defined variables, provided that the variable names are not equal to any of the reserved function names (see below). A user-defined variable always starts with a letter and may consist of any number of digits and letters and the underscore character ('_'). See Evaluate for further details on variables.
The expression may use the following pre-defined constants, operators, and functions:
--- Constants --- |
true |
logical true (or -1, if used as number) |
false |
logical false (or 0, if used as number) |
pi |
the number Pi (3.14159...) |
--- References --- |
° |
currently referenced cell; this symbol indicates the value of the currently referenced cell when iterating through a range of cells. It is treated as a (predefined) variable. Thus the user has to supply the actual value in the OnVarRequest event. |
--- Arithmetic Operators --- |
+ |
sum: x+y |
- |
difference: x-y |
* |
product: x*y |
/ |
division: x/y |
# |
modulo: round(x) mod round(y) |
^ |
power: exponentiation x^y , x>0, y..any real values |
--- Logic Operators --- |
> |
greater than |
>= |
greater than or equal |
= |
equal |
>< |
not equal |
< |
less than |
<= |
less than or equal |
and |
boolean or bitwise and |
not |
boolean or bitwise not |
or |
boolean or bitwise or |
xor |
boolean or bitwise exclusive or |
--- Functions --- |
abs |
absolute value: abs(x), x..any real value |
arccos |
inverse cosine: arccos(x), x..angle in radians |
arcsin |
inverse sine: arcsin(x), x..angle in radians |
arctan |
inverse tangens: arctan(x), x..angle in radians |
cos |
cosine: cos(x), x..angle in radians |
exp |
exponential function: exp(x) |
frac |
fraction: frac(x) = x - int(x) |
gauss |
gauss creates normally distributed random numbers with zero mean and unit standard deviation |
int |
round towards zero: int(x) |
lg |
decadic logarithm: lg(x) |
ln |
natural logarithm: ln(x) |
max |
returns the maximum of a list of variables: max(list), with list containing a list of variables reparated by commas;(1) a range of numbered variables may be abbreviated by the ':' sign (i.e. "xx8:11" expands to "xx8, xx9, xx10, xx11"). The list may contain constant values, as well. |
mean |
returns the mean of a list of variables: mean(list), with list containing a list of variables reparated by commas;(1) a range of numbered variables may be abbreviated by the ':' sign (i.e. "xx8:11" expands to "xx8, xx9, xx10, xx11"). The list may contain constant values, as well. |
min |
returns the minimum of a list of variables: min(list), with list containing a list of variables reparated by commas;(1) a range of numbered variables may be abbreviated by the ':' sign (i.e. "xx8:11" expands to "xx8, xx9, xx10, xx11"). The list may contain constant values, as well. |
nddens |
density of the standard normal distribution: nddens(x) |
ndint |
integral of the standard normal distribution from -infinity to x: ndint(x) |
ndquant |
quantile of the standard normal distribution for a probability x: ndquant(x) |
rand |
uniformly distributed random numbers: random(x), x..amplitude of noise (mean = 0.0) |
round |
round to the nearest integer: round(x) |
sign |
sign of x: sign(x) |
sin |
sinus: sin(x) |
sqr |
square: sqr(x) |
sqrt |
square root: sqrt(x) |
sum |
returns the sum of a list of variables: sum(list), with list containing a list of variables reparated by commas;(1) a range of numbered variables may be abbreviated by the ':' sign (i.e. "zz1:3" expands to "zz1, zz2, zz3"). The list may contain constant values, as well. |
tan |
tangens: tan(x) |
var |
returns the variance of a list of variables: var(list), with list containing a list of variables reparated by commas;(1) a range of numbered variables may be abbreviated by the ':' sign (i.e. "xx8:10,aux4,y1:3" expands to "xx8, xx9, xx10, aux4, y1, y2, y3"). The list may contain constant values, as well. |