MROUND

Returns a number rounded to the nearest multiple of the specified value. The rounding follows standard rules: if the remainder is halfway between two multiples, the number is rounded up.

Parameter List

Syntax
MROUND(numbermultiple)
number

The value to round. For example, A1 or 10.

multiple

The multiple to which the number is to be rounded. For example, A2 or 2.

Examples

MROUND(10, 3) returns 9
🍪

We use cookies to enhance your user experience and analyze website performance. You can revoke consent anytime. Learn more.