Round up to next number

  • Thread starter Thread starter DevourU
  • Start date Start date
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)
 
D'oh!

-JS

xRoachx said:
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)
Click to expand...
 
Try This : Round(Your number or variable, Digits)


OldNumber = 3.1477898522
MyNewNumber = Round(OldNumber, 3)
MyNewNumber = 3.145
 
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
 
Van said:
You can use:

- Int( - [YourNumber] )

e.g.:

?-Int(-3.2)
4
Click to expand...

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

James A. Fortune
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding up! 2
how to round a number to the max value 2
Rounding - I cannot figure from previous threads 1
Preventing rounding numbers to nearest dollar 2
Round to nearest quarter 5
Rounding up to the nearest .25 1
Rounding Numbers 1
Rounding 2

Back
Top