Name |
Arguments |
Return |
Description |
Abs |
NUMBER N |
NUMBER |
Returns the absolute value of number N |
Category: |
Number Functions |
Name: |
Abs |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the absolute value of number N |
Examples: |
Abs(-4.2) will return 4.2 Abs(5) will return 5 |
|
ATan |
NUMBER N |
NUMBER |
Returns the arc tangent of number N in radians |
Category: |
Number Functions |
Name: |
ATan |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the arc tangent of number N in radians. ATan() is the complementary function of Tan(), which means that a == Tan(ATan(a)) for every value of a that is within ATan()’s range. |
Examples: |
ATan(50) will return 1.5507989928217 |
|
Ceil |
NUMBER N |
NUMBER |
Returns the next highest integer value by rounding up value if necessary. |
Category: |
Number Functions |
Name: |
Ceil |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the next highest integer value by rounding up value if necessary. |
Examples: |
Ceil(5.2) will return 6 Ceil(2.4) will return 3 |
|
Cos |
NUMBER N |
NUMBER |
Returns the cosine of the number N |
Category: |
Number Functions |
Name: |
Cos |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the cosine of the number N. The number N is in radians. |
Examples: |
Cos(50) will return 0.96496602849211 |
|
Cosh |
NUMBER N |
NUMBER |
Returns the hyperbolic cosine of number N |
Category: |
Number Functions |
Name: |
Cosh |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the hyperbolic cosine of number N, defined as (Exp(N) + Exp(-N))/2. |
Examples: |
Cosh(2) will return 3.7621956910836 |
|
CoTan |
NUMBER N |
NUMBER |
Returns the cotangent of number N |
Category: |
Number Functions |
Name: |
CoTan |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the cotangent of number N, defined as 1/Tan(N). The number N is in radians. |
Examples: |
CoTan(2) will return -0.45765755436029 |
|
Exp |
NUMBER N |
NUMBER |
Returns e raised to the power of number N |
Category: |
Number Functions |
Name: |
Exp |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns e raised to the power of number N. ‘e’ is the base of the natural system of logarithms, or approximately 2.718282. |
Examples: |
Exp(2) will return 7.3890560989307 |
|
Floor |
NUMBER N |
NUMBER |
Returns the next lowest integer value (as float) by rounding down value if necessary. |
Category: |
Number Functions |
Name: |
Floor |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the next lowest integer value (as float) by rounding down value if necessary. |
Examples: |
Floor(5.2) will return 4 Floor(2.4) will return 2 |
|
Ln |
NUMBER N |
NUMBER |
Returns natural log of the number N |
Category: |
Number Functions |
Name: |
Ln |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns natural log of the number N |
|
Log10 |
NUMBER N |
NUMBER |
Returns the base-10 logarithm of number N |
Category: |
Number Functions |
Name: |
Log10 |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the base-10 logarithm of number N |
|
Logn |
NUMBER base, NUMBER N |
NUMBER |
Returns the log base of number N |
Category: |
Number Functions |
Name: |
Logn |
Arguments: |
NUMBER base, NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the log base of number N |
Examples: |
Logn(10, 100) return 2 |
|
Pow |
NUMBER base, NUMBER exp |
NUMBER |
The Power function raises Base to any power. |
Category: |
Number Functions |
Name: |
Pow |
Arguments: |
NUMBER base, NUMBER exp |
Return Type: |
NUMBER |
Description: |
The Power function raises Base to any power. For fractional exponents or exponents greater than MaxInt, Base must be greater than 0. |
Examples: |
Pow(2, 5) return 32 Pow(4.1, 3) return 68.921 |
|
Rnd |
|
NUMBER |
Generates a random number (float value) between 0 and 1. |
Category: |
Number Functions |
Name: |
Rnd |
Arguments: |
|
Return Type: |
NUMBER |
Description: |
Generates a random number (float value) between 0 and 1. |
|
Sign |
NUMBER N |
NUMBER |
Returns the signed value of number N |
Category: |
Number Functions |
Name: |
Sign |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the signed value of number N |
Examples: |
Sign(X) returns -1 if X < 0, +1 if X > 0, 0 if X=0. It can be used as Sqr(X) |
|
Sin |
NUMBER N |
NUMBER |
Returns the sine of the number N |
Category: |
Number Functions |
Name: |
Sin |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the sine of the number N. The number N is in radians. |
Examples: |
Sin(50) will return -0.26237485370393 |
|
Sinh |
NUMBER N |
NUMBER |
Returns the hyperbolic sine of number N |
Category: |
Number Functions |
Name: |
Sinh |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the hyperbolic sine of number N, defined as (exp(N) – exp(-N))/2. |
Examples: |
Sinh(2) will return 3.626860407847 |
|
Sqr |
NUMBER N |
NUMBER |
Returns the square of argument. |
Category: |
Number Functions |
Name: |
Sqr |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the square of argument. |
Examples: |
Sqr(“7”) will return 49 |
|
Sqrt |
NUMBER N |
NUMBER |
Returns the square root of number N |
Category: |
Number Functions |
Name: |
Sqrt |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the square root of number N |
Examples: |
Sqrt(“49”) will return 3 |
|
Tan |
NUMBER N |
NUMBER |
Returns the tangent of the number N |
Category: |
Number Functions |
Name: |
Tan |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Returns the tangent of the number N. The number N is in radians. |
Examples: |
Tan(2) will return -2.1850398632615 |
|
Trunc |
NUMBER N |
NUMBER |
Discards the fractional part of a number N |
Category: |
Number Functions |
Name: |
Trunc |
Arguments: |
NUMBER N |
Return Type: |
NUMBER |
Description: |
Discards the fractional part of a number N |
Examples: |
TRUNC(-3.2) will return -3 TRUNC(3.2) will return 3 |
|
Val |
TEXT argument |
NUMBER |
Returns the floating point numeric value of the text value. |
Category: |
Number Functions |
Name: |
Val |
Arguments: |
TEXT argument |
Return Type: |
NUMBER |
Description: |
Returns the floating point numeric value of the text value. |
Examples: |
Val(“3.1”) return 3.1 |
|