Round a number to a specified multiple

Round a number to a specified multiple

To do this task, use the MROUND function.

EXAMPLE

The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

1 2 3 4 5

A B Formula Description (Result) =MROUND(16, 5) Rounds 16 to a nearest multiple of 5 (15) =MROUND(-16, -5) Rounds -16 to a nearest multiple of -5 (-15) =MROUND(2.6, 0.08) Rounds 2.6 to a nearest multiple of 0.08 (2.64) =MROUND(5, -2) Returns an error, because 5 and -2 have different signs (#NUM!)

Categories: ROUND