The mathematical functions described in this section perform mathematical operations.
Function | Example | Description |
---|---|---|
Abs |
|
Calculates the absolute value of a numeric expression. |
Acos |
|
Calculates the arc cosine of a numeric expression. |
Asin |
|
Calculates the arc sine of a numeric expression. |
Atan |
|
Calculates the arc tangent of a numeric expression. |
Atan2 |
|
Calculates the arc tangent of |
Ceiling |
|
Rounds a noninteger numeric expression to the next highest integer. If the numeric expression evaluates to an integer, the |
Cos |
|
Calculates the cosine of a numeric expression. |
Cot |
|
Calculates the cotangent of a numeric expression. |
Degrees |
|
Converts an expression from radians to degrees. |
Exp |
|
Sends the value to the power specified. Calculates |
ExtractBit |
|
Retrieves a bit at a particular position in an integer. It returns an integer of either 0 or 1 corresponding to the position of the bit. |
Floor |
|
Rounds a noninteger numeric expression to the next lowest integer. If the numeric expression evaluates to an integer, the |
Log |
|
Calculates the natural logarithm of an expression. |
Log10 |
|
Calculates the base 10 logarithm of an expression. |
Mod |
|
Divides the first numeric expression by the second numeric expression and returns the remainder portion of the quotient. |
Pi |
|
Returns the constant value of pi. |
Power |
|
Takes the first numeric expression and raises it to the power specified in the second numeric expression. |
Radians |
|
Converts an expression from degrees to radians. |
Rand |
|
Returns a pseudo-random number between 0 and 1. |
RandFromSeed |
|
Returns a pseudo-random number based on a seed value. For a given seed value, the same set of random numbers are generated. |
Round |
|
Rounds a numeric expression to |
Sign |
|
This function returns the following:
|
Sin |
|
Calculates the sine of a numeric expression. |
Sqrt |
|
Calculates the square root of the numeric expression argument. The numeric expression must evaluate to a nonnegative number. |
Tan |
|
Calculates the tangent of a numeric expression. |
Truncate |
|
Truncates a decimal number to return a specified number of places from the decimal point. |