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 Chris Miller 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
Mar 19, 2008
76
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
  • Solved
Split Function not working
Replies
3
Views
182
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question
Concatenation problem 3
Replies
5
Views
886
Moss100
Moss100
Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
513
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
2K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Adodo problem
Replies
7
Views
262
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top