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.

Popular use cases from our blog

facebook-leads-airtable-article-illustration

How to Easily Import Leads from Facebook to Mailchimp and Airtable

Active-campaign-automation-illustration.png

How to Boost ActiveCampaign Automations With Integromat

Instagram-for-business-2-illustration

Instagram for Business Automation: 3 Powerful Templates to Get Started

How-to-automate-reporting-with-nocode-illustration

Automated Reporting: Get Rolling With 4 Easy, Practical Solutions

How-to-manage-Twitter-from-a-Notion-database-part-1-Illustzration

Can You Tweet From Notion? Yes, and Here’s How to Do It [Tutorial]

slack-automation-illustration

Slack Automation: 20 Free Templates to Get You Inspired

Didn’t find what you were looking for?

Ticket

Create a ticket

Contact our world-class support team and tell us what’s happening.

Create a ticket
Expert

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.