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?

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

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

Yeah, Iâ€™d suggest Round. Perfect

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 ?