Hi guys,
I have a a special case I’m hoping someone can help with…
I want to round down a number to the nearest step of 25. e.g.:
1292 → 1275
2349 → 2325
2351 → 2350
2350 → 2350
Any ideas?
Hello @dgee9663 try using the Floor Function in Make, use it like this:
“floor” represents the mathematical function that rounds a number down to the nearest integer. Let’s apply this formula to the examples you provided:
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
3 Likes
That works great - thank you! 
3 Likes