Articles on: Connectors

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

Was this article helpful?

Share your feedback

Cancel

Thank you!