How to use math functions in make.com

Math functions in make.com let you calculate values, transform numeric data, and control automation logic with precision. This guide explains how to use each math function step by step so you can build reliable and accurate workflows.

Getting started with make.com math functions

Math functions in make.com are used inside the expression editor, typically in fields that accept formulas or mappable values. You can combine them with variables from modules to calculate totals, percentages, differences, or any numeric transformation your scenario needs.

To add a math expression:

1. Open your scenario and click into a field that supports expressions.
2. Click the Formula icon to open the expression editor.
3. Start typing the name of the math function.
4. Select it from the suggestion list and fill in the required parameters.

All functions described here follow the syntax shown on the official math functions help page. Use this how-to article as a practical reference while building your automations in make.com.

Core arithmetic functions in make.com

Core arithmetic functions help you perform basic calculations such as addition, subtraction, multiplication, and division directly in your scenarios.

Addition in make.com

Use the add() function when you need to sum two or more numeric values.

• Purpose: Add numbers together.
• Typical use cases: Calculate order totals, sum quantities, or combine values from multiple modules.

Syntax example:

add(5; 10)

This returns 15. You can replace the numbers with mapped fields from previous modules to calculate totals dynamically in make.com.

Subtraction in make.com

The sub() function subtracts one number from another.

• Purpose: Find differences between numeric values.
• Typical use cases: Calculate remaining stock, time differences in minutes, or balance changes.

Syntax example:

sub(20; 3)

This returns 17.

Multiplication in make.com

The mul() function multiplies two or more numbers.

• Purpose: Scale values or compute products.
• Typical use cases: Calculate prices with quantity, convert units by multiplying with factors, or compute percentage values from a base.

Syntax example:

mul(4; 2.5)

This returns 10.

Division in make.com

The div() function divides one number by another.

• Purpose: Compute ratios or split values.
• Typical use cases: Calculate averages, distribute costs per item, or convert time and distance units.

Syntax example:

div(20; 4)

This returns 5. Always make sure the second parameter is not zero to avoid errors in your make.com scenario.

Rounding and absolute value in make.com

Rounding functions help you control how many decimal places your numbers use and how they are displayed or stored. This is vital for finance, reporting, and data export tasks in make.com.

Absolute value in make.com

The abs() function returns the absolute value of a number, stripping any negative sign.

• Purpose: Ensure a non-negative result.
• Typical use cases: Work with distances, error ranges, or any metric where negative values are not meaningful.

Syntax example:

abs(-7)

This returns 7.

Standard rounding with round()

The round() function rounds a number to a specified number of decimal places using standard rounding rules.

• Purpose: Format numbers to a fixed precision.
• Typical use cases: Round prices, percentages, or metrics for reporting.

Syntax example:

round(3.14159; 2)

This returns 3.14. The second argument sets the number of decimal places you want in make.com.

Rounding down with floor()

The floor() function always rounds a number down to the nearest whole integer.

• Purpose: Get the largest integer less than or equal to a value.
• Typical use cases: Calculate full units, group items into complete batches, or ignore partial quantities.

Syntax example:

floor(4.9)

This returns 4.

Rounding up with ceil()

The ceil() function always rounds a number up to the nearest whole integer.

• Purpose: Get the smallest integer greater than or equal to a value.
• Typical use cases: Calculate required containers, pages, or batches even when there is a partial remainder.

Syntax example:

ceil(4.1)

This returns 5.

Power, roots, and modulo in make.com

When you need more advanced calculations, make.com offers exponent, root, and modulo functions. These are helpful in scoring systems, data science integrations, and conditional logic.

Power calculation with pow()

The pow() function raises a number to the power of another number.

• Purpose: Calculate exponents.
• Typical use cases: Compute growth, weights, or scoring formulas.

Syntax example:

pow(2; 3)

This returns 8.

Square root with sqrt()

The sqrt() function returns the square root of a number.

• Purpose: Extract square roots.
• Typical use cases: Work with statistics, geometry, or normalizing values inside make.com scenarios.

Syntax example:

sqrt(16)

This returns 4.

Remainder with mod()

The mod() function returns the remainder of a division.

• Purpose: Determine the remainder after integer division.
• Typical use cases: Run actions every Nth item, handle even/odd logic, or cycle through items in repeating patterns in make.com.

Syntax example:

mod(10; 3)

This returns 1.

Random numbers and minimum/maximum in make.com

Randomization and boundary functions let you create test data, limit values, or keep numbers within safe ranges across your make.com automations.

Random numbers with rand()

The rand() function generates a random number between two values.

• Purpose: Create random integers in a defined range.
• Typical use cases: Generate test IDs, sample subsets of records, or add non-critical randomness to your workflows.

Syntax example:

rand(1; 100)

This returns a random integer between 1 and 100, inclusive.

Minimum with min()

The min() function returns the smallest number from the provided arguments.

• Purpose: Find the lowest value.
• Typical use cases: Cap discounts, enforce lower bounds, or compare metrics across modules in make.com.

Syntax example:

min(5; 2; 9)

This returns 2.

Maximum with max()

The max() function returns the largest number from the provided arguments.

• Purpose: Find the highest value.
• Typical use cases: Keep scores, track maximum usage, or enforce upper limits on numeric settings in make.com.

Syntax example:

max(5; 2; 9)

This returns 9.

Tips for reliable math expressions in make.com

To keep your expressions stable and easy to maintain, follow these best practices whenever you use math functions.

• Validate data types: Ensure that mapped fields contain numbers, not text that looks like a number.
• Handle empty values: Use conditions or default values if a module might return empty outputs.
• Avoid division by zero: Check denominators before using the div() or mod() functions.
• Test with sample data: Run your make.com scenario in a safe environment to verify results before going live.

Going further with make.com automations

Once you understand math functions, you can combine them with filters, aggregators, and advanced modules to build powerful end-to-end automations in make.com. You can also integrate these expressions with HTTP modules, databases, CRMs, and analytics tools for complete process automation.

If you want expert help designing or optimizing your automations, you can work with a specialist partner such as Consultevo, which focuses on workflow design, implementation, and optimization.

Use this how-to article together with the official math functions documentation as your ongoing reference whenever you design new scenarios in make.com.

Need Help With Make.com?

If you want expert help building, automating, or scaling your Make scenarios, work with ConsultEvo — certified workflow and automation specialists.

Get Help