MROUND Function in Excel: Round to the Nearest Multiple

📎 This article includes 1 downloadable practice file ↓

MathLevel: IntermediateAvailable in: Excel 2007+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. Common errors and fixes
6. MROUND in practice
7. Where you will use it
8. Worked example
9. Mistakes people make
10. Related functions
11. Continue learning

MROUND rounds to the nearest multiple you choose — prices to ₹5, times to 15 minutes.

Syntax

=MROUND(number, multiple)

Argument	What it means
multiple	E.g. 5, 0.05, or “0:15” for 15 minutes.

Examples

Example 1

=MROUND(B2, 5)

₹123 → ₹125.

Example 2

=MROUND(A2, "0:15")

Round a time to the nearest quarter hour.

Common errors and fixes

You see	Why, and the fix
#NUM!	number and multiple have different signs.

MROUND in practice

Where you will use it

• Round to nearest ₹5 for cash
• Nearest 0.05 for pricing
• Nearest 15 minutes

Worked example

Value	Multiple	Formula	Result
487	5	=MROUND(A2,B2)	485
1.23	0.05	=MROUND(A3,B3)	1.25
22	15	=MROUND(A4,B4)	15

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Different signs	MROUND(-5,2) gives #NUM!
Midpoints	Halves round away from zero

Related functions

ROUND · CEILING.MATH · FLOOR.MATH

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Math & Trig guides →

RANDARRAY Function in Excel: A Whole Grid of Random NumbersRANDARRAY returns an array of random numbers, optionally whole numbers between limits — instant…PERCENTOF Function in Excel: Share of the TotalPERCENTOF returns a subset’s share of a total — mostly used inside GROUPBY and…RAND Function in Excel: Random Decimal Between 0 and 1RAND returns a new random number between 0 and 1 on every recalculation —…RANDBETWEEN Function in Excel: Random Whole Numbers for Test DataRANDBETWEEN returns a random integer between two numbers. It recalculates on every change —…

📎 Practice files for this article

• 📗
  Practice workbook: Math & rounding24 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.