Round function in Excel, worksheet function vs VBA

by

It’s a known issue. The VBA Round() function uses Banker’s rounding while the spreadsheet cell function uses arithmetic rounding. Check the details here:

PRB: Round Function different in VBA 6 and Excel Spreadsheet

The workaround proposed by Microsoft is to write a custom function to get the desired results.

Banker’s rounding always rounds 0.5 to the nearest even number and is standard in accounting, which is why Excel works that way. Arithmetic rounding rounds 0.5 up to the next number.

More Related Contents:

  1. Unprotect VBProject from VB code
  2. Assign event handlers to controls on user form created dynamically in VBA
  3. How to count up text of a different font colour in excel
  4. VBA: How to delete filtered rows in Excel?
  5. Excel VBA Userform – Execute Sub when something changes
  6. simple vba code gives me run time error 91 object variable or with block not set
  7. VBA Function argument list select
  8. Excel VBA wildcard search
  9. Reading Web Pages using Excel VBA
  10. delete Autofilter Field resullt using the header Name
  11. Somehow it’s not copying [closed]
  12. Application.Match gives type mismatch
  13. Protecting cells in Excel but allow these to be modified by VBA script
  14. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  15. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  16. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  17. How do I name a spreadsheet automatically, by referencing two cells?
  18. Excel VBA Delete Rows
  19. Determine whether user is adding or deleting rows
  20. How to use VBA SaveAs without closing calling workbook?
  21. How to add parameters to an external data query in Excel which can’t be displayed graphically?
  22. How to continue the code on the next line in VBA
  23. Getting Excel to refresh data on sheet from within VBA
  24. VBA Password Input with Cancel Function
  25. Finding first blank row, then writing to it
  26. Calling regasm without administrative rights for COM interop in Excel VBA
  27. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  28. How do I activate a specific workbook and a specific sheet?
  29. Delete all data rows from an Excel table (apart from the first)
  30. Start VBA macro when editing a cell

Leave a Comment