# Number Functions | Name | Category | Arguments | Result | Description | Example | | ----- | ---------------- | ----------------------- | ------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------- | | Abs | Number Functions | NUMBER N | NUMBER | Returns the absolute value of number N | Abs(-4.2) will return 4.2 Abs(5) will return 5 | | ATan | Number Functions | NUMBER N | NUMBER | 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. | ATan(50) will return 1.5507989928217 | | Ceil | Number Functions | NUMBER N | NUMBER | Returns the next highest integer value by rounding up value if necessary. | Ceil(5.2) will return 6 Ceil(2.4) will return 3 | | Cos | Number Functions | NUMBER N | NUMBER | Returns the cosine of the number N. The number N is in radians. | Cos(50) will return 0.96496602849211 | | Cosh | Number Functions | NUMBER N | NUMBER | Returns the hyperbolic cosine of number N, defined as (Exp(N) + Exp(-N))/2. | Cosh(2) will return 3.7621956910836 | | CoTan | Number Functions | NUMBER N | NUMBER | Returns the cotangent of number N, defined as 1/Tan(N). The number N is in radians. | CoTan(2) will return -0.45765755436029 | | Exp | Number Functions | NUMBER N | NUMBER | Returns e raised to the power of number N. ‘e’ is the base of the natural system of logarithms, or approximately 2.718282. | Exp(2) will return 7.3890560989307 | | Floor | Number Functions | NUMBER N | NUMBER | Returns the next lowest integer value (as float) by rounding down value if necessary. |

Floor(5.2) will return 4

Floor(2.4) will return 2

| | Ln | Number Functions | NUMBER N | NUMBER | Returns natural log of the number N | | | Log10 | Number Functions | NUMBER N | NUMBER | Returns the base-10 logarithm of number N | | | Logn | Number Functions | NUMBER base, NUMBER N | NUMBER | Returns the log base of number N | Logn(10, 100) return 2 | | Pow | Number Functions | NUMBER base, NUMBER exp | NUMBER | The Power function raises Base to any power. For fractional exponents or exponents greater than MaxInt, Base must be greater than 0. | Pow(2, 5) return 32 Pow(4.1, 3) return 68.921 | | Rnd | Number Functions | | NUMBER | Generates a random number (float value) between 0 and 1. | | | Sign | Number Functions | NUMBER N | NUMBER | Returns the signed value of number N | Sign(X) returns -1 if X < 0, +1 if X > 0, 0 if X=0. It can be used as Sqr(X) | | Sin | Number Functions | NUMBER N | NUMBER | Returns the sine of the number N. The number N is in radians. | Sin(50) will return -0.26237485370393 | | Sinh | Number Functions | NUMBER N | NUMBER | Returns the hyperbolic sine of number N, defined as (exp(N) – exp(-N))/2. | Sinh(2) will return 3.626860407847 | | Sqr | Number Functions | NUMBER N | NUMBER | Returns the square of argument. | Sqr(“7”) will return 49 | | Sqrt | Number Functions | NUMBER N | NUMBER | Returns the square root of number N | Sqrt(“49”) will return 3 | | Tan | Number Functions | NUMBER N | NUMBER | Returns the tangent of the number N. The number N is in radians. | Tan(2) will return -2.1850398632615 | | Trunc | Number Functions | NUMBER N | NUMBER | Discards the fractional part of a number N | TRUNC(-3.2) will return -3 TRUNC(3.2) will return 3 | | Val | Number Functions | TEXT argument | NUMBER | Returns the floating point numeric value of the text value. | Val(“3.1”) return 3.1 |