Numeric Functions
name | description |
---|---|
CEIL | Round a number up |
FLOOR | Round a number down |
ROUND | Round a number |
ABS | Return the absolute value of a number |
ACOS | Return the arc cosine of a number |
ASIN | Return the arc sine of a number |
ATAN | Return the arc tangent of a number |
ATAN2 | Return the arc tangent of two numbers |
COS | Return the cosine of a number |
SIN | Return the sine of a number |
TAN | Return the tangent of a number |
EXP | Return the value of base e raised to the power of a number |
EXP2 | Return the value of base 2 raised to the power of a number |
EXPM1 | Return the value of base e rised to the power of a number minus 1 |
LOG | Return the natural logarithm of a number |
LOG10 | Return the decimal logarithm of a number |
LOG2 | Return the binary logarithm of a number |
LOG1P | Return the natural logarithm of 1 plus a number |
SQRT | Return the square root of a number |
POW | Returns the value of a number raised to the power of another number |
BIN_TO_DEC | Convert a string representing a binary number to an integer |
OCT_TO_DEC | Convert a string representing a octal number to an integer |
HEX_TO_DEC | Convert a string representing a hexadecimal number to an integer |
ENOTATION_TO_DEC | Convert a string representing a number with exponential notation to an integer or a float |
BIN | Convert an integer to a string representing the bynary number |
OCT | Convert an integer to a string representing the octal number |
HEX | Convert an integer to a string representing the hexadecimal number |
ENOTATION | Convert a float to a string representing the number with exponential notation |
NUMBER_FORMAT | Convert a number to a string representing the number with separators |
RAND | Return a pseudo-random number |
e is the base of natural logarithms
Definitions
CEIL
CEIL(number)
Rounds number up to an integer value.
CEIL(number, place)
Rounds number up to place decimal place. If place is a negative number, place represents the place in the integer part.
FLOOR
FLOOR(number)
Rounds number down to an integer value.
FLOOR(number, place)
Rounds number down to place decimal place. If place is a negative number, place represents the place in the integer part.
ROUND
ROUND(number)
Rounds number to an integer value.
ROUND(number, place)
Rounds number to place decimal place. If place is a negative number, place represents the place in the integer part.
ABS
ABS(number)
Returns the absolute value of number
ACOS
ACOS(number)
Returns the arc cosine of number.
ASIN
ASIN(number)
Returns the arc sine of number.
ATAN
ATAN(number)
Returns the arc tangent of number.
ATAN2
ATAN2(number2, number1)
Returns the arc tangent of number2 / number1, using the signs of the two to determine the quadrant of the returns value.
COS
COS(number)
Returns the cosine of number.
SIN
SIN(number)
Returns the sine of number.
TAN
TAN(number)
Returns the tangent of number.
EXP
EXP(number)
Returns the value of base e raised to the power of number.
EXP2
EXP2(number)
Returns the value of base 2 raised to the power of number.
EXPM1
EXPM1(number)
Returns the value of base e rised to the power of number minus 1.
LOG
LOG(number)
Returns the natural logarithm of number.
LOG10
LOG10(number)
Returns the decimal logarithm of number.
LOG2
LOG2(number)
Returns the binary logarithm of number.
LOG1P
LOG1P(number)
Returns the natural logarithm of 1 plus number.
SQRT
SQRT(number)
Returns the square root of number.
POW
POW(base, exponent)
Returns the value of base raised to the power of exponent.
BIN_TO_DEC
BIN_TO_DEC(bin)
Converts bin representing a binary number to an integer.
OCT_TO_DEC
OCT_TO_DEC(oct)
Converts hex representing a octal number to an integer.
HEX_TO_DEC
HEX_TO_DEC(hex)
Converts hex representing a hexadecimal number to an integer.
ENOTATION_TO_DEC
ENOTATION_TO_DEC(enotation)
Converts enotation representing a number with exponential notation to an integer or a float.
BIN
BIN(integer)
Converts integer to a string representing the binary number.
OCT
OCT(integer)
Converts integer to a string representing the octal number.
HEX
HEX(integer)
Converts integer to a string representing the hexadecimal number.
ENOTATION
ENOTATION(float)
Converts float to a string representing the number with exponential notation.
NUMBER_FORMAT
NUMBER_FORMAT(number [, precision, decimalPoint, thousandsSeparator, decimalSeparator])
- number
- float or integer
- precision
- integer
The default is -1. -1 is the special precision to determine the number of digits automatically.
- decimalPoint
- string
The default is “.”.
- thousandsSeparator
- string
The default is “,”.
- decimalSeparator
- string
The default is empty string.
- return
- string
Converts number to a string representing the number with separators.
RAND
RAND()
- return
- float
Returns a random float greater than or equal to 0.0 and less than 1.0.
RAND(min, max)
Returns a random integer between min and max.