BankRound
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. |
Syntax
BankRound(Value)
Parameter |
Description |
Value |
Enter the value you want the system to round. |
Example
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 |