Round()..... how and why.

[DirectDrive]

I have seen a lot of confusion over the Round function, all over the net and in various books. Some claim it does not work and others seem to have noticed the patter, but do not understand it..
Mathematically speaking the round function is correct, but it does not work how many people think it should. This is how it works…….
When a 5 is encountered it will round to the nearest even number, or it rounds even numbers down and odd numbers up (however you like to think about it). i.e. 2.5 rounds down to 2, 3.5 rounds up to 4.
Mathematicians round like this to combat mathematical bias and the VB round function is based on this theory.

 

[zemp]

Here are a couple of recent threads that can add to or clarify your confusion.

thread222-376567
thread222-376571
thread222-454687 Thanks and Good Luck!

zemp

 

[DirectDrive]

thanks, but i wasn't confused. i just thought i'd try to claify how Round() works since it seems to confuse a lot of people.

 

[zemp]

Yes, it can be confusing. That's why it has been discussed in threads before.

Any clarification is welcome. Thanks and Good Luck!

zemp

 

[strongm]

The real problem is not that the Round function uses a 'round to even' methodolgy (and documents it badly; the VBScript documentation is better in this respect), but that VB isn't consisitent about this with other function that also provide a rounding capability (eg FormatNumber uses a 'round to larger' algorithm)