PRB: Round Function different in VBA 6 and Excel Spreadsheet

MORE INFORMATION

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

1. In Excel, open a new spreadsheet and type the following formula into one of the cells:

          =Round(2.5, 0)
   						

2. The result is 3.
3. In Visual Basic 6.0 or other applications using VBA 6, open a new project and type the following expression into the Debug or Immediate window:

         ? Round(2.5, 0)
   						

4. The result is 2.