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?

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

1 Like

That works great - thank you!

1 Like