◷ Reading Time: 7 minutes
abs
Returns the absolute value of a double-precision floating-point number.
abs (value)- value (Numeric): The number to calculate abs(Mandatory)
Example: abs (-10)
Result: 10
Example: abs (-0.2)
Result: 0.2
Example: abs (32)
Result: 32
ceiling
Returns the smallest integral value that is greater than or equal to the specified double-precision floating-point number.
ceiling (value, scale)- value (Numeric): Any number (i.e. float, decimal, double, long, in). (Mandatory)
- scale : Numbers of required scale to be ceiling (optional)
Example: ceiling (42.321, 2)
Result: 42.33
Example: ceiling(-12.11, 1)
Result: -12.1
decimal
Returns the value with given scale.
decimal (n, scale)- n (Numeric): Any number with a floating point (i.e. float, decimal, double, long). (Mandatory)
- scale (Numeric): Numbers of required scale to be floor (Mandatory)
Example: decimal (150.132, 2)
Result: 150.13
Example: decimal (0.015, 2)
Result: 0.02
Example: decimal (160, -2)
Result: 200
exp
Returns the Euler’s number e raised to the power of number.
exp (value)- value(Numeric): the number to calculate exponential (mandatory)
Example: exp (10)
Result: 22026.465
Example: exp (-1)
Result: 0.367879441171442
even
Returns true if number is even, false if it is odd.
even (value)- value(Numeric): any number (mandatory)
Example: even (15)
Result: false
floor
Returns the largest integer less than or equal to the specified number.
floor (value, scale)- value (Decimal Number): Any number with a floating point (i.e. float, decimal, double, long). (Mandatory)
- scale : Numbers of required scale to be floor (optional)
Example: floor (100.56)
Result: 100
Example: floor (-2.10)
Result: -3
Example: floor (105.141, 2)
Result: 105.14
log
Returns the natural logarithm of a specified number.
log (value)- value (Numeric): The number to calculate log (Mandatory)
- base is e=2.718281828459045
Example: log (5)
Result: 1.6094379124341
Example: log (10)
Result: 2.30258509299405
modulo
Returns the remainder of the division of dividend by divisor.
modulo (dividend, divisor)- dividend (Numeric): The number being divided (Mandatory)
- divisor (Numeric): The number by which dividend is divided (Mandatory)
Example: modulo(10.1, -4.5)
Result: -3.4
Example: modulo (12, 5)
Result: 2
Example: modulo (-15, 6)
Result: 3
odd
Returns true if number is odd, false if it is even.
odd (value)- value(Numeric): any number (mandatory)
Example: odd (15)
Result: true
round up
Rounds a numeric value to the nearest integral value.
round up (value, scale)- value (Numeric): Number to be rounded (Mandatory)
- scale: Numbers of required decimal to be round to (Mandatory)
Example: round up (23.4567, 2)
Result: 23.46
Example: round up (-23.4567, 3)
Result: -23.457
Example: round up (23.567)
Result: null
round down
Rounds a numeric value to the nearest decimal value.
round down (value, scale)- value (Numeric): Number to be rounded (Mandatory)
- scale: Numbers of required decimal to be round to (Mandatory)
Example: round down (23.4567, 2)
Result: 23.45
Example: round down (-23.4567, 3)
Result: -23.456
Example: round down (23.567)
Result: null
round half up
Rounds a numeric value to the nearest integral value.
round half up (value, scale)- value (Numeric): Number to be rounded (Mandatory)
- scale: Numbers of required decimal to be round to (Mandatory)
Example: round half up (23.4567, 2)
Result: 23.46
Example: round half up (-45.2113, 3)
Result: -45.211
Example: round half up (-45.2115, 3)
Result: -45.212
round half down
Rounds a numeric value to the nearest decimal value.
round half down (value, scale)- value (Numeric): Number to be rounded (Mandatory)
- scale: Numbers of required decimal to be round to (Mandatory)
Example: round half down (23.4567, 2)
Result: 23.45
Example: round half down (-45.2113, 3)
Result: -45.211
Example: round half down (-45.2115, 3)
Result: -45.211
sqrt
Returns the square root of the given number.
sqrt (value)- value (Numeric): the number to calculate sqrt (Mandatory)
Example: sqrt (16)
Result: 4
Example: sqrt (0.25)
Result: 0.5