<< Click to Display Table of Contents >> MROUND (round to a multiple of base) |
Syntax:
MROUND(Number, Base)
Description:
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: