BankRound Function

Returns the number rounded to the number of decimal places using the rules of bankers rounding.

Syntax

Remarks

• With bankers rounding, note that .5 (.05, .005, etc) can round up sometimes and down sometimes. When the number to round is exactly halfway between two rounded values, the result is the rounded value that has an even digit in the far right decimal position. So both 1.5 and 2.5 round to 2, and 3.5 and 4.5 both round to 4. This process is also known as rounding toward even, or Gaussian rounding.

• Example: BankRound(2.55, 1) returns 2.6.

• Example: BankRound(2.45, 1) returns 2.4.