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