MROUND Function in Excel | How to Round Numbers to the Desired Multiple

Опубликовано: 12 Апрель 2026
на канале: Excel Tutorial
3,202
13

If you need to round a number to a certain multiple, the MROUND function can help. The MROUND Formula takes one argument, the number that you want to round to the desired multiple.
============================================================
Learn More:- https://www.exceltutorial.net/
============================================================
🧑‍🏫 Round Functions and Formulas Playlist:-    • Round Functions & Formulas In Excel  
============================================================
This function is especially useful when working with financial data or other numerical values.

In this Video, we will walk through an example of how to use the MROUND function in Excel. We will also provide a downloadable template that you can use for your own projects!

First let's understand syntax and argument of MROUND function;

MROUND(number, multiple). In this function "number" is the value which you want to round and "multiple" is

the number to which you want to round the first argument.

The MROUND function rounds a number up or down to the nearest number that is an integer multiple of another number. For example, if you want to round a number to the nearest multiple of five, you can use MROUND.

Table of Contents;

00:00 Introduction

00:30 MROUND Function in Excel

07:50 Conclusion

Other Playlists:-

Financial Functions in Excel -    • Financial Function  in Excel  

Cell References in Excel -    • Cell References In Excel  

Logical Functions in Excel :-    • Logical Functions  

Count and Sum Functions in Excel -    • Count And Sum Function  

Learn Data Validation In Hindi:    • Learn Data Validation In Hindi  

Learn Excel Tutorials Online:-    • Learn Excel Tutorials In Hindi  

Excel Analysis Tutorial:    • Excel Analysis Tutorials  

🧑‍🏫 Statistical Functions Playlist:-    • Statistical Formulas in Excel