Numeric Functions

name	description
ABS	Return the absolute value of a number
ACOS	Return the arc cosine of a number
ACOSH	Return the inverse hyperbolic cosine of a number
ASIN	Return the arc sine of a number
ASINH	Return the inverse hyperbolic sine of a number
ATAN	Return the arc tangent of a number
ATAN2	Return the arc tangent of two numbers
ATANH	Return the inverse hyperbolic tangent of a number
CBRT	Return the cube root of a number
CEIL	Round a number up
COS	Return the cosine of a number
COSH	Return the hyperbolic cosine 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
FLOOR	Round a number down
IS_INF	Return whether number is an infinity
IS_NAN	Return whether number is a NaN
LOG	Return the natural logarithm of a number
LOG10	Return the decimal logarithm of a number
LOG1P	Return the natural logarithm of 1 plus a number
LOG2	Return the binary logarithm of a number
LOGB	Return the binary exponent of a number
POW	Returns the value of a number raised to the power of another number
ROUND	Round a number
SIN	Return the sine of a number
SINH	Return the hyperbolic sine of a number
SQRT	Return the square root of a number
TAN	Return the tangent of a number
TANH	Return the hyperbolic tangent of a 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

ABS

ABS(number)

number: float
return: float

Returns the absolute value of number

ACOS

ACOS(number)

number: float
return: float

Returns the arc cosine of number.

ACOSH

ACOSH(number)

number: float
return: float

Returns the inverse hyperbolic cosine of number.

ASIN

ASIN(number)

number: float
return: float

Returns the arc sine of number.

ASINH

ASINH(number)

number: float
return: float

Returns the inverse hyperbolic sine of number.

ATAN

ATAN(number)

number: float
return: float

Returns the arc tangent of number.

ATAN2

ATAN2(number2, number1)

number2: float
number1: float
return: float

Returns the arc tangent of number2 / number1, using the signs of the two to determine the quadrant of the returns value.

ATANH

ATANH(number)

number: float
return: float

Returns the inverse hyperbolic tangent of number.

CBRT

CBRT(number)

number: float
return: float

Returns the cube root of number.

CEIL

CEIL(number)

number: float
return: float

Rounds number up to an integer value.

CEIL(number, place)

number: float
place: integer
return: float

Rounds number up to place decimal place. If place is a negative number, place represents the place in the integer part.

COS

COS(number)

number: float
return: float

Returns the cosine of number.

COSH

COSH(number)

number: float
return: float

Returns the hyperbolic cosine of number.

EXP

EXP(number)

number: float
return: float

Returns the value of base e raised to the power of number.

EXP2

EXP2(number)

number: float
return: float

Returns the value of base 2 raised to the power of number.

EXPM1

EXPM1(number)

number: float
return: float

Returns the value of base e rised to the power of number minus 1.

FLOOR

FLOOR(number)

number: float
return: float

Rounds number down to an integer value.

FLOOR(number, place)

number: float
place: integer
return: float

Rounds number down to place decimal place. If place is a negative number, place represents the place in the integer part.

IS_INF

IS_INF(number [, sign])

number: float
sign: integer
The default is 0.
return: ternary

Returns whether number is an infinity. If sign is greater than 0, then returns whether number is a positive infinity. If sign is less than 0, then returns whether number is a negative infinity. If sign is 0, then returns whether number is either infinity.

IS_NAN

IS_NAN(number)

number: float
return: ternary

Returns whether number is a NaN.

LOG

LOG(number)

number: float
return: float

Returns the natural logarithm of number.

LOG10

LOG10(number)

number: float
return: float

Returns the decimal logarithm of number.

LOG1P

LOG1P(number)

number: float
return: float

Returns the natural logarithm of 1 plus number.

LOG2

LOG2(number)

number: float
return: float

Returns the binary logarithm of number.

LOGB

LOGB(number)

number: float
return: float

Returns the binary exponent of number.

POW

POW(base, exponent)

base: float
exponent: float
return: float

Returns the value of base raised to the power of exponent.

ROUND

ROUND(number)

number: float
return: float

Rounds number to an integer value.

ROUND(number, place)

number: float
place: integer
return: float

Rounds number to place decimal place. If place is a negative number, place represents the place in the integer part.

SIN

SIN(number)

number: float
return: float

Returns the sine of number.

SINH

SINH(number)

number: float
return: float

Returns the hyperbolic sine of number.

SQRT

SQRT(number)

number: float
return: float

Returns the square root of number.

TAN

TAN(number)

number: float
return: float

Returns the tangent of number.

TANH

TANH(number)

number: float
return: float

Returns the hyperbolic tangent of number.

BIN_TO_DEC

BIN_TO_DEC(bin)

bin: string
return: integer

Converts bin representing a binary number to an integer.

OCT_TO_DEC

OCT_TO_DEC(oct)

oct: string
return: integer

Converts hex representing a octal number to an integer.

HEX_TO_DEC

HEX_TO_DEC(hex)

hex: string
return: integer

Converts hex representing a hexadecimal number to an integer.

ENOTATION_TO_DEC

ENOTATION_TO_DEC(enotation)

enotation: string
return: float

Converts enotation representing a number with exponential notation to a float.

BIN

BIN(integer)

integer: integer
return: string

Converts integer to a string representing the binary number.

OCT

OCT(integer)

integer: integer
return: string

Converts integer to a string representing the octal number.

HEX

HEX(integer)

integer: integer
return: string

Converts integer to a string representing the hexadecimal number.

ENOTATION

ENOTATION(float)

float: float
return: string

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)

min: integer
max: integer
return: integer

Returns a random integer between min and max.