MROUND (round to a multiple of base)

<< Click to Display Table of Contents >>

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:

FLOOR, CEILING, ROUNDDOWN, ROUNDUP, ROUND, TRUNC, INT