# Rounding up to the nearest 1000?

**URL:** <https://community.fibery.io/t/rounding-up-to-the-nearest-1000/5945>\
**Category:** Get Help\
**Created:** [March 6, 2024, 4:05pm UTC](https://community.fibery.io/t/rounding-up-to-the-nearest-1000/5945 "2024-03-06T16:05:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\
**Post date:** [March 6, 2024, 4:05pm UTC](https://community.fibery.io/t/rounding-up-to-the-nearest-1000/5945/1 "2024-03-06T16:05:06Z")

</div>

Excel has CEILING and FLOOR functions that allow you to round up or down to the closest desired integer. ROUND in Fibery only lets you define the number of decimal places.

Is there somewhat simple a way to get a number like $19,998.97 to round up to $20000?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [March 6, 2024, 4:06pm UTC](https://community.fibery.io/t/rounding-up-to-the-nearest-1000/5945/2 "2024-03-06T16:06:38Z")

</div>

> [@interr0bangr](#):
>
> Is there somewhat simple a way to get a number like $19,998.97 to round up to $20000?

It depends on your definition of simple 😉

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [March 6, 2024, 4:08pm UTC](https://community.fibery.io/t/rounding-up-to-the-nearest-1000/5945/3 "2024-03-06T16:08:48Z")

</div>

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/8/857515c5b0dea66ab0226ec930bb4b5ad4127f88.png)

---

<div class="post-metadata">

**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\
**Post date:** [March 6, 2024, 4:21pm UTC](https://community.fibery.io/t/rounding-up-to-the-nearest-1000/5945/4 "2024-03-06T16:21:44Z")

</div>

That’s simple enough for me, thank you!