# Help : Rounding to nearest 2 decimal points **URL:** \ **Category:** Get Help\ **Tags:** tutorials, help, resources\ **Created:** [June 17, 2020, 12:38am UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971 "2020-06-17T00:38:02Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [June 17, 2020, 12:38am UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/1 "2020-06-17T00:38:02Z")
![abs result](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/0/0be59cf7167b7301e0879582d7644c892f30dc0b.png) - For non-currencies calculating: 7408.82 ? or 7408.83 (rounding only at the 2nd digit level which seems appropriate) \*ROUND() would just remove anything after the dot (7409) 🤨 thanks for any tips 😉 Any ROUND(A\*B.2) on the roadmap ? \*2 = last digits (result is fine but only when used with a Currency formats) ---
**Author:** ![karimoo](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@karimoo](https://forum.adalo.com/u/karimoo)\ **Post date:** [June 17, 2020, 2:42pm UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/2 "2020-06-17T14:42:37Z")
I am not exactly sure, where you want to have the rounding. But you can use a combination of INT() and ROUND() with scaling factors inside and outside the functions to cut where you need it: ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/2/2ac1834d7088bad2ea5ab8ba74aa4b6e14736158.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/a/afa33eacda3bed5d64c0314f1da802b828353eff.png) or ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/4/4886d638b0f80ed8bd8985c33c9790da29a5698d.png) You can play with the scaling factors in my test app here: > **[Rounding Test](https://previewer.adalo.com/16dd6a55-feb1-4fd1-b312-eb8b0798fd4b)** > > Built with Adalo ---
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [June 17, 2020, 5:25pm UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/3 "2020-06-17T17:25:14Z")
Hi Karimoo, Yes, scales seems to be the “Truncating function” that I’m looking for, great jobs Thanks… I said seems because I cant test it yet…so how do you access this “Scale” function from ? (I cant type the word, and I dont see it in my function list. ???) 🙄 Mine only list 7 functions…😮 ![00 functions no scale](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/7321b3587fbf7040327e7c534e109c2e4324f427.jpeg) ---
**Author:** ![karimoo](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@karimoo](https://forum.adalo.com/u/karimoo)\ **Post date:** [June 18, 2020, 5:24am UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/4 "2020-06-18T05:24:12Z")
@bibipac Sorry for the confusion. Scale is not a Adalo function is just the name of the Input field I used. Just replace it with the number you want to use for scaling: With Rounding: Scale = 100 Round(77.62 x 95.45 x 100)/ 100 = 7408.82 Here you basically scale up by two digits within the ROUND() function, and scale back the rounded result. To cut it using INT() without rounding: Scale 1 = 10000 Scale 2 = 100 INT(77.62 x 95.45 x 10000/100)/10000\*100 With Scale 1 you basically decide where you want to cut using the INT() function and Scale 2 is doing the up and downscaling as in the example before. ---
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [June 18, 2020, 6:44pm UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/5 "2020-06-18T18:44:56Z")
Oh…okay, Waow…I never though that using 100 would be usefull in achieving the required 2 digit results, that’s very clever ! I must run a test now to see how this work, I got the idea but its still surpring to me ! (I m not too much of a Math person 😄 ) Anyway, Thanks you very much… indeed you seems to be the Math Guru in here…and willing to share your knowledge too… 👋 👋 🐆 ---
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [June 19, 2020, 7:56am UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/6 "2020-06-19T07:56:54Z")
Great, tested and aprooved ! though I ve used the Scale 1 config only, interesting to see that you can play on the scales ! ![scale formula](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/db4ab63e9aec6ae7f2ed9ece71f083681dce4349.png) Thanks a lot ![scaling solved](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/3/3c5e4cc4a784a11deba1734152f00ac68ea2f4c5.png) ✌ ---
**Author:** ![bgschust](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bgschust](https://forum.adalo.com/u/bgschust)\ **Post date:** [September 18, 2020, 3:07am UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/7 "2020-09-18T03:07:21Z")
@karimoo What’s the best way to do this when the trailing digits are zeroes (e.g. 57 to 57.00)? ---
**Author:** ![karimoo](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@karimoo](https://forum.adalo.com/u/karimoo)\ **Post date:** [September 26, 2020, 5:11am UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/8 "2020-09-26T05:11:38Z")
As far as I know, Adalo currently does not support different formatting of decimals for display. A workaround would be to split the decimals in a separate string and use conditional formatting to show “00” if the decimal value is zero. ---
**Author:** ![JLCSerious](https://avatars.discourse-cdn.com/v4/letter/j/71e660/32.png) [@JLCSerious](https://forum.adalo.com/u/JLCSerious)\ **Post date:** [February 22, 2021, 12:35pm UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/9 "2021-02-22T12:35:41Z")
times it by 100, round to integer, divide by 100 🙂 ---
**Author:** ![ishantanusrivastava](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ishantanusrivastava/32/34947_2.png) [@ishantanusrivastava](https://forum.adalo.com/u/ishantanusrivastava)\ **Post date:** [August 31, 2021, 8:33am UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/10 "2021-08-31T08:33:34Z")
Hi @karimoo Thank you for sharing your knowledge here but I have a question for you, this scenario not working for me when I’m applying it on the rating system that means I want to show only 2 decimal places for the average rating, Here is an example - Sum of stars = 1650 Total no. of users submitted = 450 so it should show = 3.67/5 but the result is 3.66666666667 Appreciate your help here 👍 ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [August 31, 2021, 4:51pm UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/11 "2021-08-31T16:51:38Z")
Hi @ishantanusrivastava, You can try: ROUND( ( SumStars / NumUsers) \* 100 ) / 100 Best regards, Victor. ---
**Author:** ![dasuksta](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dasuksta/32/3402_2.png) [@dasuksta](https://forum.adalo.com/u/dasuksta)\ **Post date:** [August 29, 2022, 9:24pm UTC](https://forum.adalo.com/t/help-rounding-to-nearest-2-decimal-points/1971/12 "2022-08-29T21:24:48Z")
I know it’s an old post @Victor - but the syntax just got me out of pickle - thanks bro 🤓 👍