Round up to next number

[DevourU]

I need to round up to nearest number. 3.2 is 4, 3.9 is 4. TIA folks!

-JS

 

[Guest]

As far as I know, there isnt a VBA function for this. But you can use a
worksheet function. Be sure to include a reference to the Excel Object
library. To use use the Roundup function from Excel, try:

WorksheetFunction.Roundup (YourField,0)

 

[DevourU]

D'oh!

-JS

As far as I know, there isnt a VBA function for this. But you can use a
worksheet function. Be sure to include a reference to the Excel Object
library. To use use the Roundup function from Excel, try:

WorksheetFunction.Roundup (YourField,0)

 

[Guest]

Try This : Round(Your number or variable, Digits)


OldNumber = 3.1477898522
MyNewNumber = Round(OldNumber, 3)
MyNewNumber = 3.145

 

[Lynn Trapp]

Round([SomeNumberField] + .49999999) will always round up to the next
number.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Try this plugging in this function:

Public Function RoundUp(dblNumberToRoundUp As Double)

Dim intRounded As Integer

intRounded = Round(dblNumberToRoundUp, 0)

If intRounded < dblNumberToRoundUp Then
intRounded = intRounded + 1
End If

RoundUp = intRounded

End Function

 

[DevourU]

That's it. I couldn't put that together, brain dead day.

-JS

Round([SomeNumberField] + .49999999) will always round up to the next
number.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

I need to round up to nearest number. 3.2 is 4, 3.9 is 4. TIA folks!

-JS

 

[Van T. Dinh]

You can use:

- Int( - [YourNumber] )

e.g.:

?-Int(-3.2)
4

 

[James A. Fortune]

You can use:

- Int( - [YourNumber] )

e.g.:

?-Int(-3.2)
4

It's so concise (and correct) that I can't improve on it. Well done.

James A. Fortune