Math

@sqr[@n]
Square root of @n

@pi
3.141592…

@sin[@n]
Sine of @n.

@cos[@n]
Cosine of @n.

@tan[@n]
Tangent of @n.

@arcsin[@n]
Arcsine of @n.

@arccos[@n]
Arccosine of @n.

@arctan[@n]
Arctangent of @n.

@arccosh[@n]
Inverse hyperbolic cosine of @n.

@arcsinh[@n]
Inverse hyperbolic sine of @n.

@arctanh[@n]
Inverse hyperbolic tangent of @n.

@sinh[@n]
Hyperbolic sine of @n.

@cosh[@n]
Hyperbolic cosine of @n.

@tanh[@n]
Hyperbolic tangent of @n.

@cotan[@n]
Cotangent of @n.

@arctan2[@y,@x]
Arctangent angle and quadrant

@sincos[@theta,$sinvar,$cosvar]
Sine and cosine (returned in variables with specified names, e.g. @sincos[@a,s,c] will return sine and cosine in @s and @c. The function itself always returns 0.

@hypot[@x,@y]
Length of hypotenuse.

@rad[@degrees]
Radians from degrees

@deg[@radians]
Degrees from radians

@shl[@n, @b]
Shift @n left @b bits

@shr[@n, @b]
Shift @n right @b bits

@xor[@n1, @n2]
Bitwise Exclusive OR.

@max[@n1,@n2]
Returns the greater of @n1 and @n2

@min[@n1,@n2]
Returns the lesser of @n1 and @n2

@sgn[@n]
Returns -1 if n is <0, else returns 1

@abs[@n]
Returns the absolute value of @n. (This is a actually macro in userdefs.udf).

@val[$s]
Returns the numerical value of text string $s (e.g. string "12" = number 12).

@uns[@n]
Returns unsigned value of @n.

$hex[@n,@L]
Converts a decimal integer into a hexidecimal string. The optional @L argument, new in version 5.2.0, specifies the minimum length of the hex string, which will be padded with 0's on the left if necessary.

@dec[$x]
Converts a hexidecimal string into an integer value.