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