Round Up to Nearest Hundred

Hi,

Let say, I made some calculation in math column for $597,471.
I want it to be $597,500

or $12,963 and I want it to be $13,000.

How to make it rounded?

Divide the value by 100, wrap it with a floor(), then multiply that by 100.

Floor(X/100)*100

5 Likes

4 Likes

@Manu.n & @Jeff_Hager
Perfect!
Thank you!

2 Likes

@Manu.n & @Jeff_Hager

But I noticed , if $291,297 it will become $291,200. It should be $291,300 right ?
Do you have any idea why ?

yes we followed your example, so rounding down, if you want you can use “ceil” for rounding up
or “round”

2 Likes

Maybe because your requirements were confusing?
You asked how to round up, but then the two examples you gave were rounded down.
Now it appears that you want to round to the nearest.

So which is it?

3 Likes

I think “round” is your solution

3 Likes

Yes yes. Right . My example was wrong. So if round up use round(x/100)*100?

1 Like

Thank you!
@Darren_Murphy @Manu.n

Yeah, I’d suggest Round. Perfect :grin:

2 Likes

Hi,

I noticed when I am using round(x/100)*100,
The answer for :
$12,629 is $12,600
$60,170 is $60,200

How to round up for all to nearest hundred ?
So that the $12,629 will be $12,700
and $60,170 is correct, $60,200.

Do you have any ideas ?

Ceiling(N/100)*100

Where N is your number.

4 Likes

Thanks @Darren_Murphy !