| MOD |
|
|
returns the remainder of the integer division of two numbers (rounded to integers before division is performed);
Details:
x MOD y equals to x - x \ y * y
(to ROUND(x) - x \ y * ROUND(y) if x or y are not integer)
|
|
| \ |
|
|
returns the integer division of two numbers (rounded to integers before division is performed);
Details:
x \ y equals to FIX(x / y)
(to FIX(ROUND(x) / ROUND(y)) if x or y are not integer)
|
|
| - - - - - - - - |
| ABS |
|
|
returns the absolute value of a numeric expression.
|
|
| ACOS |
|
|
returns the arccosine of a numeric expression.
|
|
| ASIN |
|
|
returns the arcsine of a numeric expression.
|
|
| ATN / ATAN |
|
|
returns the arctangent of a numeric expression.
|
|
| CEIL |
|
|
returns the smallest integer greater than or equal to a numeric-expression
(3.2 –> 4, 3.6 –> 4, -3.2 –> -3).
|
|
| COS |
|
|
returns the cosine of an angle given in radians.
|
|
| EXP |
|
|
returns the exponential function (e raised to the power
of n).
|
|
| FIX |
|
|
removes the fractional part of a number.
(3.2 –> 3, 3.6 –> 3, -3.2 –> -3).
|
|
| INT / FLOOR |
|
|
returns the largest integer less than or equal to a numeric-expression
(3.2 –> 3, 3.6 –> 3, -3.2 –> -4).
|
|
| LOG |
|
|
returns the natural logarithm of a numeric expression.
|
|
| ROUND / CINT |
|
|
converts a number to an integer by rounding the
fractional part of the expression
(3.2 –> 3, 3.6 –> 4, -3.2 –> -4).
|
|
| SGN |
|
|
indicates the sign of a numeric expression.
Details:
If numeric-expression is positive, SGN returns 1.
If numeric-expression is zero, SGN returns 0.
If numeric-expression is negative, SGN returns -1.
|
|
| SIN |
|
|
returns the sine of an angle given in radians.
|
|
| SQR |
|
|
returns the square root of a number.
|
|
| TAN |
|
|
returns the tangent of an angle given in radians.
|
|
| - - - - - - - - |
| RND |
|
|
returns a random decimal number uniformly distributed in [0,1).
|
|