Numeric Functions
Function | Description | Syntax |
|---|---|---|
Abs | Returns the absolute value of a number. The absolute value is the number without a sign. For example: Abs(-4) = 4, Abs(9) = 9 | Abs(Num) |
Ceiling | Returns a number rounded up to a whole number. The number can be zero or negative. For example: Ceiling(2.5) = 3, Ceiling(0) = 0, Ceiling(-4.37) = -4. | Ceiling(Num) |
Exp | Returns e raised to the power of Num. The constant e equals 2.71828182845904, the base of the natural logarithm. For example: Exp(1) = 2.71828. | Exp(Num) |
Floor | Rounds a number down to a whole number. For example: Floor(4.3) = 4, Floor(.119) = 0, Floor(-5.4) = -6. | Floor(Num) |
Ln | Returns the natural logarithm (the inverse of the Exp function). The number must be positive. For example, Ln(55) = 4.00733, Ln(Exp(4)) = 4, Ln(2.71828) = .9999. | Ln(Num) |
Log10 | Returns the base 10 logarithm of a number. The number must be positive. For example, Log10(5) = .69897. | Log10(Num) |
Max | Returns the largest number of the two arguments. For example, Max(4,9) = 9. | Max(Num1, Num2) |
Min | Returns the smallest number of the two arguments. For example, Min(4,9) = 4. | Min(Num1, Num2) |
Round | Rounds the number to the number of specified digits. If NumDigits is greater than zero, it rounds to the specified decimal places. If NumDigits equals zero, it rounds to the nearest integer. If NumDigits is less than zero, it rounds to the left of the decimal. For example, Round(3.45, 1) = 3.5, Round(11.5,-1) = 10. | Round(Num, NumDigits) |
Sqrt | Returns the positive square root. The number must be positive. For example, Sqrt(25) =5. | Sqrt(Num) |
Trunc | Rounds the number toward zero to the nearest integer or nearest NumDigits decimal place. For example: Trunc(9.765,0) = 9, Trunc(9.765,2) = 9.76, Trunc(65, -1) = 60, Trunc (-9.765, 2) = -9.76. | Trunc(Num, NumDigits) |