MENU
Numeric
The trigonometrical functions are SIN(x), COS(x), TAN(x) and COT(x), where x is specified in radians. The inverse functions are ASIN(x), ACOS(x), ATAN(x), ATAN(Y,X) and ATAN2(Y,X).PI() returns the value of PI.
RADIANS(x) converts x from degrees to radians.
DEGREES(x) converts x from radians to degrees.
POW(x,y) or POWER(x,y) returns the value of x raised to the power of y.
SQRT(x) returns the square root of a non-negative x.
EXP(x) returns the value of e raised to the power of x.
LOG(x) or LN(x) returns ln(x).
LOG(B,x) returns the logarithm of x to be base B.
LOG2(x) returns the base-2 logarithm of x.
LOG10(x) returns the base-10 logarithm of x.
MOD(N,M) is the same as N % M and N MOD M.
SIGN(x) returns the sign as -1, 0, or 1.
ABS(x) returns the absolute value of x.
CEIL(x) and CEILING(x) returns the smallest integer not less than x.
FLOOR(x) returns the largest integer not greater than x.
ROUND(x) rounds x to the nearest integer.
ROUND(x, D) rounds x to D decimal places, where D can be negative.
TRUNCATE(x,D) truncates x to D decimal places, where D can be negative.
CONV(N,B1,B2) converts N from base B1 to base B2.
CRC32(expr) computes a cyclic redundancy check value and returns a 32-bit unsigned value.
RAND() returns a random float in the range 0 to 1.0.
RAND(s) uses s as the seed to produce the random number.