Round Up to Nearest Hundred

[biha]

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?

[Jeff_Hager]

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

Floor(X/100)*100

[Manu.n]

[biha]

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

[biha]

@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 ?

[Manu.n]

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

[Darren_Murphy]

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?

[Manu.n]

I think “round” is your solution

[biha]

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

[biha]

Thank you!
@Darren_Murphy @Manu.n

[Lucas_Pires]

Yeah, I’d suggest Round. Perfect

[biha]

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 ?

[Darren_Murphy]

Ceiling(N/100)*100

Where N is your number.

[biha]

Thanks @Darren_Murphy !