Hi,
Found this
http://support.microsoft.com/kb/196652#top
As you will note Microsoft applications round inconsistently and the reason
is ....Historical... Well that clears that up :)
Mike
"Mike H" wrote:
Hi,
I'm not sure what the reassurance is you are looking for. Worksheet
functions don't use 'Bankers' rounding so the result for .5 is always up. The
VB round function uses 'bankers' rounding hence n.665 rounds to n.66.
I'm sure there's a more involved explanation somewhere but in the meantime
HTH.
Mike
"Ken Hudson" wrote:
Just looking for some reassurance in my thought process.
I want to multiply 31.11 by 1.5 in VB and I want VB to round the answer to
46.67.
Using the Round function will give me 46.66.
Using Application.Round is the method I need to get 46.67, correct?
--
Ken Hudson