PRB: Round Function different in VBA 6 and Excel Spreadsheet

PRB: Round Function different in VBA 6 and Excel Spreadsheet

瀏覽:304
日期:2025-09-30
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...看更多