PRB: Round Function different in VBA 6 and Excel Spreadsheet

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...

support.microsoft.com