Find Code:
All Words
Any of the Words
Exact Phrase
Home
:
Code
:
Forums
:
Submit
:
Mailing List
:
About
:
Contact
Code
All
VB.NET
ASP.NET
C#
VB Classic
ASP Classic
Snippets
Popular
Resources
Submit Code
Forums
Articles
Tips
Links
Books
Contest
Link to us
Round Function
Author:
Rohit Chuadhary
E-mail:
Click to e-mail author
Submitted:
8/30/2004
Version:
VB5
Compatibility:
VB5, VB6
Category:
Mathematics
Views:
19163
The built-in round is not 100% perfect. So I tried to make my own. Please mail me if anybody finds any bug.
Declarations:
'none
Code:
Public Function RoundF(Number, Optional NumOfDigits As Long) As Double If Not IsNumeric(Number) Then Exit Function Dim iPos As Long iPos = InStr(Number, ".") Dim dbDesimalPart As Long Dim dbRoundPart As Long If iPos > 0 Then dbDesimalPart = Mid(Number, iPos + 1) End If If NumOfDigits < Len(CStr(dbDesimalPart)) Then dbRoundPart = Mid(dbDesimalPart, NumOfDigits + 1, 1) End If If dbRoundPart > 4 Then dbDesimalPart = Left(dbDesimalPart, NumOfDigits) + 1 Else dbDesimalPart = Left(dbDesimalPart, NumOfDigits) End If RoundF = Val(Int(Number) & "." & dbDesimalPart) End Function
Home
|
Forums
|
Submit
|
Books
|
Mailing List
|
Advertising
|
About
|
Contact
© 2024 A1VBCode. All rights reserved.
Legal disclaimer & terms of use
Privacy statement