Rounding up?

  • Thread starter Thread starter Krzysztof Bartosiewicz
  • Start date Start date
K

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
 
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
 
There is a function round , but it will round the number without decimal
places.
round(10.195)
will return 10
 
Back
Top