Articles on: Connectors

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

``Syntax: +``

``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