Function | Description |
ABS(x) | Returns the absolute value of x. |
ACOS(x) | Returns the arccosine of x. |
ASIN(x) | Returns the arcsine of x. |
ATAN(x) | Returns the arctangent of x. |
ATAN2(x, y) | Returns the arctangent of x and y. |
BITAND(x, y) | Returns the result of performing a bitwise AND on x and y. |
COS(x) | Returns the cosine of x, where x is an angle in radians. |
COSH(x) | Returns the hyperbolic cosine of x. |
CEIL(x) | Returns the smallest integer greater than or equal to x. |
EXP(x) | Returns the result of the number e raised to the power x, where e is approximately 2.71828183. |
FLOOR(x) | Returns the largest integer less than or equal to x. |
LOG(x, y) | Returns the logarithm, base x, of y. |
LN(x) | Returns the natural logarithm of x. |
LN(2.71828183) = 1 | MOD(x, y) |
Returns the remainder when x is divided by y. | POWER(x, y) |
Returns the result of x raised to the power y. | ROUND(x [, y]) |
Returns the result of rounding x an optional y decimal places. If y is omitted, x is rounded to zero decimal places. If y is negative, x is rounded to the left of the decimal point. | SIGN(x) |
Returns -1 if x is negative, 1 if x is positive, or 0 if x is zero. | SIN(x) |
Returns the sine of x. | SINH(x) |
Returns the hyperbolic sine of x. | SQRT(x) |
Returns the square root of x. | TAN(x) |
Returns the tangent of x. | TAN(0) = 0 |
TANH(x) | Returns the hyperbolic tangent of x. |
TRUNC(x [, y]) | Returns the result of truncating x an optional y decimal places. If y is omitted, x is truncated to zero decimal places. If y is negative, x is truncated to the left of the decimal point. |