No, mrpolecat needs to know how you want to handle ties, whether they be in the form of even number of rows for median, or equal maximum frequencies for mode. I'll...

While this is a trick on his part, I actually agree with him, even though he'll disagree with what this function should do with it (he can take that to...

"Can you prove it?

You still failed to supply 2/3 as a parameter to BR."

Absolutely, I just fired up .NET 2003 and ran the following line:

Debug.Write(Math.Round(2 / 3, 3))

It returns...

I put ROUND() in my post so that you could repeat the calculation. Apparently you are the only person in this thread who thinks .666 is the proper representation for...

"What do you think is the result of

select 2./3000 * 1000"

No. Seriously, did you think we'd fall for that. You're using implicit conversion issues to intentionally introduce bugs. The built-in...

Why should I try again?

SELECT Round(2.0/3.0,3) returns .667000. That's where the "7" comes from.

Remember, we're not arguing the function as written, which is flawed, even after you "fixed" it. You're...

I'll try and summarize the Wiki entry that is in the code comments, so that everyone understands what it is supposed to do.

Banker's rounding is identical to traditional rounding with...

Actually, you didn't "fix" the function, as it doesn't yet use a true "Banker's Rounding" algorithm. That's what the other thread is for.

You did, on the other hand, fix one of...

"I passed to BR 2 representations of the same value 0.12514568:

with 3 digits precision and with 4 digits precision.

I've got different results from this function."

As would be expected. A function...

At this point, since I think I've provided convincing evidence that this is often required, whether you consider it complete crap or the holy grail, I'm going to start another...

The round-to-even method, aka "Banker's rounding" among many other names, is an ASTM standard as noted in the following places:

http://exceltips.vitalnews.com/Pages/T1055_Rounding_Religious_Wars_Take_Two.html

http://en.wikipedia.org/wiki/Rounding

http://www.modot.gov/business/materials/pdf/vol_1/GS007.pdf (it's a PDF, but it's a governmental...

Now you're just being stupid (okay, that's actually not true, as you didn't just start with that post).

2/3 can't be passed to the built-in Round() function either, as the computer...

I already did and posted the code.

If you have a next digit, it takes it into account. If you don't have a next digit, it doesn't. It's a function, and like all functions, it works with...

"Still rounding truncated value, not 2/3.

You stated in this topic that truncated value is not the same as non-truncated.

So, you failed to rounf 2/3."

Are you seriously blaming banker's rounding...