Sometimes, you just need to tidy up a number. Maybe it has too many decimal places, or you want to round it up or down. In this tutorial, I’ll show you how to do exactly that in Make.com—step by step.
Table of Contents
Watch this video, or scroll down for the written examples 🙂
Round to the Nearest Whole Number
If you want to round the number to the nearest whole number, you can simply use the round() math function.
round(5.28397)
= 5
round(1.2)
= 1
round(1.5)
= 2
round(9)
= 9
Always Round Down (Floor)
If you need the number to always round down to the nearest whole number, use the floor() math function.
floor(5.28397)
= 5
floor(1.3)
= 1
floor(9)
= 9
Always Round Up (Ceil)
Need your number to always round up to the nearest whole number? Then the ceil() math function is what you need.
ceil(5.28397)
= 6
ceil(1.3)
= 2
ceil(9)
= 9
Limit a Number to Two Decimal Places
Rounding a number and limiting it to a certain amount of decimal places is slightly more tricky, because we have to multiply round and divide it.
First, multiply your number by 100.
5.28397*100
= 528.397
We then use the round() math function to round it up or down to the nearest whole number.
round(5.28397*100)
= 528
And then, we divide that by 100.
round(5.28397*100)/100
= 5.28
And as you can see, that properly rounded the number and limited it to two decimal places.
If you want a different amount of decimals, let’s say three decimal places, simply multiply it by 1000 and divide it by 1000 like this:
round(5.28397*1000)/1000
= 5.284
Conclusion
This simple yet powerful approach allows you to round numbers to meet your exact requirements in Make.com.
Let me know in the comments if you have any questions or ideas for more tutorials!
Interesting approach, though I’m not sure how often I’d use it.
Hey Dwayne! Yes, you need to have a specific use case for it 🤗
I got the question a few times, so I thought I make a quick tutorial out of it!
Hey Max, this was such a helpful post! I’ve been using Make.com for a while now, but I never really thought about how to handle rounding numbers in such a structured way. The breakdown of each method—round, floor, ceil—was super clear and easy to follow. I especially liked the part about limiting numbers to two decimal places; that’s something I’ve struggled with in the past, and your explanation made it seem so straightforward.
One thing I was wondering though—does this approach work seamlessly with all types of data inputs in Make.com? For example, if the number is coming from an external API or a text field, would there be any additional steps needed? Thanks again for sharing this tutorial—it’s definitely going to save me time!
Happy to hear!
And yes, it should seamlessly work with all types of data inputs, as long as it’s a number 🙂
Hi Max, thanks for the clear tutorial! I’m just wondering how this rounding method in Make.com compares to traditional programming languages like Python or JavaScript? I’ve used both for similar tasks, and sometimes the results can be a bit different, especially with floating point numbers. Have you noticed any peculiarities or differences in how Make.com handles these operations that we should be aware of? It would be great to know if there are any specific cases where Make.com might not behave as expected. Thanks again!
Hey Tanvi! I’m not a programmer, so I’m not sure how it compares to Python or Javascript. Sorry!