Edit

Round (number, places [, mode])

Result Type: Number

Definition: Returns number rounded to places decimal places. Bankers rounding is used by default.

Examples:  Round(457.9865, 2)

returns 457.99.

Round(457.9865, 0)

returns 458.

Round(457.9865, -1)

returns 460.

In v9.0.1 and later, the optional mode parameter can be used to specify how to treat halves (i.e. an exact 5 at the place to be rounded away). Valid mode parameters are `RoundHalfEven` (i.e. Banker's or Gaussian rounding, the default), and `RoundHalfAwayFromZero` (primary school rounding; effectively always rounding a half cent "up").