Math functions¶
average ([array of values]) average(value1; [value2], ...)¶
Returns the average value of the numeric values in a specific array, or the average value of numerical values entered individually.
ceil (number)¶
Returns the smallest integer greater than or equal to a specified number.
ceil( 1.2 )
= 2
ceil( 4 )
= 4
floor (number)¶
Returns the largest integer less than or equal to a specified number.
floor( 1.2 )
= 1
floor( 1.9 )
= 1
floor( 4 )
= 4
formatNumber (number; decimalPOINTS; [decimalSeparator]; [thousandsSeparator])¶
Returns a number in the requested format. Decimal point is `,` by default, Thousands separator is `.` by default.
formatNumber( 123456789 ; 3 ; , ; . )
= 123.456.789,000
max ([array of values]), max(value1;value2; ...)¶
Returns the largest number in a specified array, or the largest number among numbers entered individually.
min ([array of values]), min(value1;value2; ...)¶
Returns the smallest number in a specified array, or the smallest number among numbers entered individually.
parseNumber (number; decimal separator)¶
Parses a string with a number and returns the number.
Example: parseNumber( 1 756,456 ; , )
round (number)¶
Rounds a numeric value to the nearest integer.
round( 1.2 )
= 1
round( 1.5 )
= 2
round( 1.7 )
= 2
round( 2 )
= 2
sum ([array of values]), sum(value1;value2; ...)¶
Returns the sum of the values in a specified array, or the sum of numbers entered individually.