round the decimals up

[omerdurdu]

I wonder how can I round the decimal up.
Lets say I have something like 1.025, I would like to round this number up like 1.03 or 1.022 round this number just down 1.02.
Is there anyway to do this.
Thanks

 

[csteinhilber]

I believe you're looking for

Ceiling(number)

Hope it helps,
-Carl

 

[omerdurdu]

Thanks for replying
Ceiling(1.025) = 2
It is taking closest integer
I am looking for something: it will give me to decimals and the decimal will round up like this:

1.025 will be 1.03
1.022 will be 1.02
1.455555 will be 1.46

Thanks

 

[csteinhilber]

NumberFormat does that automatically (rather annoying, actually, when you don't want it to)

#NumberFormat(mynum,"_____.__")#

Hope it helps,
-Carl