User Guides

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