Rounding Error

[Mike]

Worksheet function =Round(0.965,2) returns 0.97
Using VBA Round(0.965,2) returns 0.96.
Why does the VBA function not work properly?

 

[Ron Rosenfeld]

Worksheet function =Round(0.965,2) returns 0.97
Using VBA Round(0.965,2) returns 0.96.
Why does the VBA function not work properly?

VBA's round does work properly. It just uses a different rounding method,
sometimes called banker's rounding. This is outlined in the MSKB article
225330.

Briefly, if the number to the right of your rounding point is '5', and the
number to the left is even, then the number will get rounded down.

So (0.965,2) --> 0.96
(0.955,2) --> 0.96


--ron

 

[Arvi Laanemets]

Hi

I'm not sure (I haven't used rounding in excel VBA ever), but it looks
pretty like so-called banker's rounding for VBA (a tie is rounded up or down
depending the value is even ur uneven). PS. Banker's rounding is used in MS
Access.


Arvi Laanemets