# MROUND Function Examples in Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 9, 2023

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.

``=MROUND(B3,5)``

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

### Round to Nearest Quarter

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

``=MROUND(A2,0.25)``

### 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.

``=MROUND(B3,"0:15")``

## Other ROUND Functions / Formulas

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

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

### FLOOR and CEILING

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(B3,5)
=FLOOR(B3,5)
=CEILING(B3,5)
``````

### 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(B3,2)``

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:

``Application.Worksheetfunction.Mround(number,multiple)``