Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
PRB: Round Function different in VBA 6 and Excel Spreadsheet
Article ID: 194983 - View products that this article applies to.
This article was previously published under Q194983
When using the Round() function in Visual Basic 6.0, a different result may be returned than when using it in a cell formula of an Excel spreadsheet.
The VBA Round() function uses Banker's rounding while the spreadsheet cell function uses arithmetic rounding.
The Round() function in an Excel spreadsheet uses Arithmetic rounding, which always rounds .5 up (away from 0). The Round() function in Visual Basic for Applications 6, uses Banker's rounding, which rounds .5 either up or down, whichever will result in an even number.
Steps to Reproduce Behavior
For additional information on rounding, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/196652/EN-US/ )HOWTO: Implement Custom Rounding Procedures