Calulated Field Not Rounding Properly

  • Thread starter Thread starter azurite_1
  • Start date Start date
A

azurite_1

I'm using the following expression in a field: Round([Score],0). The results
are not always correct. These are the resuts I'm getting:

13.4 rounds to 13
13.5 rounds to 14
14.4 rounds to 14
14.5 rounds to... 14 ?!?

This holds true for all numbers. Anything "odd#.5" rounds up properly.
Anything "even#.5" rounds down.

Anyone know the reason or how to fix it? Using this same expression as a
formula in Excel gives the expected results: 13.5 to 14, and 14.5 to 15.

Thanks,
Jeff
 
This holds true for all numbers. Anything "odd#.5" rounds up properly.
Anything "even#.5" rounds down.
Click to expand...

This is called "Banker's Rounding". The rationale is that if you
always round up, the sum of an array of rounded values will be larger
than the sum of the original values; if you round up half the time and
down half the time, the sum won't shift (at least not nearly as much).

It's the way the Round function works. See the online help (by opening
the VBA editor, typing Round() into the edit box, selecting the word
and hitting F1).
 
I believe this is "bankers" rounding or something and is by design. This
would "average" your rounding to provide a more accurate presentation of
data.
 
Back
Top