The round function uses mathematical rules, not business or financial rules.
The mathematic round rule states that the decimal digits get rounded so that the last digit, after the rounding, is always an even number. This is sometimes why a .5 may round down and not up.
The financial rules state that this last digit doesn't matter if it is even or not.
The first digit after the decimal-place-to-round-to rounds up if >= 5, and rounds down if < 5.
Round(0.05, 1) = 0.1
Round(0.15, 1) = 0.2
Round(0.25, 1) = 0.3
Round(0.35, 1) = 0.4
Round(0.45, 1) = 0.5
Round(0.55, 1) = 0.6
Round(0.65, 1) = 0.7 [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!
By the way, I hope I wasn't misleading you with the Round().
The VBA Round function uses Mathematical rounding.
The VBA Format$ function uses financial rounding. [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!
It states Round uses business rounding rules. I don't know these rules, so I couldn't state whether this is right or not. The deals you describe do go along with the things I've noticed over the last couple of days, so I'm going along with your thoughts.
I wouldn't be surprised if the MS documentation was wrong. It wouldn't be the first time it was.
How dare you say that! LOL [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.