Math

Mathematical functions perform calculations on numeric inputs and return numeric results, including trigonometry, logarithms, powers and rounding.

Function	Description
ABS	A mathematical function that returns the absolute (positive) value of the specified numeric expression. (ABS changes negative values to positive values. ABS has no effect on zero or positive values.)
ACOS	A mathematical function that returns the angle, in radians, whose cosine is the specified float expression; also called arc cosine.
ASIN	Returns the angle, in radians, whose sine is the specified float expression. This is also called arcsine.
ATAN	Returns the angle in radians whose tangent is a specified float expression. This is also called arctangent.
ATN2	Returns the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x), where x and y are the values of the two specified float expressions.
CEILING	Returns the smallest integer greater than, or equal to, the specified numeric expression.
COS	Is a mathematical function that returns the trigonometric cosine of the specified angle, in radians, in the specified expression.
COT	A mathematical function that returns the trigonometric cotangent of the specified angle, in radians, in the specified float expression.
DEGREES	Returns the corresponding angle in degrees for an angle specified in radians.
EXP	Returns the exponential value of the specified float expression.
FLOOR	Returns the largest integer less than or equal to the specified numeric expression.
LOG	Returns the natural logarithm of the specified float expression.
LOG10	Returns the base-10 logarithm of the specified float expression.
PI	Returns the constant value of PI.
POWER	Returns the value of the specified expression to the specified power.
RADIANS	Returns radians when a numeric expression, in degrees, is entered.
RAND	Returns a pseudo-random float value from 0 through 1, exclusive.
ROUND	Returns a numeric value, rounded to the specified length or precision.
SIGN	Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
SIN	Returns the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression.
SQRT	Returns the square root of the specified float value.
SQUARE	Returns the square of the specified float value.
TAN	Returns the tangent of the input expression.