Rounding up?

[Krzysztof Bartosiewicz]

Hi I need to round up a value. I tried

Int(Value*100)/100
CCur(Value/100)*100

but those functions don't work.. The problem is that if I have a value
10,195 it is converted into 10,19 instead of 10,20.. Maybe there is some
easy function which will be able to round this value just like Excel's
Round(Value,2)

I'll be grateful for help since I already lost two hours on this
Thanks in advance
Chris

 

[Krzysztof Bartosiewicz]

Finally I used
=Int(100*value+0,999)/100 but still I don't believe that there is no such
things as round.. Is there?
Chris

 

[Guest]

Try the format function
format(MyNumber,"#.##")

 

[Guest]

There is a function round , but it will round the number without decimal
places.
round(10.195)
will return 10

 

[Krzysztof Bartosiewicz]

Try the format function

format(MyNumber,"#.##")

Thanks,
Chris

 

[Guest]

Why not use
round (value*100)/100