Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← The library

Math function

MROUND

Rounds a number to the nearest multiple you specify, like the nearest 5 or 0.25.

CommonDifficulty 1100 · ProficientUsage rank #139 of 520

Practice · 3 questions →

When to use it

Rounds to the nearest multiple of any number, not just powers of ten. Time to the nearest 15 minutes, prices to the nearest 0.25, quantities to pack sizes.

The shape of it

Syntax: =MROUND(number, multiple)

Worked examples

Nearest five
=MROUND(23,5) → 25
Nearest multiple of 5.
Nearest quarter
=MROUND(7.3,0.25) → 7.25
Works with fractional multiples.
Nearest 15 minutes
=MROUND(A1,"0:15") → 9:45
A1 holds 9:52. Times are numbers, so text times work as the multiple.

Worth knowing

Both arguments must have the same sign: MROUND(-23,-5) is -25.
For always-up or always-down to a multiple, use CEILING.MATH and FLOOR.MATH.
MROUND(x,1) is the same as ROUND(x,0).

Where it goes wrong

#NUM! when number and multiple have different signs.
Exact halves round away from zero: MROUND(12.5,5) is 15.

SUM SUMIF SUMIFS ROUND ABS SUMPRODUCT

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.