Round KO by VBA

[Maurizio]

Hi all,
I need round 432,605 (two decimal places);
But by VBA I get KO: 432,60

Sub Arrot()

TotRighe = Sheets("DB").Cells(65536, 4).End(xlUp).Row
For x = 1 To TotRighe
Cells(x, 5) = Round((Cells(x, 4)), 2)
Next x

End Sub

instead by formula:

"=ROUND(RC[-2],2)" I get OK: 432,61


Why?
Tia Maurizio

 

[Colo]

Tia, Round in VBA returns an even number that is called "bankers' rounding", C# as well. If you need the same result as on a worksheet, try "WorksheetFunction.Round" instead.

 

[Maurizio]

Hi Colo,
perfect! many thanks.

maurizio

 

[Maurizio]

Hi, so... what's the difference between:

"WorksheetFunction.Round" and "Application.Round"

Tia.