# Round Up to Nearest Hundred **URL:** \ **Category:** Ask for Help\ **Created:** [August 5, 2021, 6:38am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024 "2021-08-05T06:38:43Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 5, 2021, 6:38am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/1 "2021-08-05T06:38:43Z")
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? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 5, 2021, 6:41am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/2 "2021-08-05T06:41:47Z")
Divide the value by 100, wrap it with a floor(), then multiply that by 100. Floor(X/100)\*100 ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 5, 2021, 6:41am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/3 "2021-08-05T06:41:52Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/74f010c44b50d7a5ce14a4fa5ac2eb2cabe3724f.png) ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 5, 2021, 6:44am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/4 "2021-08-05T06:44:15Z")
@Manu.n & @Jeff_Hager Perfect! Thank you! ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 5, 2021, 7:40am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/5 "2021-08-05T07:40:28Z")
@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 ? ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 5, 2021, 7:44am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/6 "2021-08-05T07:44:15Z")
yes we followed your example, so rounding down, if you want you can use “ceil” for rounding up or “round” ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 5, 2021, 7:45am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/7 "2021-08-05T07:45:32Z")
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? ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [August 5, 2021, 7:46am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/8 "2021-08-05T07:46:03Z")
I think “round” is your solution ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 5, 2021, 7:46am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/9 "2021-08-05T07:46:31Z")
Yes yes. Right . My example was wrong. So if round up use round(x/100)\*100? ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 5, 2021, 7:49am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/10 "2021-08-05T07:49:23Z")
Thank you! @Darren_Murphy @Manu.n ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [August 6, 2021, 1:12am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/11 "2021-08-06T01:12:41Z")
Yeah, I’d suggest Round. Perfect 😁 ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [December 13, 2021, 5:43am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/12 "2021-12-13T05:43:59Z")
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 ? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 13, 2021, 6:17am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/13 "2021-12-13T06:17:58Z")
`Ceiling(N/100)*100` Where N is your number. ![Screen Shot 2021-12-13 at 2.16.40 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/c/bc262dd5423ced8ae04078296d36f85117cc136e.png) ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [December 13, 2021, 6:23am UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/14 "2021-12-13T06:23:10Z")
Thanks @Darren_Murphy ! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/round-up-to-nearest-hundred/30024/15 "2024-01-17T16:49:40Z")