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