Roundup function

Charles · Jan 23, 2004

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

Van T. Dinh · Jan 24, 2004

Use:

- Int( - [YourNumber] )

For example

?-Int(-2.345)
3

Rolls · Jan 25, 2004

Rounded = int([Unrounded] + 0.5)

roundup function	3	Jan 15, 2009
Roundup Function	5	Feb 24, 2009
Roundup	3	Jul 22, 2011
Using Roundup in an IF Statement	2	Dec 8, 2009
Rounding Up question	2	Apr 15, 2010
how do i use the roundup function	7	Jun 10, 2009
ROUNDUP Function	1	Sep 5, 2007
Combined ROUNDUP	5	Oct 9, 2007

Ask a Question