Sum, Count & Average

Excel formula for Round to the nearest multiple

Round a value to the nearest 5, 10, 0.25, or any multiple.

Copy this formula

=MROUND(A2, 5)

How the formula works

MROUND rounds to the nearest multiple of the second argument. Use CEILING to always round up to a multiple or FLOOR to always round down — handy for pricing, packaging, and time blocks.

Examples

=MROUND(7.3, 0.25)→7.25

Rounds to the nearest quarter.

Other ways to do this

Always round up

=CEILING(A2, 5)

Up to the next multiple of 5.

FAQ

Why does MROUND return #NUM!?

The number and the multiple must share the same sign. Use the same sign for both arguments.

Related formulas

Round a number to set decimals Get the remainder or whole number

Functions used

MROUND CEILING FLOOR

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free