Integromat
  • Back to website
Articles in this section
  • Using Functions
  • Certificates and Keys
  • Math Variables
  • General Functions
  • String Functions
  • Math Functions
  • Date & Time Functions
  • Array Functions
  • Tokens for date/time formatting
  • Tokens for date/time parsing
  1. Integromat Support
  2. Using Integromat
  3. Functions

Math Functions

Integromat Support Team Integromat Support Team Updated April 14, 2021 18:22

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.

Was this article helpful?
18 out of 97 found this helpful
Menu
  • Features
  • Apps & Services
  • Templates
  • Pricing
  • What's new
  • Use cases
  • Feature requests
Information
  • Privacy
  • Terms
  • FAQ
  • Help & Tutorials
  • Community
  • Academy
  • Find a partner
  • Blog
Cooperation
  • Developer platform
  • Affiliate Program
  • Become a partner
  • Schools and Universities
Company
  • About the company
  • We are hiring
  • Contact
Follow us
© 2021 Integromat by Celonis. All rights reserved. Integromat® is a registered trademark.
  • English