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
@Manu.n & @Jeff_Hager
Perfect!
Thank you!
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”
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?
I think “round” is your solution
Yes yes. Right . My example was wrong. So if round up use round(x/100)*100?
Thank you!
@Darren_Murphy @Manu.n
Yeah, I’d suggest Round. Perfect
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 ?
Thanks @Darren_Murphy !