Master Rounding Down Numbers in Make: A Guide

Have you ever found yourself needing to round down a number to the nearest step of 25? It's not as straightforward as it might seem, but don't worry, we've got you covered!

The Problem

Let's say you have a number like 1292, and you want to round it down to the nearest step of 25. That would be 1275. Or maybe you have 2349, and you want to round it down to 2325. It's not as simple as just subtracting a few numbers, is it?

The Solution

Fortunately, there's a mathematical function that can help us out here: the Floor Function. In Make, you can use it like this:

"floor" represents the mathematical function that rounds a number down to the nearest integer.

Here's how you can apply this formula to your numbers:

• For 1292: result = floor(1292 / 25) * 25 result = floor(51.68) * 25 result = 51 * 25 result = 1275
• For 2349: result = floor(2349 / 25) * 25 result = floor(93.96) * 25 result = 93 * 25 result = 2325
• For 2351: result = floor(2351 / 25) * 25 result = floor(94.04) * 25 result = 94 * 25 result = 2350
• For 2350: result = floor(2350 / 25) * 25 result = floor(94) * 25 result = 94 * 25 result = 2350

Troubleshooting Tips

If you're not getting the results you expect, make sure you're using the floor function correctly. Remember, it rounds down to the nearest integer, not up. Also, make sure you're multiplying the result by 25 at the end to get your final number.

Summary

So there you have it! With the help of the floor function, you can easily round down any number to the nearest step of 25. Happy Making!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.