Use this function to round numbers based on Banker’s rounding. With Banker’s rounding, values below 0.5 go down and values above 0.5 go up. Values of exactly 0.5 go to the nearest even number. In contrast, the Round function always rounds 0.5 upwards.
Note | When you add values which have been rounded using the standard method of always rounding .5 in the same direction, the result includes a bias that grows as you include more rounded numbers. Banker’s rounding is designed to minimize this. |
BankRound(Value)
Parameter |
Description |
Value |
Enter the value you want the system to round. |
Here are some examples that compare BankRound with Round:
With BankRound |
|
Whereas, with Round |
||
This |
Returns |
|
This |
Returns |
BankRound(123.425) |
123.42 |
|
Round(123.425) |
123.43 |
BanKRound(123.435) |
123.44 |
|
Round(123.435) |
123.44 |
© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.