Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Round Function Problem

Status
Not open for further replies.
v5652

v5652

Programmer
Joined
Mar 19, 2008
Messages
76
Location
IN
I have a problem with Round Function.

e.g. round(32.255,2) = 32.25 actualy it may be 32.26

can anybody has any solution for this..

 
Sort by date Sort by votes
Round is accurate for statistical purposes, but may not suit financial applications. Format should suit in most cases:

Debug.Print Round(19.955, 2)
'Answer: 19.95

Debug.Print Format(19.955, "#.00")
'Answer: 19.96

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Split Function not working
Replies
3
Views
800
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question Question
Concatenation problem
Replies
5
Views
1K
Moss100
Moss100
Moss100
  • Locked
  • Question Question
Filter vba problem
Replies
1
Views
936
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question Question
Access send email attachments - problem when null or empty
Replies
7
Views
4K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question Question
Adodo problem
Replies
7
Views
714
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top