"System does not pass exact numeric .045. It passes numeric representation for supplied value.

There is no any system fault. System does its job perfectly.

0.045 is proper representation of 5/111.111 with...

Succeeding fine. Based on the value it receives, it returns exactly what we expect it to (except for the negative number entries). Since it receives the exact same value that...

Again, it sees the results of that division exactly the same as the internal Round() function, even though it returns a different result (it's supposed to), so I'm perfectly fine...

Lynn, I did find one problem so far, and that is with negative numbers. The following should round to -6.26, but rounds to -6.27. While I realize that it seems...

That has nothing to do with Lynn's function. Round() also sees the result of your input parameters as .045, followed by nothing but zeroes as far as the eye can see.

Lynn, initial tests on the decimal version look pretty good. It even passed Sergiy's test, as can be seen below. When his 5/111.111 is passed to the function, it receives 0.04500000000000000000,...

Sergiy claims that the concept of BR is crap, even if perfectly implemented. That's where most of us have a beef with him.

While we all agree that the BR implementation...

Well, you can either read all 37 pages, or if you'd rather, here is one of the recaps we've had in the thread so far.

Hey Threadshitter, remember we have another thread for that purpose. One, it's not my implementation. Two, it's actually pretty close to perfect (I think it's already there for floating point...

Remember, we created a whole thread for you to take a dump in. This one isn't it.

"So, which version of BR you suggest to use?"

The appropriate one.

"Which one will return consistently right results?"

Both, when used in the appropriate situations.

Much like I don't try to cast...

It depends somewhat on what version of Visio you are using, but you'll likely find it somewhere like "Tools" -> "Add-Ons" -> "Visio Extras" -> "Database Wizard".

You'll have to create...

Why would I need Banker's Rounding to handle the exact numeric ".8"?

Oh, I didn't know you just needed the answer so badly that it required an exclamation point. In Banker's rounding, to 2 digits scale, it's 612.94, to 1 digit, it's...

Quite easily actually. Using your thumb, you count just like they did, stopping after completing the second joint on all four fingers. Let us know what else we can help...