I've been programming Access for 10 years and am embarrased to ask this
question, but here goes. I'm using a template and am making minor
adjustments. I've never heard of rounding, What is the difference between:

=ROUND(SUM(AB29:AB36),5)

and

SUM(AB29:AB36)

Rhonda

H

=ROUND(0.000004+1,5)
returns 1.00000
=ROUND(0.000005+1,5)
returns 1.00001

PS! There is same function in Access too, but Access uses 'Bankes rounding'
algorithm.


Arvi Laanemets


"R Marko" wrote in message
...
I've been programming Access for 10 years and am embarrased to ask this
question, but here goes. I'm using a template and am making minor
adjustments. I've never heard of rounding, What is the difference
between:

=ROUND(SUM(AB29:AB36),5)

and

SUM(AB29:AB36)

Rhonda

"Arvi Laanemets" wrote:
....
PS! There is same function in Access too, but Access uses 'Bankes rounding'
algorithm.

So does the round function in Excel's VBA.

Have bankers ever rounded in this way? If not, how did it come to be called
"bankers rounding"? My question is on terminology, not methodolgy. The
method has been advocated for decades by ASTM and most other standards
bodies, but the MS KB terminology seems to be without support.

Jerry

Hi

Google search didn't give any clear relation between bankers and 'bankers
rounding' :-), but I stumbled there over a link with a lot of interesting
stuff about subject:
http://ewbi.blogs.com/develops/2003/...und_yet_a.html



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Jerry W. Lewis" wrote in message
...
"Arvi Laanemets" wrote:
...
PS! There is same function in Access too, but Access uses 'Bankes
rounding'
algorithm.

So does the round function in Excel's VBA.

Have bankers ever rounded in this way? If not, how did it come to be
called
"bankers rounding"? My question is on terminology, not methodolgy. The
method has been advocated for decades by ASTM and most other standards
bodies, but the MS KB terminology seems to be without support.

Jerry

The author wasn't joking when he warned that "this post gets long"; I was
hard pressed to find a point in all of that verbage, but I did learn
something from his use of FormatNumber to always round 5's up (which I rarely
want to do).

His concern that the VBA Round() function is much more sensitive to binary
representations than the Excel Round() function is something that I have been
pointing out for years in these news groups, with the recommendation that you
rescale to round to the nearest one and then use Round(CDbl(CStr(x)),0) to
avoid surprises
http://groups.google.com/group/micro...7fce6145b70d69

I would have liked to follow his Eric Lippert Banker's Rounding link, but it
is currently unavailable.

Jerry

"Arvi Laanemets" wrote:

Hi

Google search didn't give any clear relation between bankers and 'bankers
rounding' :-), but I stumbled there over a link with a lot of interesting
stuff about subject:
http://ewbi.blogs.com/develops/2003/...und_yet_a.html



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Jerry W. Lewis" wrote in message
...
"Arvi Laanemets" wrote:
...
PS! There is same function in Access too, but Access uses 'Bankes
rounding'
algorithm.

So does the round function in Excel's VBA.

Have bankers ever rounded in this way? If not, how did it come to be
called
"bankers rounding"? My question is on terminology, not methodolgy. The
method has been advocated for decades by ASTM and most other standards
bodies, but the MS KB terminology seems to be without support.

Jerry

Why would we use rounding rathen than the simple formula, if the result is
currency format?

"Arvi Laanemets" wrote:

H

=ROUND(0.000004+1,5)
returns 1.00000
=ROUND(0.000005+1,5)
returns 1.00001

PS! There is same function in Access too, but Access uses 'Bankes rounding'
algorithm.


Arvi Laanemets


"R Marko" wrote in message
...
I've been programming Access for 10 years and am embarrased to ask this
question, but here goes. I'm using a template and am making minor
adjustments. I've never heard of rounding, What is the difference
between:

=ROUND(SUM(AB29:AB36),5)

and

SUM(AB29:AB36)

Rhonda

See

http://www.mcgimpsey.com/excel/pennyoff.html

for some examples.

In article ,
R Marko wrote:

Why would we use rounding rathen than the simple formula, if the result is
currency format?

I get it now. Thank you

"JE McGimpsey" wrote:

See

http://www.mcgimpsey.com/excel/pennyoff.html

for some examples.

In article ,
R Marko wrote:

Why would we use rounding rathen than the simple formula, if the result is
currency format?