Round Up 
Author Message
 Round Up

Is there a better way or any pitfalls using

Public Function RoundUp(vNumer as Variant) as variant
    ' Pos numbers only are input
    RoundUp = -Int(-vNumber)
End Function

to round up.



Mon, 13 Dec 2010 01:05:00 GMT  
 Round Up
That looks like a pretty good way to do it as far as I can see (as long as
you are talking about rounding up to an integer value). And I don't see any
possible pitfalls in that method.

Rick


Quote:
> Is there a better way or any pitfalls using

> Public Function RoundUp(vNumer as Variant) as variant
>    ' Pos numbers only are input
>    RoundUp = -Int(-vNumber)
> End Function

> to round up.



Mon, 13 Dec 2010 01:53:37 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Round buttons round forms

2. Dial Ups

3. Microsoft Press More Than 300 Titles + FREE UPS Ground shipping

4. Outlook Hang ups

5. Pop-ups in MS Office

6. Dial Ups

7. Default Dial Ups

8. Anyone worked with UPS Online Tools

9. SET UPS: Please Stop... AND Lood

10. VBA ups & downs

11. New UPS System 6-8 Hours Continuous Service

12. UPS Online Tools Using VB

 

 
Powered by phpBB® Forum Software