# Round Decimal in WebApp

Hi,
I have a decimal like `0.9876`
I want to round this two digits after the point: `0.99`

But no function gives me what I want.

Whats the solution?

-Lars

[quote=160923:@Lars Lehmann]Hi,
I have a decimal like `0.9876`
I want to round this two digits after the point: `0.99`

But no function gives me what I want.

Whats the solution?

-Lars[/quote]

[code] dim d as double

d=ceil(0.9876*100)/100

msgbox str(d)[/code]

You will need to decide when using Floor and Ceil is necessary. For instance, when the third decimal > 5 use Ceil, and otherwise use Floor, so 0.9876 gives 0.99 and 0.9846 gives 0.98.

I’ve probably bite the bullet and write my own function

Of course there is: Round. But you’ll still have to temporarily “move” the decimal like MIchel does.

Or you could use Format, but you’ll have to convert it back to a double, if needed :

```dim d as double d = Val(Format(0.9876,"#####0,##"))```

[quote=160943:@Lars Lehmann]lol there’s no ready function?

I’ve probably bite the bullet and write my own function :/[/quote]

What is wrong with the two lines I posted ? ? ?

nothing @Michel Bujardet
Thanks! I only thought theres a build-in function

[quote=161282:@Lars Lehmann]nothing @Michel Bujardet
Thanks! I only thought theres a build-in function ;)[/quote]

From what I can see, Round http://documentation.xojo.com/index.php/Round is exactly that. Except you cannot decide which kind of rounding you apply. I think in particular about such things as the kind of rounding used for petty cash.