ABS([number] x) |
Same as input |
Returns the absolute value of x. |
ACOS([number] x) |
Double |
Calculates the arccosine of x in radians. |
ASIN([number] x) |
Double |
Calculates the arcsine of x in radians. |
ATAN([number] x) |
Double |
Calculates the arctangent of x in radians. |
CBRT([number] x) |
Float |
Calculates the cube root of x. |
CEILING([number] x) |
Same as input |
Returns the nearest whole number greater than x. |
COS([number] x) |
Double |
Calculates the cosine of x, where x is given in radians. |
COSH([number] x) |
Double |
Calculates the hyperbolic cosine of x. |
COT([number] x) |
Double |
Calculates the cotangent of x, where x is given in radians. |
DEGREES([number] x) |
Float |
Converts the value in radians given by x to degrees. |
E() |
Float |
Returns the mathematical constant e. |
EXP([number] x) |
Float |
Calculates the value of the constant e raised to the power of x. |
FLOOR([number] x) |
Same as input |
Returns the nearest whole number less than x. |
LOG([number] x) |
Float |
Calculates the natural logarithm of x. |
LOG([number] x, [number] y) |
Float |
Calculates the log base x of y. |
LOG10([number] x) |
Float |
Calculates the log base 10 of x. |
LSHIFT([number] x, [number] y) |
Same as input |
Returns the binary representation of x shifted to the left by y digits. |
MOD([number] x, [number] y) |
number |
Calculates the modulus of x and y (e.g. x % y). |
PI |
Float |
Returns the value of the mathematical constant pi. |
POW([number] x, [number] y) |
Float |
Calculates the x to the power of y. |
RADIANS([number] x) |
Float |
Converts the value in degrees given by x to radians. |
RAND() |
Float |
Generates a random number greater than or equal to 0 and less than 1. This random number will be the same for each entry. |
RANDOM() |
Float |
Generates a random number greater than or equal to 0 and less than 1. A new random number will made for each entry. |
ROUND([number] x) |
Same as input |
Returns the whole number nearest the value x. |
RSHIFT([number] x, [number] y) |
Same as input |
Returns the binary representation of x shifted to the right by y digits. |
SIGN([number] x) |
Integer |
Returns the sign of x (e.g. either -1 or +1). |
SIN([number] x) |
Double |
Calculates the sine of x, where x is given in radians. |
SINH([number] x) |
Double |
Calculates the hyperbolic sine of x. |
SQRT([number] x) |
Same as input |
Calculates the square root of x. |
TAN([number] x) |
Double |
Calculates the tangent of x, where x is given in radians. |
TANH([number] x) |
Double |
Calculates the hyperbolic tangent of x. |
TRUNC([number] x, [optional number] y) |
Same as input |
Keeps the first y digits to right of x's decimal point. If the second argument is omitted then y = 1. |