# Math functions

Modified on Thu, 30 May at 10:36 AM

Use a math function to apply mathematical operations to data. For example, math functions let you get an average of an array, round a value up or down, or change the format of a number (1 000 000 to 1,000,000 or 1.000.000). Below is a list of supported math functions and a brief description of each one.

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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Feedback sent

We appreciate your effort and will try to fix the article