MROUND Function Examples in Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 9, 2023
Download Example Workbook

Download the example workbook

This tutorial demonstrates how to use the MROUND Function in Excel to round a number to a specified multiple.


How to use the MROUND Function

The MROUND Function rounds a number to the nearest multiple.

Round to Nearest 5, 50, or .5

To round to the nearest 5, set the multiple argument to 5.



Alternatively, you can round to the nearest .5 or 50 by changing the multiple argument.

Mround Combination

Round to Nearest Quarter

You can also round a price to the nearest quarter by setting multiple = .25.


MRUND Nearest Quarter

Round Time

The MROUND Function makes it easy to round time. To round time to a certain increment, just enter your desired unit of time using quotations. Here we will round the nearest 15 minutes.


Round Time

Other ROUND Functions / Formulas

Excel / Google Sheets contains many other round functions. Here are quick examples of each:

Other ROUND Function

Read our tutorials to learn more:

Excel Date Functions
Round Formulas Mega-Guideyes
ROUND - Round Numbers
ROUNDUP - Round Numbers Up
ROUNDDOWN - Round Numbers Down
MROUND - Round to Multiple
CEILING - Round Up to Multiple
FLOOR - Round Down to Multiple
TRUNC - Trim off Decimal
INT - Get Integer Portion of Number

Below, we will point out a few functions in particular.


The FLOOR and CEILING Functions work exactly the same as the MROUND Function, except the FLOOR function always rounds down and the CEILING function always rounds up.


Mround Floor CEILING

ROUND Function

Instead of using the MROUND Function to round to a multiple, you can use the ROUND Function to round a number to a certain number of digits.


Round Nearest Cent

MROUND in Google Sheets

The MROUND Function works exactly the same in Google Sheets as in Excel:


MROUND Examples in VBA

You can also use the MROUND function in VBA. Type:


AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions