Functions for performing various mathematical operations such as rounding, exponentiation, squaring, etc.
Returns the absolute value of the specified number.
Value := Abs(Number)
The return value is the same type as Number (integer or floating point).
MsgBox Abs(-1.2) ; Returns 1.2
Returns the specified number rounded up to the nearest integer (without any .00 suffix).
Value := Ceil(Number)
MsgBox Ceil(1.2) ; Returns 2 MsgBox Ceil(-1.2) ; Returns -1
Returns the result of raising e (which is approximately 2.71828182845905) to the Nth power.
Value := Exp(N)
N may be negative and may contain a decimal point. To raise numbers other than e to a power, use the ** operator.
MsgBox Exp(1.2) ; Returns 3.320117
Returns the specified number rounded down to the nearest integer (without any .00 suffix).
Value := Floor(Number)
MsgBox Floor(1.2) ; Returns 1 MsgBox Floor(-1.2) ; Returns -2
Returns the logarithm (base 10) of the specified number.
Value := Log(Number)
The result is a floating-point number. If Number is negative, a ValueError is thrown.
MsgBox Log(1.2) ; Returns 0.079181
Returns the natural logarithm (base e) of the specified number.
Value := Ln(Number)
The result is a floating-point number. If Number is negative, a ValueError is thrown.
MsgBox Ln(1.2) ; Returns 0.182322
Returns the highest number from a set of numbers.
Number := Max(Number1 , Number2, ...)
MsgBox Max(2.11, -2, 0) ; Returns 2.11
You can also specify a variadic parameter to pass an array of numbers. For example:
Numbers := [1, 2, 3, 4] MsgBox Max(Numbers*) ; Returns 4
Returns the lowest number from a set of numbers.
Number := Min(Number1 , Number2, ...)
MsgBox Min(2.11, -2, 0) ; Returns -2
You can also specify a variadic parameter to pass an array of numbers. For example:
Numbers := [1, 2, 3, 4] MsgBox Min(Numbers*) ; Returns 1
Modulo. Returns the remainder of a number (dividend) divided by another number (divisor).
Value := Mod(Dividend, Divisor)
The sign of the result is always the same as the sign of the first parameter. If either input is a floating point number, the result is also a floating point number. If the second parameter is zero, a ZeroDivisionError is thrown.
MsgBox Mod(7.5, 2) ; Returns 1.5 (2 x 3 + 1.5)
Returns the specified number rounded to N decimal places.
Value := Round(Number , N)
If N is omitted or 0, Number is rounded to the nearest integer:
MsgBox Round(3.14) ; Returns 3
If N is positive, Number is rounded to N decimal places:
MsgBox Round(3.14, 1) ; Returns 3.1
If N is negative, Number is rounded by N digits to the left of the decimal point:
MsgBox Round(345, -1) ; Returns 350 MsgBox Round(345, -2) ; Returns 300
The result is an integer if N is omitted or less than 1. Otherwise, the result is a numeric string with exactly N decimal places. If a pure number is needed, simply perform another math operation on Round's return value; for example: Round(3.333, 1)+0.
Returns the square root of the specified number.
Value := Sqrt(Number)
The result is a floating-point number. If Number is negative, a ValueError is thrown.
MsgBox Sqrt(16) ; Returns 4
Note: To convert a radians value to degrees, multiply it by 180/pi (approximately 57.29578). To convert a degrees value to radians, multiply it by pi/180 (approximately 0.01745329252). The value of pi (approximately 3.141592653589793) is 4 times the arctangent of 1.
Returns the trigonometric sine of the specified number.
Value := Sin(Number)
Number must be expressed in radians.
MsgBox Sin(1.2) ; Returns 0.932039
Returns the trigonometric cosine of the specified number.
Value := Cos(Number)
Number must be expressed in radians.
MsgBox Cos(1.2) ; Returns 0.362358
Returns the trigonometric tangent of the specified number.
Value := Tan(Number)
Number must be expressed in radians.
MsgBox Tan(1.2) ; Returns 2.572152
Returns the arcsine (the number whose sine is the specified number) in radians.
Value := ASin(Number)
If Number is less than -1 or greater than 1, a ValueError is thrown.
MsgBox ASin(0.2) ; Returns 0.201358
Returns the arccosine (the number whose cosine is the specified number) in radians.
Value := ACos(Number)
If Number is less than -1 or greater than 1, a ValueError is thrown.
MsgBox ACos(0.2) ; Returns 1.369438
Returns the arctangent (the number whose tangent is the specified number) in radians.
Value := ATan(Number)
MsgBox ATan(1.2) ; Returns 0.876058
These functions throw an exception if any incoming parameters are non-numeric or an invalid operation (such as divide by zero) is attempted.