How to Round number to nearest 2 decimal places

[Jonathan_S]

example.

1.12323524123 = 1.12
1.125 = 1.13
1.46832 = 1.47
1 = 1
1.1 = 1.1

Searched in Doc, No real documentation on how to configure this in the Round Function.

Any help would be greatly appreciated

Thanks,

[Bahbus]

The only limiting factor on decimal places is within a Decimal column’s settings.

[Jonathan_S]

well for now i’ve created a virtual column of type decimal and set to 2 places and than use that. But was hoping there was something easier/more compact.

Is what i’ve done the best way?

[Bahbus]

Really the only way. Outside of using text manipulation, which would still require a VC.

[Jonathan_S]

To bad, ok thanks.

[Marc_Dillon]

ROUND( [Decimal] * 100) / 100.0

[Rehabman]

Thanks Marc.    been trying all day to do this.   I had to add a step the convert it to decimal first.  I'm using it in an appsheet form:

this converts:

18.123456   to  18.12

ROUND(DECIMAL([profit_1]/[Col_valuel]) * 100.00)/ 100.00

[Aleksi · Accepted solution]

If you create an Event action with Marc’s formula you can convert it without any additional column.

[Lynn]

@Aleksi
Thanks, just needed that.

[Jonathan_S]

Ahh, interesting

So Really that is the solution

[Lynn]

I had a spreadsheet ROUND formula in an extra column but will try this from @Aleksi

[Tommaso_Miglior]

Actually there is a beardtrick.
for example, you got 123456,789 but you bust need 123456,79.

ROUND(123456,789)+ROUND((123456,789-ROUND(123456,789))*100)/100

123456+ROUND((123456,789-123456)*100)/100

123456+ROUND(0,789*100)/100

123456+ROUND(78,9)/100

123456+79/100

123456+0,79

123456,79

Math magic

[Marc_Dillon]

Tommaso_Migliorini:

ROUND(123456,789)+ROUND((123456,789-ROUND(123456,789))*100)/100

No.

Marc_Dillon:

ROUND( [Decimal] * 100) / 100.0

Way shorter, same result. Not to mention that your expression wouldn’t work in Appsheet because you divided by 100 instead of 100.0.