# Decimal conversion in formula

**URL:** <https://community.fibery.io/t/decimal-conversion-in-formula/1323>\
**Category:** Get Help\
**Created:** [February 1, 2021, 7:28am UTC](https://community.fibery.io/t/decimal-conversion-in-formula/1323 "2021-02-01T07:28:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![haydnhkim](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/haydnhkim/32/1430_2.png) [@haydnhkim](https://community.fibery.io/u/haydnhkim)\
**Post date:** [February 1, 2021, 7:28am UTC](https://community.fibery.io/t/decimal-conversion-in-formula/1323/1 "2021-02-01T07:28:23Z")

</div>

When adding formula scripts, it is difficult to handle decimal.  
How to floor, ceil, or round decimal?  
Decimal cannot be changed to string using ToText, so regex cannot be used.

I want to know the conversion function for decimal.  
Thanks!

---

<div class="post-metadata">

**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\
**Post date:** [December 3, 2021, 2:30pm UTC](https://community.fibery.io/t/decimal-conversion-in-formula/1323/2 "2021-12-03T14:30:34Z")

</div>

Hi!  
Finally we’ve added Round() function 🙂

## Round() functions

Round() function rounds a number to the specified number of decimal places. There are also two more:

**RoundDown(number[, places])**  
Rounds a number down to the specified number of decimal places

**RoundUp(number[, places])**  
Rounds a number up to the specified number of decimal places

```auto
Round(1.154, 1) → 1.2 
RoundDown(9.999, 2) → 9.99
RoundUp(12.001, 1) → 12.1

```

---

<div class="post-metadata">

**Author:** ![haydnhkim](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/haydnhkim/32/1430_2.png) [@haydnhkim](https://community.fibery.io/u/haydnhkim)\
**Post date:** [January 22, 2022, 5:35am UTC](https://community.fibery.io/t/decimal-conversion-in-formula/1323/4 "2022-01-22T05:35:44Z")

</div>

I’m using Round feature well!  
thanks!