Function Expressions - Math
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: >=
Updated on: 25/07/2022
Thank you!