MROUND (round to a multiple of base) |
  
|
MROUND (round to a multiple of base) |
|
Syntax:
MROUND(Number, Base)
Description:
This rounds Number to the nearest multiple of Base.
Base must be > 0.
If the remainder of the division of Number by Base is smaller than half the value of Base, MROUND rounds down. If it is greater than or equal to half the value of Base, MROUND rounds up (see examples below).
Example:
MROUND(1234.5678, 1) returns 1235
MROUND(1234.5678, 0.01) returns 1234.57
MROUND(22, 5) returns 20
MROUND(23, 5) returns 25
MROUND(22.5, 5) returns 25
See also: