Roundup function

[Charles]

Is there a way to force numbers to be rounded UP in VBA?

 

[Van T. Dinh]

Use:

- Int( - [YourNumber] )

For example

?-Int(-2.345)
3

 

[Rolls]

Rounded = int([Unrounded] + 0.5)