Overview
TBD

Variables
PI
Returns the value of Pi, 3.14159265358979, accurate to 15 digits
Syntax: pi()


Random()
A floating-point, random number between 0 (inclusive) and 1 (exclusive)
Syntax: random()


RandomInt()
A random integer number between 0 (exclusive) and 2147483647 (inclusive)
Syntax: RandomInt()


Functions
Average
Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers
Syntax: average([number1, number2,...])


Int
Returns integer of a number
Syntax: int(number)


Ceil
Returns the smallest integer greater than or equal to a specified number
Syntax: ceil(number)


Floor
Returns the largest integer less than or equal to a specified number
Syntax: floor(number)


MAX
Returns the largest number in a specified array, or the largest number among numbers entered individually
Syntax: max([number1, number2,...])


Average
Returns integer of a number
Syntax: int(number)


MIN
Returns the smallest number in a specified array, or the smallest number among numbers entered individually
Syntax: min([number1, number2,...])


Round
Rounds a numeric value to the nearest integer
Syntax: round(number)


Format Number
Returns a number in the requested format. Decimal point is , by default, Thousands separator is . by default
Syntax: formatNumber(number, decimalPoints, [decimalSeparator], [thousandsSeparator])


Parse Number
Parses a string with a number and returns the number. Example: parseNumber(1 756,456;,)
Syntax: parseNumber(number, decimal separator)


SUM
Returns the sum of the values in a specified array, or the sum of numbers entered individually
Syntax: sum([number1, number2,...])


Operators
Addition
Syntax: +


Addition
Syntax: +


Substruction
Syntax: -


Multiplication
Syntax: *


Division
Syntax: /


Modulus
Syntax: %


Lower than
Syntax: <


Lower than or equal to
Syntax: <=


Greater than
Syntax: >


Greater than or equal to
Syntax: >=
Was this article helpful?
Cancel
Thank you!