VBA rounding problem

by

The reason is the limited precission that can be stored in a floating point variable.
For a complete explanation you shoud read the paper What Every Computer Scientist Should Know About Floating-Point Arithmetic, by David Goldberg, published in the March, 1991 issue of Computing Surveys.

Link to paper

In VBA the default floating point type is Double which is a IEEE 64-bit (8-byte) floating-point number.

There is another type available: Decimal which is a 96-bit (12-byte) signed integers scaled by a variable power of 10
Put simply, this provides floating point numbers to 28 digit precission.

To use in your example:

a = CDec(61048.4599674847)
b = CDec(154553063.208822)
c = a + b   
debug.print c
Result: 
154614111.6687894847

More Related Contents:

  1. Sequence of numbers based on start and end value of 2 cells [closed]
  2. Function to convert column number to letter?
  3. Read/Parse text file line by line in VBA
  4. Better way to find last used row
  5. 2 Dimensional array from range [closed]
  6. filter out multiple criteria using excel vba
  7. How can I create a calendar input in VBA Excel?
  8. Using Google Chrome in Selenium VBA (Installation Steps)
  9. Dir() function not working in Mac Excel 2011 VBA
  10. Excel VBA code to copy a specific string to clipboard
  11. VBA: Convert Text to Number
  12. Concatenate cell data into another data if values matches
  13. Iterating through populated rows
  14. Using VBA to detect which decimal sign the computer is using
  15. Referencing Excel Userform Control Name Value From String (VBA)
  16. Loop through each row of a range in Excel
  17. Fill formula down till last row in column
  18. Outputting Excel rows to a series of text files
  19. How to create a range from two ranges in VBA?
  20. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  21. If string contains word from list, return value adjacent to list value
  22. Refreshing all the pivot tables in my excel workbook with a macro
  23. Countif With Multiple OR Criteria
  24. Vlookup to copy color of a cell
  25. excel vba freeze pane without select
  26. Converting a string representation of a constant into a constant?
  27. Macro to export MS Word tables to Excel sheets
  28. VBA WinHTTP to download file from password proteced https website
  29. Function Overloading and UDF in Excel VBA
  30. VBA Excel simple Error Handling

Leave a Comment