Rounding up?

  • Thread starter Krzysztof Bartosiewicz
  • 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
 
K

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
 
O

Ofer

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